Workbook Tab Character Length

To adjust the character length of the Workbook tab, follow these instructions:

Procedure

  1. Select the Workbook tab.
  2. Select . in the Tools group.
  3. Click Tab Control.
  4. From the menu, select Tab Length to display the Workbook Tab Character Length dialog box.
  5. 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 enables you to display more tabs; however, most names are abbreviated.
    Note: When you move the mouse pointer over a tab, a tool-tip is displayed giving you the complete name of the document including the path used in the workbook hierarchy.