Workbook Tab Character Length

Ribbon bar. Select the Workbook tab. In the Tools group, click Tab Control and from the menu, select Tab Length to display the Workbook Tab Character Length dialog box.

Classic menus. From the Workbook - Tab Control submenu, select Tab Length to display the Workbook Tab Character Length dialog box.  

Length. Type the maximum number of characters that can be used for a tab in the workbook viewer in the Length box. You can also use the corresponding microscrolls to select the number. Specifying a smaller number will enable you to display more tabs; however, most names will be abbreviated. Note that when you move the mouse pointer over a tab, a ToolTip will be displayed giving you the complete name of the document including the path used in the workbook hierarchy.

OK. Click the OK button to accept the current value in the Length field and return to the workbook.

Cancel. Click the Cancel button to return to the workbook, disregarding any changes you have made in this dialog box.