In Excel, arrow keys move active cell out of view

Question

Level 1

0 points

In Excel, arrow keys move active cell out of view

I'm running a multi-sheet workbook in Excel 2004 for Mac. I've encountered an odd problem and scouring the web hasn't thrown up a solution, so any help would be gratefully received.

On ONE of the worksheets (but NOT the others) when the active cell is at the edge of the screen, using the arrow keys to move the cell further causes the actvie cell to disappear from view, making navigation impossible without using the mouse and the scrollbars. I've never seen this happen in years of using Excel on the PC - the active cell was always kept in view by the screen scrolling automatically as the active cell is moved using the arrow keys, EXCEPT where Window > Freeze Panes is selected, which is not the case here.

The issue seems to be the same whether I use the built in keyboard or my Apple wireless aluminium one.

Can anyone help with this odd and anooying problem?

MacBook Pro, Mac OS X (10.5.8), Excel 2004 for Mac

Posted on Apr 10, 2012 8:56 AM

Reply

Answer 1

ds store

Level 7

30,855 points

Apr 10, 2012 10:09 AM in response to adamnet

Sounds like a Excel and a Microsoft problem, perhaps you need to ask them, perhaps it's a bug and they need to know about it, or you need to update/upgrade, perhaps you have a macro virus...

Reply

Answer 2

adamnet Author

Level 1

0 points

Apr 10, 2012 11:43 AM in response to ds store

Thanks, a bug sounds likely. I pasted all the filled cells into a new sheet, and the new one seems to work fine. It looks as if the original sheet became corrupted somehow. I'll monitor it and report to MS if it recurs.

Reply