View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jim Thomlinson Jim Thomlinson is offline
external usenet poster
 
Posts: 5,939
Default go to fitst column of next row when enter (or other key) is presse

Other than a macro which you could hook up to a hot key sequence there is no
other option that does exactly what you are asking... I personally would be
more inclined to do the tab thing but it is a pretty simple macro... Record
any macro saving it in the workbook with a hot key assignment. Delete the
code in the macro and add this in it's place

cells(activecell.row + 1, "A").select

--
HTH...

Jim Thomlinson


"jcontrer" wrote:

I am entering the results of a survey into a spreadsheet. There is a column
for every question in the survey. It would be much quicker if I could press
enter (or some other button) at the last question to return me to the first
row in the next column.
I understand that if i press tab every time then the enter will do that but
i have several people helping me to enter on this and i want to make it
easier so they can use the arrow and the number pad.


--
thanks in advance