Jump to start of next row teaser

[Dave]

Hi,

can anyone assist in telling me if there is either :-

a) a shortcut key
b) a macro
c) none of the above but another solution to

jumping to the beginning of a new row on pressing a key. For example,
after completeing cell m10 can you press enter (or any other key) and
the cursor will automatically go to cell a11, then after you get to
m11 it jumps to a12 and so on?

Just to make things a little trickier, I know you can do this using
the protect worksheet etc function, but I also have the data filter
running which doesn't work when the protect sheet function is on. If
there is a macro and you supply some sample code can you please advise
how I use this i.e. do I create a new macro, paste the code in, run
the macro etc.

Many thanks for any assistance.

 

[Roger Govier]

Hi Dave
Dependent upon any other movement you may require within the sheet, another
method would be to set the Scroll Area for the sheet.
Right click on the Sheet tab
Choose View Code
Press F4 if the sheet properties window is not visible
In the Scroll Area, set the values to the range you require e.g. A1:M500
Click back onto your worksheet and now you will be restricted to movement
within that prescribed range, and pressing Tab or Enter will take you to the
start of the next row after you have entered data in your final column.

This will work with Autofilter in place.

 

[Tom Ogilvy]

to move from cell to cell in a row, use the tab key, then on the last cell,
use the enter key and this should return to the next row in the column where
you started.

 

[David McRitchie]

Hi Dave,
Another approach is to use protected cells to keep you out
of non data entry areas if you protect the worksheet.

Another approach is to use an Event macro to in effect create
a brickwall stops you from going past a certain column.
Worksheet_SelectionChange to prevent entry past a column
Worksheet Events and Workbook Events
http://www.mvps.org/dmcritchie/excel/event.htm#ws_sc