How do you get tabs to work on spreadsheet?

bshearer

New Member
Joined
Oct 9, 2002
Messages
2
How do you get tabs to work on spreadsheet?

I have a spreadsheet with some textboxes and other objects but pressing the tab key does not seem to work.

Thanks in advance !
 

Excel Facts

Excel Wisdom
Using a mouse in Excel is the work equivalent of wearing a lanyard when you first get to college

invisigirl

Board Regular
Joined
Mar 18, 2002
Messages
130
In a text box, use Ctrl tab. In a regular cell, you're right, you can't do it.

Enjoy!
 

royUK

Well-known Member
Joined
Jul 24, 2002
Messages
1,606
You have to use protection.
Select the whole sheet by clicking on the empty grey box at the junction of your Headings (top left hand corner)Select Format>Cells and make sure the Protection is selected.
Select the Cells you want to type in and use the Format Menu > Format Cells and clear the Protection option.
Go into Tools>Protection and protect your Worksheet.
Now the Tab button should move from cell to cell for typing
 

bshearer

New Member
Joined
Oct 9, 2002
Messages
2
We're getting closer. That's pretty slick.

On my spread sheet I have a checkbox, combobox, listbox and a textbox. I have created a survey and now I need for the users to tab between each object.

It's looking like it is not possible.

Thanks again!
 

Forum statistics

Threads
1,143,615
Messages
5,719,728
Members
422,242
Latest member
hishamkhatri

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