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?