Worksheet tabs

%3CLINGO-SUB%20id%3D%22lingo-sub-1555625%22%20slang%3D%22en-US%22%3EWorksheet%20tabs%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1555625%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20number%20of%20worksheet%20tabs%20located%20on%20the%20bottom%20of%20the%20excel%20spreadsheet%2C%2015%20in%20total.%20Is%20there%20away%20that%20I%20can%20have%20all%2015%20tabs%20showing%20at%20one%20time.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EResize%20the%20worksheet%20tabs%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1555625%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1555716%22%20slang%3D%22en-US%22%3ERe%3A%20Worksheet%20tabs%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1555716%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F744697%22%20target%3D%22_blank%22%3E%40Siobhan_Jeddore%3C%2FA%3E%26nbsp%3B%20I%20don't%20know%20of%20a%20way%20to%20force%20the%20size%20of%20the%20tabs%20but%20you%20can%26nbsp%3B%3C%2FP%3E%3CP%3Ea)%20make%20smaller%20names%20on%20the%20tabs%3C%2FP%3E%3CP%3Eb)%20adjust%20the%20space%20allocated%20to%20showing%20the%20tabs.%26nbsp%3B%20In%20the%20following%20picture%20are%20the%20tabs%20to%20the%20left%2C%20the%20%22%2B%22%20sign%20to%20add%20tabs%20and%20on%20the%20right%20the%20horizontal%20scroll.%26nbsp%3B%20There%20are%203%20dots%20just%20to%20the%20left%20of%20that%20horizontal%20scroll%20that%20act%20as%20a%20handle%20to%20size%20that%20scroll%20bar%20and%20by%20dragging%20to%20the%20right%20you%20can%20make%20more%20space%20for%20displaying%20more%20tabs%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22mtarler_0-1596111857277.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F209010i10384EF0A3CBD8EC%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22mtarler_0-1596111857277.png%22%20alt%3D%22mtarler_0-1596111857277.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3Ec)%20Or%20you%20can%20completely%20get%20rid%20of%20the%20scroll%20bar%20in%20File%20-%26gt%3B%20Options%20-%26gt%3B%20Advanced%20Options%20(see%20image%20below)%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22mtarler_0-1596112140946.png%22%20style%3D%22width%3A%201319px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F209013iE9BEE6A031B78191%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22mtarler_0-1596112140946.png%22%20alt%3D%22mtarler_0-1596112140946.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1555917%22%20slang%3D%22de-DE%22%3ESubject%3A%20Worksheet%20tabs%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1555917%22%20slang%3D%22de-DE%22%3EYou%20cannot%20influence%20the%20setting%20for%20the%20font%20size%20of%20this%20tab%20in%20Excel.%20Excel%20adopts%20the%20size%20specification%20that%20Windows%20specifies%20for%20the%20scroll%20bar.%20The%20following%20steps%20are%20necessary%20to%20change%20this%20setting%3A%20Go%20to%20%22Display%22%20in%20the%20Control%20Panel.%20%3CBR%20%2F%3E%3CBR%20%2F%3E%20On%20the%20%22Display%22%20tab%2C%20select%20the%20%22Scroll%20bar%22%20entry%20under%20%22Image%20element%22.%20Enter%20the%20desired%20font%20size%20in%20the%20%22Size%22%20field.%20After%20you%20have%20confirmed%20your%20entry%2C%20you%20will%20immediately%20see%20the%20Excel%20tab%20with%20the%20new%20font%20size.%20%3CBR%20%2F%3E%3CBR%20%2F%3E%20If%20you%20have%20solved%20your%20problem%20with%20this%20solution%2C%20please%20mark%20it%20as%20the%20correct%20answer%20so%20that%20others%20can%20also%20get%20this%20information.%20%3CBR%20%2F%3E%20If%20this%20is%20not%20what%20you%20are%20looking%20for%2C%20please%20give%20us%20a%20quick%20feedback.%20%3CBR%20%2F%3E%3CBR%20%2F%3E%20Nikolino%20%3CBR%20%2F%3E%20I%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FLINGO-BODY%3E
Occasional Visitor

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?

2 Replies

@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

mtarler_0-1596111857277.png

c) Or you can completely get rid of the scroll bar in File -> Options -> Advanced Options (see image below)

mtarler_0-1596112140946.png

 

You cannot influence the setting for the font size of this tab in Excel. Excel adopts the size specification that Windows specifies for the scroll bar. The following steps are necessary to change this setting: Go to "Display" in the Control Panel.

On the "Display" tab, select the "Scroll bar" entry under "Image element". Enter the desired font size in the "Size" field. After you have confirmed your entry, you will immediately see the Excel tab with the new font size.

If you have solved your problem with this solution, please mark it as the correct answer so that others can also get this information.
If this is not what you are looking for, please give us a quick feedback.

Nikolino
I know I don't know anything (Socrates)