When I hit the enter key, it stays in the same cell. How can I change it so
"enter" takes me down a row?

Go to the Tools menu, then Options, then the Edit tab. There, put
a check next to "Move selection after Enter" and set the
direction to down.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"cnielsen" wrote in message
...
When I hit the enter key, it stays in the same cell. How can I
change it so
"enter" takes me down a row?

Modify: Tools|options|Edit tab|Move Selection after Enter
to what you want.

cnielsen wrote:

When I hit the enter key, it stays in the same cell. How can I change it so
"enter" takes me down a row?

--

Dave Peterson

hi,
ToolsoptionsEdit tabMove Selection after Enter
or you could use the arrow keys. i have by excel set to
stay in the same cell on enter but when i want to move, i
use the arrow keys to move in the direction i want.

-----Original Message-----
When I hit the enter key, it stays in the same cell. How
can I change it so
"enter" takes me down a row?
.