Specifying next cell to "jump" to

T

tsac1234

When a user completes as much of a specified cell range as necessary an
wishes to move on to the next range, I would like to give them a
option to go "automatically" to the first cell of the next range a
opposed to having to tab through the remainder of the range or click i
the first cell of the range they wish to go to. For example, the firs
range is A10 through D25. After inputting data in D15, the user want
to go to the next range, the first cell of which is A30. How can th
user most quickly and easily go from D15 to A30?

I appreciate your help
 
R

Ron de Bruin

One way is to select all cells that you want to fill in.
Ctrl-1
Uncheck Locked on the protection Tab
Protect your sheet

If you use the Tab key now instead of the Enter key
it will do what you want
 
Top