Keep cursor in 1 cell

G

Guest

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
 
B

Bernard Liengme

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
 
N

Niek Otten

Or, Tools>Options>Edit tab, uncheck Move selection after Enter

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| 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
|
| | > 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
|
|
 
N

Niek Otten

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| But then one must remember to change that setting for other work
| --
| Bernard V Liengme
| www.stfx.ca/people/bliengme
| remove caps from email
|
| | > Or, Tools>Options>Edit tab, uncheck Move selection after Enter
| >
| > --
| > Kind regards,
| >
| > Niek Otten
| > Microsoft MVP - Excel
| >
| > | > | 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
| > |
| > | | > | > 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
| > |
| > |
| >
| >
|
|
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how do I get to cursor to stay on the cell when I press enter 1
how to display my cursor cell content in another cell.... 6
Automatically moving from one cell to another 3
Array formula lock-up 1
Cursor Movement? 10
Moving Cursor after Cell Entry 1
Cursor 1
Excel 2007 Chart Data Selection- Arrow Keys Frustration 0

Top