How do I get my arrow keys to allow me to move to the next cell?
 

Rather than using enter, if I have a lot of data it is easier to use the
arrow key to move the next cell. But I can't get it to work. The page just
scrolls in whatever direction arrow key is press. I have tried turning
Scroll Lock On and Off but it makes not difference.

Thanks
Lorraine

How do I get my arrow keys to allow me to move to the next cell?
 

Press the Scroll Lock key (ScrLk) once more

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"bbeauty19" wrote in message
...
Rather than using enter, if I have a lot of data it is easier to use the
arrow key to move the next cell. But I can't get it to work. The page
just
scrolls in whatever direction arrow key is press. I have tried turning
Scroll Lock On and Off but it makes not difference.

Thanks
Lorraine

How do I get my arrow keys to allow me to move to the next cell?
 

I like to select the input range first and hit enter to loop through the cells.

You may want to look at:
(xl2003 menus)
tools|Options|Edit tab|move selection after enter


bbeauty19 wrote:

Rather than using enter, if I have a lot of data it is easier to use the
arrow key to move the next cell. But I can't get it to work. The page just
scrolls in whatever direction arrow key is press. I have tried turning
Scroll Lock On and Off but it makes not difference.

Thanks
Lorraine

--

Dave Peterson