Microsoft Office Tutorials and References
In Depth Information
Changing the Sheet Tab Names
• Tap or click New sheet to select it (Move Chart dialog box) and then type Monthly Expenses in the New sheet
text box to enter a sheet tab name for the worksheet that will contain the chart.
• Tap or click the OK button (Move Chart dialog box) to move the chart to a new chart sheet with a new sheet tab
name, Monthly Expenses in this case (Figure 1– 62).
chart moved to
Figure 1– 62
1 ENTER TEXT | 2 CALCULATE SUMS & USE FORMULAS | 3 SAVE WORKBOOK | 4 FORMAT TEXT
5 INSERT CHART | 6 NAME TAB | 7 PREVIEW & PRINT WORKSHEET
To Change the Worksheet Tab Name
You decide to change the name of the Sheet1 worksheet tab to Monthly Budget Planner. Why? Use simple,
meaningful names for each worksheet tab. Worksheet tab names often match the worksheet title. If a worksheet includes
multiple titles in multiple sections of the worksheet, use a sheet tab name that encompasses the meaning of all of the sections.
The following steps rename the worksheet tab.
• Double-tap or double-click the sheet tab labeled Sheet1 in the lower-left corner of the window.
• Type Monthly Budget Planner as the worksheet tab name and then press the ENTER key to display the
new worksheet tab name on the sheet tab (Figure 1– 63).
What is the maximum length for a sheet tab name?
Worksheet tab names can be up to 31 characters (including spaces) in length. Longer worksheet names,
however, mean that fewer sheet tabs will show. If you have multiple sheets, you will be able to scroll
through sheet tabs.
Figure 1– 63