Forum Discussion

nrafferty618's avatar
nrafferty618
Copper Contributor
Feb 13, 2019

I can't Select the row above the active cell...HELP!

Hello,

 

I can't select the cell above the active cell. This may be dumb but it won't let me highlight it.

 

Attached is a simple to view picture.

 

Please help!!

 

Thanks so much

 

Neal

    • BrokenExcel's avatar
      BrokenExcel
      Copper Contributor
      This is still a problem for me....so wonderful to hear about the accomplishments of Bill Gates, yet excel doesn't work correctly haha
      • HansVogelaar's avatar
        HansVogelaar
        MVP

        BrokenExcel 

        In the screenshot in the first post, the cell is being edited and the row height is just to small for the font size (or the font size is too large for the row height), causing the editing area to spill into the cell above.

        Press Esc to stop editing the cell, and you should be able to select the cell above.

  • I also am having this problem!  I have not been able to search the help and resources because I can not find the right combination of keywords which come close enough to figure it out.    It was working fine, and then either I accidently changed something or ???.  It is just the one spreadsheet so far that I was working on.   It makes it very difficult to visually see what cell your in on graphically show the group of cells selected vs the normal shading and borderlines around the cell or group of cells.   nrafferty618 

  • Rich99's avatar
    Rich99
    Iron Contributor

    Neal,

    I haver had this problem in the past. The way round it is to select a cell just to the right or above the one you want  and then use the keyboard arrow keys to get to the cell. 

Resources