Page 86 - Excel Workbook for Dummies

08_798452 ch04.qxp 3/13/06 7:36 PM Page 69
Chapter 4: Modifying the Spreadsheet 69

Q. How can I easily take the workbook out of A. Click any single visible sheet tab on the
group-editing mode? status bar other than the one for the active
worksheet (indicated by the sheet tab name
in bold lettering).
Try It

Exercise 4-12: Editing Different Worksheets as a Group
Open the Exercise4-12.xls workbook file in the Chapter 4 folder inside your My Practice
Spreadsheets folder or on the Excel Workbook CD-ROM. This version of the CG Media
Sales workbook file contains three worksheets, 2004 Sales, 2005 Sales, and 2006 Sales,
that you can use to practice group editing:

1. Quickly examine each of the three worksheets by clicking their sheet tabs in suc-
cession and then return to the first sheet, 2004 Sales.

2. Select all three worksheets for group editing.
To select a group of adjacent worksheets, hold down the Shift key as you click
the tab of the last sheet in the group (2006 Sales in this case) — note the appear-
ance of [Group] after the workbook’s filename on the Excel program window’s
title bar.
3. Apply the Accounting 3 table AutoFormat to CG Media – 2004 Sales by Category
and Date table without applying its font setting, and then the narrow column A to
22.14 characters (160 pixels).
Click the Options button in the AutoFormat dialog box and then deselect the
check boxes for all the formats you don’t want to change (Font, in this case)
before clicking the preview of the AutoFormat (Accounting 3, in this instance)
and then selecting OK.
4. Select the 2005 Sales worksheet and then the 2006 Sales worksheet to verify that
they now share the same table formatting as the 2004 Sales sheet.
Note that the moment you click the sheet tab of the 2005 Sales worksheet, Excel
automatically takes the workbook out of Group mode.
5. Regroup the three worksheets, 2004 Sales, 2005 Sales, and 2006 Sales, and then
make the column headings in the cell range B2:R2 bold and the column headings
in the range A3:A15 right-aligned and bold.
6. Take the workbook out of Group mode, and then select cell A1 on the 2004 Sales
sheet. Next save the modified workbook under the filename Solved4-12.xls in
your Chapter 4 folder inside the My Practice Spreadsheets folder and close the
workbook.