How to Freeze Rows and Columns in Google Sheets

Keep your header row (or first columns) locked in place while the rest of the sheet scrolls. Here's how to freeze one row, several rows, columns, and how to undo it.

By the Quiriz Team · Published July 25, 2026 · 3 min read

The quick version: View → Freeze → 1 row pins your header. Here's that plus multiple rows, columns, and unfreezing.

Freeze the top row

Go to View → Freeze → 1 row. Row 1 now stays put as you scroll. (You can also drag the thick gray bar that sits just below the row numbers.)

Freeze several rows

Click the row below the ones you want frozen, then View → Freeze → Up to current row. Everything above locks. For exactly two, View → Freeze → 2 rows.

Freeze columns

View → Freeze → 1 column (or "Up to current column") keeps the leftmost columns visible as you scroll right — handy for a labels column.

Unfreeze

View → Freeze → No rows and No columns clears it.

Analyze your Sheets data with AI

Ask questions about your Google Sheets in plain English and get answers in the cell with =QUIRIZ(). Free to start.

Try Quiriz free →

Frequently asked questions

How do I freeze the top row in Google Sheets?

Go to View > Freeze > 1 row. Row 1 stays visible while you scroll down. You can also drag the thick gray line below the row headers.

How do I freeze more than one row?

Select the row below the ones you want frozen, then View > Freeze > Up to current row — or use View > Freeze > 2 rows for exactly two.

How do I freeze a column?

Go to View > Freeze > 1 column (or "Up to current column"). This keeps the leftmost column(s) visible as you scroll right.

How do I unfreeze in Google Sheets?

Go to View > Freeze > No rows and View > Freeze > No columns to remove the frozen panes.