How To

This is an example How To user guide explaining the Freeze feature in Google Sheets (I have no affiliation with Google). I originally wrote it as a part of a technical writing assessment. It follows the Microsoft Style Guide. You can compare to Google's original documentation here.

Google Sheets Help Center

Computer | Android | iOS

Freeze rows and columns

Use Freeze to pin rows and columns in place so they’re always visible when scrolling through a spreadsheet. You can freeze the first row or column, the first two rows or columns, or up to a specific row or column.

Note: You can’t freeze a row or column in the middle of a spreadsheet, and you can’t freeze rows or columns that include part of a merged cell.

Freeze one or two rows or columns

Freeze the first row or column, or the first two rows or columns, in a spreadsheet.

  1. Click View
  2. Select Freeze
  3. Choose 1 or 2 rows or columns

Freeze up to a row or column

Freeze from the first row or column up to a specific row or column.

  1. Select a cell in the row or column you want to freeze up to
  2. Click View
  3. Select Freeze > Up to row or Freeze > Up to column
    • Sheets will automatically provide the selected row number or column letter

You can also freeze up to a row or column directly in the spreadsheet:

  1. Right-click the row number or column letter you want to freeze up to
  2. Select View more row actions or View more column actions
  3. Click Freeze up to row or Freeze up to column
    • Sheets will automatically provide the selected row number or column letter

Unfreezing rows or columns

Unfreeze rows or columns in a spreadsheet.

  1. Click View
  2. Select Freeze > No rows or Freeze > No columns

You can also unfreeze rows or columns directly in the spreadsheet:

  1. Right-click any row number or column letter
  2. Select View more row actions or View more column actions
  3. Click Unfreeze rows or Unfreeze columns