Freezing Rows
There are two methods to freeze rows in a spreadsheet:
- Dragging the Sort Bar. The Sort Bar is a horizontal bar that separates active rows from frozen ones. Using its handle (found at left, by the row numbers), you can drag the Sort Bar up or down to the last row you'd like to freeze, 10 rows maximum.
- Using the Tools tab. Click the Tools tab and then click the "Freeze rows" drop-down menu. From the menu, select the number of rows you want to freeze. Note that you can only freeze ten rows using this method.
Freezing Columns
There are also two methods to freeze columns in a spreadsheet:
- The Column Bar is a vertical bar that separates active columns from frozen ones. Using its handle (found at top, by the column headers), you can drag the Column Bar left or right to the last column you'd like to freeze, 5 columns maximum.
- Click the Tools tab and then click the "Freeze columns" drop-down menu. From the menu, select the number of columns you want to freeze, 5 columns maximum.
