Jul 02 2023 03:59 AM
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
Jul 03 2023 12:01 AM
To resize the worksheet tabs in Excel to display more or fewer tabs, you can adjust the tab scrolling settings.
Here is how you can do it:
Once you have adjusted the tab scrolling settings, the worksheet tabs will resize accordingly, and you should be able to see more tabs at the bottom of the workbook.
Please note that the menu options may vary slightly depending on the version of Excel you are using, but the general concept remains the same. The text and steps were created with the help of AI.
My answers are voluntary and without guarantee!
I hope this helps!
Jul 03 2023 12:37 AM
SolutionInteresting. 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?
Jul 03 2023 06:46 PM
Thanks @Sergei Baklan
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
Jul 03 2023 06:54 PM
Jul 05 2023 10:42 AM
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.
Jul 03 2023 12:37 AM
SolutionInteresting. 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?