Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Automatically move to adjacent cells without hitting Enter
Does Excel allow data to be entered without using the Enter, tab or arrow
keys to move to the next cell? I have some survey data to enter and would like to have each survey question's response entered into each subsequent cell. But it doubles the keystrokes to hit Enter after each question. I would like to be able to enter, for example, "1" for male and automatically be moved to the next cell to enter "5" for the age. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Automatically move to adjacent cells without hitting Enter
Consider using a Data Validation pull-down. All the user has to do is point,
click, and select. It also really helps to avoid input errors. -- Gary''s Student - gsnu200860 "Doug" wrote: Does Excel allow data to be entered without using the Enter, tab or arrow keys to move to the next cell? I have some survey data to enter and would like to have each survey question's response entered into each subsequent cell. But it doubles the keystrokes to hit Enter after each question. I would like to be able to enter, for example, "1" for male and automatically be moved to the next cell to enter "5" for the age. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Automatically move to adjacent cells without hitting Enter
Actually, it appears that I was not clear in my post. Respondents have
competed a paper questionniare. We are now manually entering the data and I am looking for a way for our data entry people to quickly enter the data with as few keystrokes as possible. "Gary''s Student" wrote: Consider using a Data Validation pull-down. All the user has to do is point, click, and select. It also really helps to avoid input errors. -- Gary''s Student - gsnu200860 "Doug" wrote: Does Excel allow data to be entered without using the Enter, tab or arrow keys to move to the next cell? I have some survey data to enter and would like to have each survey question's response entered into each subsequent cell. But it doubles the keystrokes to hit Enter after each question. I would like to be able to enter, for example, "1" for male and automatically be moved to the next cell to enter "5" for the age. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Automatically move to adjacent cells without hitting Enter
Doug wrote:
Does Excel allow data to be entered without using the Enter, tab or arrow keys to move to the next cell? I have some survey data to enter and would like to have each survey question's response entered into each subsequent cell. But it doubles the keystrokes to hit Enter after each question. I would like to be able to enter, for example, "1" for male and automatically be moved to the next cell to enter "5" for the age. Are all of the entries exactly one character in length? If so, you could probably write a macro to do this. If not, I see all sorts of problems arising. Bill |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Automatically move to adjacent cells without hitting Enter
Sounds like we need to look at other options, such as entering data in
another application and bringing it into Excel. Thanks for all the comments. I thought that maybe there was a setting within Excel that I was not aware of. "Bill Sharpe" wrote: Doug wrote: Does Excel allow data to be entered without using the Enter, tab or arrow keys to move to the next cell? I have some survey data to enter and would like to have each survey question's response entered into each subsequent cell. But it doubles the keystrokes to hit Enter after each question. I would like to be able to enter, for example, "1" for male and automatically be moved to the next cell to enter "5" for the age. Are all of the entries exactly one character in length? If so, you could probably write a macro to do this. If not, I see all sorts of problems arising. Bill |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Automatically move to adjacent cells without hitting Enter
Doug wrote:
Sounds like we need to look at other options, such as entering data in another application and bringing it into Excel. Thanks for all the comments. I thought that maybe there was a setting within Excel that I was not aware of. Perhaps hitting the Enter key after each entry isn't such a bad idea after all... Bill |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Automatically move to adjacent cells without hitting Enter
Excel has no way of knowing you are finished with a cell until you Tab,
Enter or arrow out of that cell. Using VBA you still have to somehow let Excel know you are done with a cell. So.....................I will say there is no method. Gord Dibben MS Excel MVP On Mon, 10 Aug 2009 09:24:01 -0700, Doug wrote: Actually, it appears that I was not clear in my post. Respondents have competed a paper questionniare. We are now manually entering the data and I am looking for a way for our data entry people to quickly enter the data with as few keystrokes as possible. "Gary''s Student" wrote: Consider using a Data Validation pull-down. All the user has to do is point, click, and select. It also really helps to avoid input errors. -- Gary''s Student - gsnu200860 "Doug" wrote: Does Excel allow data to be entered without using the Enter, tab or arrow keys to move to the next cell? I have some survey data to enter and would like to have each survey question's response entered into each subsequent cell. But it doubles the keystrokes to hit Enter after each question. I would like to be able to enter, for example, "1" for male and automatically be moved to the next cell to enter "5" for the age. |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Automatically move to adjacent cells without hitting Enter
Perhaps using an event macro to detect if a cell in a cerain column has been
selected. The event macro could setup some OnKey settings to intercept 1,2,3,etc... All the user would have to do is touch 1 or 2 or 3 The ENTER key would not be needed. -- Gary''s Student - gsnu200860 "Gord Dibben" wrote: Excel has no way of knowing you are finished with a cell until you Tab, Enter or arrow out of that cell. Using VBA you still have to somehow let Excel know you are done with a cell. So.....................I will say there is no method. Gord Dibben MS Excel MVP On Mon, 10 Aug 2009 09:24:01 -0700, Doug wrote: Actually, it appears that I was not clear in my post. Respondents have competed a paper questionniare. We are now manually entering the data and I am looking for a way for our data entry people to quickly enter the data with as few keystrokes as possible. "Gary''s Student" wrote: Consider using a Data Validation pull-down. All the user has to do is point, click, and select. It also really helps to avoid input errors. -- Gary''s Student - gsnu200860 "Doug" wrote: Does Excel allow data to be entered without using the Enter, tab or arrow keys to move to the next cell? I have some survey data to enter and would like to have each survey question's response entered into each subsequent cell. But it doubles the keystrokes to hit Enter after each question. I would like to be able to enter, for example, "1" for male and automatically be moved to the next cell to enter "5" for the age. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
set tab or enter keys to automatically move to different cells | Excel Discussion (Misc queries) | |||
Hitting Enter to Move Cursor to the Next Entry Cell | Excel Worksheet Functions | |||
What does hitting Ctrl + Shift + Enter to enter a formula do??? Help a n00b out. | Excel Worksheet Functions | |||
Cursor not to move when hitting the enter key | Excel Worksheet Functions | |||
how to insert row automatically after hitting enter at the end of. | Excel Worksheet Functions |