Microsoft Office Tutorials and References
In Depth Information
Freeze Rows or Columns
Freeze Rows
or Columns
You can keep your column labels in view as you scroll
the worksheet by freezing the row or rows that
contain the labels. This makes it easier to review and
add data to the worksheet because you can always
see the column labels.
If your worksheet also includes row labels, you can
keep those labels in view as you horizontally scroll
the worksheet by freezing the column or columns
that contain the labels.
Freeze Rows or Columns
Freeze Rows
1 Scroll the worksheet so that
the row or rows that you
want to freeze are visible.
2 Select the cell in column A
that is one row below the
last row you want to freeze.
For example, if you want to
freeze row 1, select cell A2.
3 Click the View tab.
4 Click Freeze Panes .
5 Click Freeze Panes .
Excel freezes the rows.
Search JabSto ::




Custom Search