 |
 | 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 2006How can I set the column that excel returns to when I hit Enter?
When I am done entering info on one line and hit Enter/Return sometimes it goes to the next row in column A and sometimes it goes to another cell in the next row. There doesn't seem to be any rhyme or reason to it. Is there a way to set it return where you want? Tools -> Options -> Edit tab You can choose "Move Selection after enter is pressed" and choose which direction. If you want to move differently depending on what cell you are in, you'll have to get in to VBA to capture the Enter keypress and move the cursor appropriately. John > When I am done entering info on one line and hit Enter/Return sometimes it > goes to the next row in column A and sometimes it goes to another cell in > the next row. There doesn't seem to be any rhyme or reason to it. Is there a > way to set it return where you want? Go to "Tools" - "Options" - Pick the "Edit" tab, Check the box by "Move selection after Enter" and pick your direction.  SignatureAlan L > When I am done entering info on one line and hit Enter/Return sometimes it > goes to the next row in column A and sometimes it goes to another cell in > the next row. There doesn't seem to be any rhyme or reason to it. Is there a > way to set it return where you want? |
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.