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
|