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

Sheet with top row frozen

  1. On the View menu, click Normal.
  2. 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.

  1.  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.

  2. On the Window menu, click Freeze Panes.

 Tip   

  • 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

 
 
Applies to:
Excel for Mac 2011