Ask a Question Sign up for Free 73 Experts currently online. Ask Questions for Free!

Edit box covers cell above - Mac Excel

When I edit a cell in Excel X, a white box comes up and covers up the cell above the cell I am editing. How do I get rid of that "feature". If I want to put a formula in a cell that contains a reference to the cell above ...

Results 1 to 4 of 4

  1. #1

    Edit box covers cell above

    When I edit a cell in Excel X, a white box comes up and covers up the cell
    above the cell I am editing. How do I get rid of that "feature". If I want to
    put a formula in a cell that contains a reference to the cell above the one I
    am putting the formula in, I can't click the cell above to select it.

    Thanks,
    DJ
    DJ
  2. #2

    Re: Edit box covers cell above

    In article <22d0501c45e4c$d4d9b760$gbl>,
    "DJ" <com> wrote:
     

    Try Preferences/Edit, uncheck the "Edit directly in cell" checkbox. You
    can then select all cells, and, additionally, have the advantage of
    selecting the precedents of a cell by double-clicking on it.

    OTOH, all you have to do is use the up arrow to select the cell above...
    JE
  3. #3

    Re: Edit box covers cell above

    JE McGimpsey <org> wrote:
     

    Or make the row heights larger.
    --
    Roger
    Roger
  4. #4

    Re: Edit box covers cell above

    fsnet.co.uk.invalid (Roger Morris) wrote in message news:<1gg6ti9.1vg8ij3tphapqN%fsnet.co.uk.invalid>. .. 


    Found that to see the spread sheet on my PowerBook, I had the
    spreadsheet zoomed to 150%. If I go to 125% or less, I do not have
    the problem of the cell covering the one above. Thanks to all for
    their help.
    DJ
    DJsailor

Similar Threads

  1. cannot edit List in Datasheet
    By John in forum Microsoft SharePoint Workspace
    Replies: 4
    Last Post: 12-16, 04:58 PM
  2. Edit an attachment in a dicussion
    By Robert in forum Microsoft SharePoint Workspace
    Replies: 2
    Last Post: 12-13, 12:05 AM
  3. Saving Document so others can not edit
    By Gerald in forum Microsoft Word
    Replies: 1
    Last Post: 07-14, 03:42 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100