Datasheet

26
Chapter 1

Navigating in Excel and Understanding the Interface
Deleting and Hiding Worksheets
As with rows and columns, sometimes you want to remove sheets, either permanently or tem-
porarily. Deleting an entire worksheet is an action that cannot be undone by using the Undo
button, so instead of having you actually delete sheets, I will simply tell you how to do this.
If you choose to do it, you will have to re-create the sheets manually so you have all of them
for future exercises.
To delete a worksheet, you can do one of the following:

Right-click a sheet tab and choose Delete.

Select Edit  Delete Sheet.
June Sales
2nd Qtr Sales
July Sales
August Sales
September Sales
3rd Qtr Sales
October Sales
November Sales
December Sales
4th Qtr Sales
Yearly Totals
You may need to use the tab scrolling buttons to the left of your sheet tabs to see all of
your tabs (see Figure 1.2).
17. Once your sheets are renamed and in the correct order, recolor the tabs so the first month
of every quarter is the same color, the second month of every quarter is the same color, the
third month of every quarter is the same color, the quarterly tabs are the same color, and
the Totals sheet tab is a unique color.
18. Leave the file open for the next exercise.
EXERCISE 1.12 (continued)
4002book.fm Page 26 Friday, March 24, 2006 11:36 PM