Arrows move worksheet rather than cell selection, how fix?

  • Thread starter Thread starter Guest
  • Start date Start date
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!!!
 
You've accidently hit the Scroll Lock key. Just press it again. It's
usually just above the Home key
 
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
 
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

arrow keys move entire sheet instead of cell to cell 2
How can i move from cells using the arrows 1
How do I fix my arrow keys? They are no longer moving cell to cel. 1
Help! My arrows have fallen and can't get up! 2
worksheet sliding when cell is tabbed 2
Arrows not moving from cell to cell, when I push arrow columns m 2
Arrow keys when cells locked 1
how to select cells with keyboard if the arrows don't let you go out of the formula 2

Back
Top