Forum Discussion

michaelholemans's avatar
michaelholemans
Copper Contributor
Aug 06, 2024

Change width worksheet tabs (MAC)

In the new version of excel I can't seem to change the width of my worksheet tabs manually, nor does it automatically resize depending on the name of the tab.

I have some excel files which have many tabs (over 50), which could all fit on screen if the tabs were smaller.
Can anyone help me with this? Thanks

 

  • JKPieterse's avatar
    JKPieterse
    Silver Contributor
    The tab size nowadays is only affected by the length of the name of the sheet.
    • michaelholemans's avatar
      michaelholemans
      Copper Contributor
      Doesn't seem to be the case for me...
      If you look at the screenshot the tabs are way too wide for its content
      • AKSV1212's avatar
        AKSV1212
        Copper Contributor
        it's the same for me. I put 1 character in order to fit all the tabs but the default min. tab size is too wide

Resources