Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 | | |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 | | |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Keep cursor in 1 cell
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 | | | | | | | | |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Compiling macro based on cell values | Excel Discussion (Misc queries) | |||
Instead of a negative number, I'd like to show zero... | Excel Worksheet Functions | |||
Cell color based upon cell value | Excel Discussion (Misc queries) | |||
cell color index comparison | New Users to Excel | |||
up to 7 functions? | Excel Worksheet Functions |