Forum Discussion

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. ...

excel

SergeiBaklan
Jul 03, 2023
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?

SergeiBaklan

Diamond Contributor

Jul 03, 2023

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

Copper Contributor

Jul 04, 2023

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
Diamond Contributor
Jul 05, 2023
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.