Excel 97 vs 95

[Mail Man Bob]

I just installed 97 after using 95 forever. One question...

WIth 95, when I enter a value in a cell, and then hit "enter", the cursor
moves to the cell directly below. With 97, it moves to the next row, far
left cell.

Is there a way to change it to move directly down one cell? The Down Arrow
key is not in a convenient place on this keyboard to use this way.

Thanks.

Bob

 

[Sandy Mann]

Bob,

When you select Tools > Options > Edit What direction is set in the "Move
after Entry" direction?

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

 

[Mail Man Bob]

Down. But now I check it and it does move directly down on 'enter.'
Maybe it 'learned' this?

 

[Peo Sjoblom]

It depends on how you move, if you tab across let's say from A1 to E1, then
type data into E1 and press enter it will go to A2, if you use the arrow key
from A1 to E1 it will go to E2


--
Regards,

Peo Sjoblom

 

[Mail Man Bob]

Ah so! Guess I need to take a class or read a book on Excel.

Thanks.

Bob

 

[Sandy Mann]

Interesting. I've only ever used XL with the *Right* selection. It used to
drive me crazy when I was assisting someone else who had *down* selected but
I can see how useful that it could be for quick data entry.

--

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk