Freeze or unfreeze columns & rows

To keep some of your data in the same place as you scroll through a spreadsheet, for example headings or labels, you can freeze rows or columns.

Freeze rows or columns

  1. Open a spreadsheet and select a cell in a row or column you want to freeze.
  2. Open the View menu.
  3. Hover over Freeze.
  4. Select one of the options to freeze up to ten rows, or five columns. You can also choose Up to current row (or Up to current column) to freeze the rows or columns before a cell you've highlighted.

Note: If you don't see a checkmark at the bottom of your spreadsheet, you may be using an older version of Sheets. To freeze a row or column, you can click the View menu > Freeze rows or Freeze columns.

Unfreeze rows or columns

  1. Open a spreadsheet and select a cell in a row or column you want to unfreeze.
  2. Open the View menu.
  3. Hover over Freeze.
  4. Choose either No rows or No columns to unfreeze your rows or columns.

Matt is a Docs & Drive expert and author of this help page. Leave him feedback below about the page.

Was this article helpful?
Yes
No