Yes, indeed. Just in case this was what the OP wanted; I always have this option unchecked.

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Bernard Liengme" wrote in message ...
| But then one must remember to change that setting for other work
| --
| Bernard V Liengme
| www.stfx.ca/people/bliengme
| remove caps from email
|
| "Niek Otten" wrote in message
| ...
| Or, ToolsOptionsEdit tab, uncheck Move selection after Enter
|
| --
| Kind regards,
|
| Niek Otten
| Microsoft MVP - Excel
|
| "Bernard Liengme" wrote in message
| ...
| | Rather than using the ENTER key to confirm the entry, press the up arrow
| (or
| | left arrow). Since you are in A1 there is nowhere to go but the entry is
| | completed.
| | OR, If you have a newer version of Excel then click the green arrow in
| the
| | Formula Bar to complete the entry. This will work in any row.
| | best wishes
| | --
| | Bernard V Liengme
| | www.stfx.ca/people/bliengme
| | remove caps from email
| |
| | "Greg" wrote in message
| | ...
| | How could I keep my cursor in 1 cell even after pressing the enter
| key? I
| | key
| | data for vlookup and have to move the cursor back to the entry cell
| each
| | time. It's a pain. Any help will be appreciated. Thx, Greg
| |
| |
|
|
|
|