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

A Spreadsheet with a View 201
After selecting the range of cells to be edited, I then clicked the Zoom to Selection button on the View tab. You can see the result in Figure 3-9. As you can see on the status bar, Excel boosted the magnification from 50% up to 231% the moment I clicked the Zoom to Selection button: a comfortable size for editing these cells on even one of the smaller computer monitors.
Because Excel immediately puts the slider button at whatever point you click, you can instantly return the magnification percentage to the normal 100% after selecting any other magnification. Simply click the line at the mid- point in the Zoom slider on the status bar.
Freezing window panes
Figure 3-9 could be the poster boy for the Freeze Panes feature. Although zooming in on the range of cells that needs editing has made their data entries easy to read, it has also removed all the column and row headings that give you any clue as to what kind of data you’re looking at. If I had
used the Freeze Panes command to freeze column A with the row headings and row 2 with the column headings, they would remain displayed on the screen — regardless of the magnification settings that I select or how I scroll through the cells.
Figure 3-9:
Worksheet at 231% magnifica- tion after zooming
in on the cell range J20:L25.
Book II Chapter 3
Editing and Proofing Worksheets