ExcelBanter - Keep cursor in 1 cell

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Keep cursor in 1 cell (https://www.excelbanter.com/excel-worksheet-functions/115832-keep-cursor-1-cell.html)

Keep cursor in 1 cell

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

Keep cursor in 1 cell

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

Keep cursor in 1 cell

Go to Tools-Options- Edit tab. Uncheck 'Move selection after Enter'.

Regards,
Paul

"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

Keep cursor in 1 cell

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

Keep cursor in 1 cell

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

Keep cursor in 1 cell