Automatically move to adjacent cells without hitting Enter


D

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.
 
Ad

Advertisements

G

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.
 
D

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.
 
B

Bill Sharpe

Doug said:
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
 
D

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.
 
B

Bill Sharpe

Doug said:
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
 
Ad

Advertisements

G

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
 
Ad

Advertisements

G

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top