Page 221 - Excel 2013 All-in-One For Dummies

A Spreadsheet with a View 203
As Figure 3-11 shows, frozen panes stay on the screen even when you zoom in and out on the worksheet. For Figure 3-11, I repeated the steps I took in changing the magnification for Figures 3-8 and 3-9 (only this time with the frozen panes in place). First, I zoomed out on the Income Analysis spread- sheet by dialing the 50% magnification setting on the Zoom slider; second, I selected the range J20:L25 and then clicked the Zoom to Selection button on the View tab.
Figure 3-11 shows the result. Note that with the frozen panes in place, this time Excel only selected a 172% magnification setting instead of the original 231% setting. This lower magnification setting is worth it because of all the important information that has been added to the cell range.
When you press the Ctrl+Home shortcut key after you’ve frozen panes in a worksheet, instead of positioning the cell cursor in cell A1 as normal, Excel positions the cell cursor in the first unfrozen cell. In the example illustrated in Figure 3-10, pressing Ctrl+Home from anywhere in the worksheet puts the cell cursor in B3. From there, you can position the cell cursor in A1 either by clicking the cell or by pressing the arrow keys.
To unfreeze the panes after you’ve finished editing, click the Unfreeze Panes option on the Freeze Panes button’s drop-down menu. (This option replaces Freeze Panes at the top of the menu.)
Figure 3-11:
The income worksheet after zooming
in on the cell range J20:L25 after freezing panes.
Book II Chapter 3
Editing and Proofing Worksheets