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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to enter data then move automatically to new cell?
Have you considered a Data Form?
Try this: A1: Surname B1: Forename C1: Year Select A1:C1 DataForm (Excel will give a warning...ignore it and click OK) A data form will open. [Tab] advances through fields Pressing [Enter] goes to the next record Something you can work with? *********** Regards, Ron XL2002, WinXP-Pro "Wibs" wrote: 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to enter data then move automatically to new cell?
If you have default excel settings and are using tab to go to the next cell,
that is how it is supposed to work look under toolsoptionsedit and make sure move selection after enter is checked and it's set to down, then if you use the tab key it should go to the first column one row below when pressing enter -- Regards, Peo Sjoblom (No private emails please) "Wibs" wrote in message ... 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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to enter data then move automatically to new cell?
No code required;
Just highlight A2:C100 and enter your data and TAB 100% of time (No use of Enter key. HTH "Wibs" wrote in message ... 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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to enter data then move automatically to new cell?
Many thanks for the suggestion. Could you please explain what you mean by 'highlight'. You are not talking of 'selecting' A2:C100 are you? Regards WibsJMay Wrote: No code required; Just highlight A2:C100 and enter your data and TAB 100% of time (No use of Enter key. HTH "Wibs" wrote in message ... 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 -- Wibs ------------------------------------------------------------------------ Wibs's Profile: http://www.excelforum.com/member.php...o&userid=28922 View this thread: http://www.excelforum.com/showthread...hreadid=494464 |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to enter data then move automatically to new cell?
Yes, selecting is alternative lingo.
Left Click and hold down on A2, and drag to C100 and release mouse button. "Wibs" wrote in message ... Many thanks for the suggestion. Could you please explain what you mean by 'highlight'. You are not talking of 'selecting' A2:C100 are you? Regards WibsJMay Wrote: No code required; Just highlight A2:C100 and enter your data and TAB 100% of time (No use of Enter key. HTH "Wibs" wrote in message ... 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 -- Wibs ------------------------------------------------------------------------ Wibs's Profile: http://www.excelforum.com/member.php...o&userid=28922 View this thread: http://www.excelforum.com/showthread...hreadid=494464 |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to enter data then move automatically to new cell?
My goodness. 4 different methods proposed. All four work!! What a forum! Thanks 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 |
Reply |
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) |