Datasheet
Adding and Editing Data in a Workbook
23
Be aware that many of the actions performed in the exercises in this section
cannot be undone by simply clicking the Undo button. If you move a sheet to
the wrong location, delete the wrong sheet, rename a sheet incorrectly, and
similar mistakes, and then try to backtrack using the Undo button, you will
notice that it does nothing. In these cases, you will have to manually correct
the action.
Making Sheet Tabs Make Sense
In order for your sheets to make sense and be well organized, you can name them and color-
code them for clarity. It’s much easier to find something in a workbook if the sheet tabs are
obvious. Exercise 1.11 explains how to accomplish this.
EXERCISE 1.11
Renaming and Color-Coding Worksheets
1. Move to Sheet1 in Exercise 1-1.xls. Double-click the Sheet1 sheet tab; the name is high-
lighted in black.
2. Type January Sales and press Enter.
3. Right-click the Sheet2 tab and choose Rename. Type March Sales and press Enter.
4. Choose the method you prefer and either double-click Sheet3’s tab or right-click Sheet3’s
tab and choose Rename. Type February Sales and press Enter.
5. Right-click the sheet tab that now reads January Sales and choose Tab Color. When the
Format Tab Color box comes up, click any color you like, then click OK. Notice January
Sales is now underlined in that color.
6. Click the March Sales tab to select that sheet. The January Sales tab is now fully colored
in the tab color you chose for it.
7. With the March Sales sheet displayed, go to the Format menu and choose Sheet Tab
Color. Again, choose a color and click OK. Now the March Sales sheet tab is underlined
in that color.
8. Move to the February Sales sheet and either right-click it or use the Format menu to
change the color of that tab.
9. Notice that the active sheet shows a white tab with its name underlined in the chosen
color, whereas the inactive sheets show the tabs in their full colors. Also, you can see that
the active sheet tab has bold text.
10. Leave the file open for the next exercise.
4002book.fm Page 23 Friday, March 24, 2006 11:36 PM