Page 267 - Excel 2013 All-in-One For Dummies

Reorganizing the Workbook 249
When you choose this command, Excel selects the current name of the tab and positions the insertion point at the end of the name.
3. Replace or edit the name on the sheet tab and then press the Enter key.
When you rename a worksheet in this manner, keep in mind that Excel then uses that sheet name in any formulas that refer to cells in that worksheet. So, for instance, if you rename Sheet2 to 2012 Sales and then create a formula in cell A10 of Sheet1 that adds its cell B10 to cell C34 in Sheet2, the formula in cell A10 becomes:
=B10+’2012 Sales’!C34
This is in place of the more obscure =B10+Sheet2!C34. For this reason, keep your sheet names short and to the point so that you can easily and quickly identify the sheet and its data without creating excessively long formula references.
Right-click either of the two tab scrolling buttons to display the Activate dialog box. This dialog box displays the names of all the worksheets in the current workbook in their current order. You can then scroll to and activate any of the sheets simply by selecting them followed by OK or by double- clicking them.
Designer sheets
Excel 2013 makes it easy to color-code the worksheets in your workbook. This makes it possible to create a color scheme that helps either identify or prioritize the sheets and the information they contain (as you might with dif- ferent colored folder tabs in a filing cabinet).
When you color a sheet tab, note that the tab appears in that color only when it’s not the active sheet. The moment you select a color-coded sheet tab, it becomes white with just a bar of the assigned color appearing under the sheet name. Note, too, that when you assign darker colors to a sheet tab, Excel automatically reverses out the sheet name text to white when the worksheet is not active.
Color coding sheet tabs
To assign a new color to a sheet tab, follow these three steps:
1. Press Ctrl+PgDn until the sheet whose tab you want to color is active, or click its sheet tab if it’s displayed at the bottom of the workbook window.
Don’t forget that you have to select and activate the sheet whose tab you want to color, or you end up coloring the tab of whatever sheet hap- pens to be current at the time you perform the next step.
Book II Chapter 4
Managing Worksheets