View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Doug Doug is offline
external usenet poster
 
Posts: 460
Default 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.