1
Click "View"
2
Click "Freeze Panes" to see your options.
3
Your options are:
1. Freeze Panes
2. Freeze top row
3. Freeze first column
4
Click "Freeze Top Row" to always show row 1.
5
Click "Freeze First Column" to always show column A.
6
To set which rows will freeze, highlight the row below which rows you want to freeze. In this example, by highlighting row 3, it will freeze rows 1 and 2.
7
Click "Freeze Panes"
8
Click "Freeze Panes"
9
Click "Freeze Panes"
10
You can now see which rows and columns are frozen based on the thicker lines.
