 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / October 2006Keep 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 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  SignatureBernard 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 Or, Tools>Options>Edit tab, uncheck Move selection after Enter SignatureKind 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 [quoted text clipped - 6 lines] | > 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 But then one must remember to change that setting for other work SignatureBernard V Liengme www.stfx.ca/people/bliengme remove caps from email > Or, Tools>Options>Edit tab, uncheck Move selection after Enter > [quoted text clipped - 12 lines] > each > | > time. It's a pain. Any help will be appreciated. Thx, Greg Yes, indeed. Just in case this was what the OP wanted; I always have this option unchecked. SignatureKind regards, Niek Otten Microsoft MVP - Excel | But then one must remember to change that setting for other work | > Or, Tools>Options>Edit tab, uncheck Move selection after Enter [quoted text clipped - 13 lines] | > each | > | > time. It's a pain. Any help will be appreciated. Thx, Greg Go to Tools-Options- Edit tab. Uncheck 'Move selection after Enter'. Regards, Paul > 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 to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.