Tab Order - on a worksheet?

[MRK_Toledo]

I have a worksheet that has many cells where the user will enter
information. I have locked all the other cells so nothing can be
changed.

The problem is: when the worksheet opens, you have to mouse click
into the first cell that you want to type in, then, after done with that
cell, you would think that just hitting 'enter' or 'tab' would take you
to the next available unlocked cell - it does not, it almost seems
random.....

Is there a way to define the tab order? Similar to the way it would
work with a form?

I really don't want to make this HUGE worksheet a form just to organize
the 'tab' order.

ThanX.

 

[DauntingGecko]

Its selecting unlocked cells only by the sounds of it.

you can change the direction of pressing enter by going to:

Tools
Options
Edit Tab
Change the direction drop down.