Freeze or unfreeze rows or columns in Google Sheets

Summary

How to freeze or unfreeze rows or columns in Google Sheets?

Body

Question

How to freeze or unfreeze rows or columns in Google Sheets?

Answer

To keep some data in the same place and still see it when you scroll, you can freeze rows or columns.

  1. On your spreadsheet, select a row or column you want to freeze or unfreeze
  2. At the top, click View
  3. Click Freeze
  4. Select how many rows or columns to freeze.

To unfreeze

  1. Select a row or column
  2. At the top, click View 
  3. Click Freeze 
  4. Choose No rows or No columns

For more information about Sheets, please view the full tutorial from the CTL here: Google Sheets 

If you need further assistance, please click the CTL Support Request button on this page

Details

Details

Article ID: 7834
Created
Tue 12/20/22 11:52 AM
Modified
Sat 5/16/26 7:07 AM
KCS Article Status
WIP: Only Problem & some Environment captured
Not Validated: Complete & Resolution captured, confidence lacks in structure, content, no feedback
Validated: Complete & reusable, used by licensed KCS user, confidence in resolution & std. compliance
Validated

Related Services / Offerings

Related Services / Offerings (1)

The Center for Teaching & Learning develops and supports a diverse and inclusive community dedicated to excellent teaching, learning, and student educational experience regardless of location, formality, or modality.