Arrows move worksheet rather than cell selection, how fix?

G

Guest

Normally, I push arrows and selected cell highlight moves one space left,
right, up or down. All of a sudden, cell selection can only be down by mouse
and when I push arrows the cell selection remains constant and instead the
worksheet moves on the screen. Also, when I hit enter, it no longer drops to
next cell position. Help!!!
 
G

Guest

You've accidently hit the Scroll Lock key. Just press it again. It's
usually just above the Home key
 
G

Guest

Thank you very much!! I am a 20 year user of excel and never saw this one
before. One last funny similar thing not fixed by scroll lock is when I hit
the enter key, it logs accepts the new dat for the cell but does not advance
to next cell (normally goes down one cell). Any quick fix on this mystery?
Thanks again. Lee German
 
G

Gord Dibben

Tools>Options>Edit. "Move selection after enter"

Make sure it is checked and direction is chosen.


Gord Dibben Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Issue with Arrow Keys when using Excel 1
arrow keys move entire sheet instead of cell to cell 2
Arrows not moving from cell to cell, when I push arrow columns m 2
Excell-Navigating using arrows 2
"Move selection after Enter" 3
Cell selection does not move with keyboard arrows 8
How to use arrows to go to next cell instead of through screen 4
Tabbing to a specific cell 3

Top