Microsoft Office Tutorials and References
In Depth Information
Keeping the titles in view by freezing panes
FIGURE 14.7
You can split the worksheet window into two or four panes to view different areas
of the worksheet at the same time.
Keeping the titles in view by freezing panes
If you set up a worksheet with column headings or descriptive text in the fi rst column, this
identifying information won’t be visible when you scroll down or to the right. Excel
provides a handy solution to this problem: freezing panes. Freezing panes keeps the column or
row headings visible while you’re scrolling through the worksheet.
14
To freeze panes, start by moving the cell pointer to the cell below the row that you want to
remain visible while you scroll vertically, and to the right of the column that you want to
remain visible while you scroll horizontally. Then choose View
Freeze Panes and
select the Freeze Panes option from the drop-down list. Excel inserts dark lines to indicate
the frozen rows and columns. The frozen row and column remain visible while you scroll
throughout the worksheet. To remove the frozen panes, choose View Window Freeze
Panes, and select the Unfreeze Panes option from the drop-down list.
Window
Search JabSto ::




Custom Search