Page 71 - Excel Workbook for Dummies

08_798452 ch04.qxp 3/13/06 7:36 PM Page 54
54 Part I: Creating Spreadsheets

6. Display the Open dialog box again (Ctrl+O) and this time open a copy of the
Hourly Wages 02-06.xls file icon in the Lost Spreadsheets folder.
To open a copy of a workbook, select its file icon in the Open list box and then
select the Open as Copy option on the Open button’s drop-down list — Excel
opens the a copy of the original file indicated by the Copy (1) of text that
precedes the filename on the program window’s title bar.
7. Redisplay all the hidden columns in the Feb 06 sheet of this workbook (see
Chapter 2 if you’ve forgotten how to do this), and then select cell A1 before
you save your changes (Ctrl+S) and close the workbook.

Finding and Identifying the

Region that Needs Editing

As you’re already well aware, an Excel worksheet represents an extremely large space
in which to work. Often the biggest challenge in editing a spreadsheet is just finding
and identifying the data ranges in the worksheet that are in need of revision. To help
in this endeavor, you can often use the following three features to good advantage:

Zoom to gain an overview of the worksheet and its data ranges by zooming out
on the worksheet and then using it to gain a close-up view of the particular range
in the sheet you need to edit
Freeze Panes to prevent the rows and columns containing the column and row
headings from scrolling so that these headings remain visible at all times while
you are scrolling through their data entries
Custom Views to name and save a combination of different worksheet display
settings (including frozen panes and various magnification settings) so that you
can put them into effect by simply selecting them

Q. What is the range of zoom settings I can A. You can set the worksheet display magnifi-
select for my worksheet display? cation setting anywhere in the range of 10%
to 400% of normal by entering the value of
the new magnification percentage directly
into the Zoom combo-box in whole degree
increments.

Try It

Exercise 4-4: Using Zoom, Freeze Panes, and Custom Views

Open the Exercise4-4.xls workbook file in the Chapter 4 folder inside your My Practice
Spreadsheets folder or on the Excel Workbook CD-ROM. This file contains a copy of
the now-familiar Regional Income worksheet that you can use to practice using the
Zoom, Freeze Panes, and Custom Views features to find and identify ranges for editing:
1. Select 50% on the drop-down list attached to the Zoom combo-box.
Excel reduces the magnification of the worksheet display to half the normal
size. Note, however, that even at one-half, not all of the data ranges are visible
on-screen.