 |
 | 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 / New Users / August 2007Excel 97 vs 95
I just installed 97 after using 95 forever. One question... WIth 95, when I enter a value in a cell, and then hit "enter", the cursor moves to the cell directly below. With 97, it moves to the next row, far left cell. Is there a way to change it to move directly down one cell? The Down Arrow key is not in a convenient place on this keyboard to use this way. Thanks. Bob Bob, When you select Tools > Options > Edit What direction is set in the "Move after Entry" direction?  SignatureHTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings sandymann2@mailinator.com Replace @mailinator.com with @tiscali.co.uk >I just installed 97 after using 95 forever. One question... > [quoted text clipped - 9 lines] > > Bob Down. But now I check it and it does move directly down on 'enter.' Maybe it 'learned' this? > Bob, > [quoted text clipped - 14 lines] > > > > Bob It depends on how you move, if you tab across let's say from A1 to E1, then type data into E1 and press enter it will go to A2, if you use the arrow key from A1 to E1 it will go to E2 SignatureRegards, Peo Sjoblom > Down. But now I check it and it does move directly down on 'enter.' > Maybe it 'learned' this? [quoted text clipped - 20 lines] >> > >> > Bob Ah so! Guess I need to take a class or read a book on Excel. Thanks. Bob > It depends on how you move, if you tab across let's say from A1 to E1, then > type data into E1 and press enter it will go to A2, if you use the arrow key [quoted text clipped - 24 lines] > >> > > >> > Bob Interesting. I've only ever used XL with the *Right* selection. It used to drive me crazy when I was assisting someone else who had *down* selected but I can see how useful that it could be for quick data entry. SignatureSandy In Perth, the ancient capital of Scotland and the crowning place of kings sandymann2@mailinator.com Replace @mailinator.com with @tiscali.co.uk > It depends on how you move, if you tab across let's say from A1 to E1, > then type data into E1 and press enter it will go to A2, if you use the > arrow key from A1 to E1 it will go to E2 |
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.