Microsoft Office Tutorials and References
In Depth Information
Fixed Headings with Freeze Panes
You can increase or decrease the size of the current window panes by
dragging the split bar up or down or left or right with the split pointer. You can
make the panes in a workbook window disappear by double-clicking
anywhere on the split bar (you can also do this by selecting View Split again).
Fixed Headings with Freeze Panes
Panes are great for viewing different parts of the same worksheet that
normally can’t be seen together. You can also use panes to freeze headings in
the top rows and first columns so that the headings stay in view at all times,
no matter how you scroll through the worksheet. Frozen headings are
especially helpful when you work with a table that contains information that
extends beyond the rows and columns shown onscreen.
In Figure 6-4, you can see just such a table. The Income Analysis worksheet
contains more rows and columns than you can see at one time (unless you
decrease the magnification to about 40% with Zoom, which makes the data
too small to read). In fact, this worksheet continues down to row 52 and over
to column P.
Figure 6-4:
panes keep
the column
and the row
headings on
the screen
at all times.
Search JabSto ::

Custom Search