show all tabs

marnie

Board Regular
Joined
Apr 26, 2002
Messages
86
Does anyone know if there is a way to show all tabs in a workbook at the bottom of the screen? If I slide the tab split bar to the right, I can see only 8 tabs (depending on the length of the text in the tab). I thought there should be a way to show all the tabs even if they end up taking up several rows at the bottom of the screen.

Thanks
 

Excel Facts

Can you AutoAverage in Excel?
There is a drop-down next to the AutoSum symbol. Open the drop-down to choose AVERAGE, COUNT, MAX, or MIN
Hi marnie,

I'm not aware of a way to make all worksheet tabs visible at one time, as you indicated this is influenced by the length of the tabs themselves.

However, you can right-click on the arrows in bottom left corner (just before the sheet tabs start) and this will bring up a menu of the sheets in the workbook.

HTH
 
Upvote 0

Forum statistics

Threads
1,224,891
Messages
6,181,614
Members
453,057
Latest member
LE102024

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
Back
Top