Forum Discussion
Worksheet tabs
I have a number of worksheet tabs located on the bottom of the excel spreadsheet, 15 in total. Is there away that I can have all 15 tabs showing at one time. Resize the worksheet tabs?
Siobhan_Jeddore I don't know of a way to force the size of the tabs but you can
a) make smaller names on the tabs
b) adjust the space allocated to showing the tabs. In the following picture are the tabs to the left, the "+" sign to add tabs and on the right the horizontal scroll. There are 3 dots just to the left of that horizontal scroll that act as a handle to size that scroll bar and by dragging to the right you can make more space for displaying more tabs
c) Or you can completely get rid of the scroll bar in File -> Options -> Advanced Options (see image below)