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

Who is Mr Spreadsheet?
Author John Walkenbach was Mr Spreadsheet until his retirement in June 2019.
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,317
Messages
6,177,850
Members
452,810
Latest member
jeffrey0409

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