| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to enter data then move automatically to new cell?
Hi, I am entering lots of family history data into a spreadsheet. At the simplest I have columns (in cells A1 B1 C1) the headings, Surname, Forename, Year. Right now, I enter in cells A2 B2 and C2 say: Smith <Tab John <Tab 1555 <Enter, move mouse to the A column in the next row down). What I want to happen is when I have entered the last data in a row and pressed <Enter I move automatically to the A-column in the next row down. Is this possible? Regards and a Merry Christmas to all Wibs -- Wibs ------------------------------------------------------------------------ Wibs's Profile: http://www.excelforum.com/member.php...o&userid=28922 View this thread: http://www.excelforum.com/showthread...hreadid=494464 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Enter TODAY if cell has data | New Users to Excel | |||
| AUTOMATICALLY ENTER DATA FROM ONE WORKSHEET TO ANOTHER | Excel Worksheet Functions | |||
| Excel automatically copied data from one cell to another... | Excel Discussion (Misc queries) | |||
| must press enter 2x to move cell focus | Excel Discussion (Misc queries) | |||
| Excel: How do I enter a date in one cell & automatically dates adj | Excel Discussion (Misc queries) | |||
Threaded Mode
