Freeze rows and columns

You can prevent important rows or columns from scrolling off the screen by freezing them. For example, you can freeze a top row that contains column headings so that the labels remain visible as you scroll in the sheet.

Sheet with top row frozen

On the View menu, click Normal.

Do one of the following:

To freeze	Do this
Rows	In column A, select a cell in the row below the row that you want to freeze.
Columns	In row 1, select a cell in the column to the right of the columns that you want to freeze.
Rows and columns	Select a cell past the first row and the first column. All columns to the left and rows above that cell will be frozen.

To freeze

Do this

Rows

In column A, select a cell in the row below the row that you want to freeze.

Columns

In row 1, select a cell in the column to the right of the columns that you want to freeze.

Rows and columns

Select a cell past the first row and the first column.

All columns to the left and rows above that cell will be frozen.

Tip If you have split the worksheet, you will need to remove the split before you can freeze rows or columns. On the Window menu, click Remove Split.

On the Window menu, click Freeze Panes.

Tips

To unfreeze rows or columns that are frozen, on the Window menu, click Unfreeze Panes.
To print certain rows or columns on every page, on the Layout tab, under Print, click Repeat Titles. In the Rows to repeat at top box or the Columns to repeat at left box, enter the rows or columns that you want to appear on every page.
Instead of freezing, you can also lock cells, rows, columns, whole sheets, and whole workbooks by turning on workbook protection. For more information, see Protect a workbook.

See also
Show or hide rows or columns
Adjust the column size to see everything
Change the number of sheets in new workbooks

Share your feedback about this topic

Rate this content: