Tab Order - on a worksheet?

MRK_Toledo

New Member
Joined
Sep 2, 2006
Messages
34
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.
 

Excel Facts

Back into an answer in Excel
Use Data, What-If Analysis, Goal Seek to find the correct input cell value to reach a desired result

DauntingGecko

Well-known Member
Joined
Feb 2, 2006
Messages
521
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.
 

Forum statistics

Threads
1,141,016
Messages
5,703,751
Members
421,312
Latest member
Mooncake1

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top