Automatically move to adjacent cells without hitting Enter

[Doug]

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.

 

[Gary''s Student]

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.

 

[Doug]

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.

 

[Bill Sharpe]

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

 

[Doug]

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]

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

 

[Gord Dibben]

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

 

[Gary''s Student]

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.