Forum Discussion

kiwibadge's avatar
kiwibadge
Copper Contributor
Jul 02, 2023
Solved

Resize Excel Worksheet TABS

Without warning today, my Excel Worksheet TABS increased in size.  Previously I was able to have some 20+ Worksheet TABS visible at the bottom of the Workbook.  Now there are only 10 visible.   

 

How do I resize this back to display all 20 Tabs?    Excel Version 2305 

 

  • kiwibadge 

    Interesting. Do you mean each tab became two times wider? What about tab height and font size, are they also changed?

    And one more, if you drag 3 dots in front of scrolling bar after tabs to very right, how many tabs do you see?

4 Replies

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor

    kiwibadge 

    Interesting. Do you mean each tab became two times wider? What about tab height and font size, are they also changed?

    And one more, if you drag 3 dots in front of scrolling bar after tabs to very right, how many tabs do you see?

    • kiwibadge's avatar
      kiwibadge
      Copper Contributor

      Thanks SergeiBaklan 

       

      I did see 18-20 TABS across the bottom of the Workbook (dependent on the # characters), which reduced to 6-7 only 3 days ago.   However I have now logged in again and miraculously the file has reverted to the 18-20 TABS.   So I am completely baffled as I only closed the file and repoened it today.

       

      Thank you for your thoughts & suggestions - I have used the 3 dots quite often to give me more space at the bottom.

      Cheers, Steve

      • SergeiBaklan's avatar
        SergeiBaklan
        Diamond Contributor

        kiwibadge 

        Steve, thank you for the feedback. Great to know that was solved. However, for me it's unclear what could be the reason, never seen such.

Resources