Microsoft Office Tutorials and References
In Depth Information
Splitting the Worksheet into Windows
Whew! At 40% of normal screen size, the only thing you can be sure of is that
you can’t read a thing! However, notice that with this bird’s-eye view, you can
see at a glance how far over and down the data in this worksheet extends and
how much empty space there is in the worksheet.
The Zoom dialog box (View Zoom or Alt+WQ) offers five precise
magnification settings — 200%, 100% (normal screen magnification), 75%, 50%, and
25%. To use other percentages besides those, you have the following options:
If you want to use precise percentages other than the five preset
percentages (such as 150% or 85%) or settings greater or less than the
highest or lowest percentage (such as 400% or 10%), click within the Custom
button’s text box in the Zoom dialog box, type the new percentage, and
press Enter.
If you don’t know what percentage to enter in order to display a
particular cell range on the screen, select the range, click View Zoom to
Selection on the Ribbon or press Alt+WG. Excel figures out the
percentage necessary to fill your screen with just the selected cell range.
To quickly return to 100% (normal) magnification in the worksheet after
selecting any another percentage, all you have to do is click the bar in the
center of the Zoom slider on the Status bar or click the 100% button on the
View tab of the Ribbon.
You can use the Zoom feature to locate and move to a new cell range in the
worksheet. First, select a small magnification, such as 50%. Then locate the
cell range you want to move to and select one of its cells. Finally, use the
Zoom feature to return the screen magnification to 100%. When Excel returns
the display to normal size, the cell you select and its surrounding range
appear onscreen.
Splitting the Worksheet into Windows
Although zooming in and out on the worksheet can help you get your
bearings, it can’t bring together two separate sections so that you can compare
their data on the screen (at least not at a normal size where you can actually
read the information). To manage this kind of trick, split the Worksheet area
into separate panes and then scroll the worksheet in each pane so that they
display the parts you want to compare.
Splitting the window is easy. Look at Figure 6-3 to see an Income Analysis
worksheet after splitting its worksheet window horizontally into two panes
and scrolling up rows 38 through 44 in the lower pane. Each pane has its own
vertical scroll bar, which enables you to scroll different parts of the
worksheet into view.
Search JabSto ::

Custom Search