Microsoft Office Tutorials and References
In Depth Information
Chapter 7: Maintaining Multiple Worksheets
crazy thing in the first place. The most common situation is, of course, when
you have a bunch of worksheets that are related to each other and, therefore,
naturally belong together in the same workbook. For example, consider the
case of Mother Goose Enterprises with its different companies: Jack Sprat
Diet Centers, Jack and Jill Trauma Centers, Mother Hubbard Dog Goodies;
Rub-a-Dub-Dub Hot Tubs and Spas; Georgie Porgie Pudding Pies; Hickory,
Dickory, Dock Clock Repair; Little Bo Peep Pet Detectives; Simple Simon Pie
Shoppes; and Jack Be Nimble Candlesticks. To keep track of the annual sales
for all these companies, you could create a workbook containing a worksheet
for each of the nine different companies.
By keeping the sales figures for each company in a different sheet of the same
workbook, you gain all the following benefits:
✓ You can enter the stuff that’s needed in all the sales worksheets (if you
select those sheet tabs) just by typing it once into the first worksheet
(see the section “Editing en masse,” later in this chapter).
✓ In order to help you build the worksheet for the first company’s sales,
you can attach macros to the current workbook so that they are readily
available when you create the worksheets for the other companies. (A
macro is a sequence of frequently performed, repetitive tasks and
calculations that you record for easy playback — see Chapter 12 for details.)
✓ You can quickly compare the sales of one company with the sales of
another (see the section “Opening Windows on Your Worksheets,” later
in this chapter).
✓ You can print all the sales information for each company as a single
report in one printing operation. (Read Chapter 5 for specifics on
printing an entire workbook or particular worksheets in a workbook.)
✓ You can easily create charts that compare certain sales data from
different worksheets (see Chapter 10 for details).
✓ You can easily set up a summary worksheet with formulas that total the
quarterly and annual sales for all nine companies (see the upcoming
“Summing Stuff on Different Worksheets” section).
Sliding between the sheets
Each blank workbook that you open contains a single worksheet given the
prosaic name, Sheet1. To add more sheets to your workbook, you simply
click the New Sheet button on the Status bar (the one with plus sign in a
circle). Each worksheet you add with the New Sheet command button is
assigned a generic Sheet name with the next available number appended
to it, so if you click this button twice in a new workbook containing Sheet1,
Excel adds Sheet2 and Sheet3. These worksheet names appear on tabs at the
bottom of the workbook window.