Microsoft Office Tutorials and References
In Depth Information
Don’t Short-Sheet Me!
Short and sweet (sheet names)
Although Excel allows up to 31 characters
(including spaces) for a sheet name, you want
to keep your sheet names much briefer for two
✓ The longer the name, the longer the sheet
tab. The longer the sheet tab, the fewer
the tabs that can display and the more tab
scrolling you have to do to select the sheets
you want to work with.
✓ Should you start creating formulas that
use cells in different worksheets (see
the upcoming section “Summing Stuff on
Different Worksheets” for an example),
Excel uses the sheet name as part of the
cell reference in the formula. (How else
could Excel keep straight the value in cell
C1 on Sheet1 from the value in cell C1 on
Sheet2?) Therefore, if your sheet names
are long, you end up with unwieldy
formulas in the cells and on the Formula bar, even
when you’re dealing with simple formulas
that only refer to cells in a couple of
Generally, the fewer characters in a sheet
name, the better. Also, remember that each
name must be unique — no duplicates allowed.
To rename a worksheet tab, just follow these steps:
1. Double-click the sheet tab or right-click the sheet tab and then click
Rename on its shortcut menu.
The current name on the sheet tab appears selected.
2. Replace the current name on the sheet tab by typing the new sheet
3. Press Enter.
Excel displays the new sheet name on its tab at the bottom of the
A sheet tab by any other color . . .
In Excel 2013, you can assign colors to the different worksheet tabs. This
feature enables you to color-code different worksheets. For example, you could
assign red to the tabs of those worksheets that need immediate checking and
blue to the tabs of those sheets that you’ve already checked.
To assign a color to a worksheet tab, right-click the tab and highlight Tab Color
on its shortcut menu to open a submenu containing the Tab Color pop-up
palette. Then, click the new color for the tab by clicking its color square on