View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Skinman Skinman is offline
external usenet poster
 
Posts: 54
Default Return to 1st cell in next line in multi-column list for quicker e

Go to editing options in excel advanced options , make sure that the check
box is ticked next to
after pressing enter....Then select down..which is next to direction. This
will move to next cell down after
return or enter. Does not matter how many columns or cells are selected.
Skinman



"Katijo" wrote in message
...
I want the return key to go the first cell of the next line in a
multi-column
list when I am doing data entry instead of clicking the cell or using the
arrow keys to get back to the first cell each time. It works that way
sometimes, but only sporadically?