How to unfreeze in Google Sheets

Go to View → Freeze → No rows (or No columns) to unlock frozen panes. You can also drag the thick gray freeze handle back to the top-left corner. After unfreezing, the whole sheet scrolls together again.

Steps

1
Open View → Freeze.
2
Choose No rows and/or No columns.
3
Or drag the freeze bars back to the origin.

Free 2027 printable calendar in Google Sheets The whole year on one page. Copy it to your Drive, plan the big dates, and print it as a PDF. Get the free calendar

Related tutorials

These videos might help you go deeper on this topic.

Watch more tutorials

Create an Internal Google Sheets Add-on

The entire process to create and publish a Google Sheets Add-on internal...

Intermediate

Unlock these tutorials

Related blog posts

Written guides that go deeper on this question.

Browse the blog

5 More Fixes For Your Spreadsheets

Hi, Andrew Kamphey here with Better Sheets, dedicated to helping you improve your Google Sheets every single day. Last time, I shared five ways to fix your sheets. So now, I've got five more tips to make your sheets even better. Let's dive right in! Change the Background Color Let's start by talking about color. While changing the font color is important, altering the background color can make a significant difference too, just follow these steps: 1. Select the entire background. 2. Hit...

Better Sheets on YouTube

Watch matching videos from youtube.com/bettersheets.

How to UnFreeze a Row in Google Sheets

How to UnFreeze a Row in Google Sheets

Watch on YouTube →

Terms and formulas behind this

Want the full definition or how a formula works? Start here.

Freeze rows and columns

Freezing locks the top rows or left columns in place while the rest of the sheet scrolls. View > Freeze lets you pin ...

COLUMNS()

Google Sheets COLUMNS() function guide

ROWS()

Google Sheets ROWS() function guide

Related questions

How to unfreeze rows in Google Sheets

Go to View → Freeze → No rows (or No columns) to unlock frozen panes. You can also drag the thick gray freeze handle back to the top-left corner. After unfreezing, the whole sheet scrolls together again.

Get the answer →

How to freeze rows and columns in Google Sheets

Click View → Freeze and choose 1 column or 2 columns, or freeze up to the selected column. You can also drag the vertical freeze handle to the right of column A. Frozen columns stay visible while you scroll sideways through wide sheets.

Get the answer →

How to unfreeze columns in Google Sheets

Go to View → Freeze → No rows (or No columns) to unlock frozen panes. You can also drag the thick gray freeze handle back to the top-left corner. After unfreezing, the whole sheet scrolls together again.

Get the answer →

How to unfreeze Google Sheets

Go to View → Freeze → No rows (or No columns) to unlock frozen panes. You can also drag the thick gray freeze handle back to the top-left corner. After unfreezing, the whole sheet scrolls together again.

Get the answer →

How to freeze 3 columns in Google Sheets

Click View → Freeze and choose 1 column or 2 columns, or freeze up to the selected column. You can also drag the vertical freeze handle to the right of column A. Frozen columns stay visible while you scroll sideways through wide sheets.

Get the answer →

Need more than a quick answer?

600+ walkthrough videos, unlimited generators, and every template. From $9/month. Practical lessons. Zero fluff.

Need one fix

Watch a free tutorial for the step-by-step version of any answer.

Browse more questions

Learning Sheets for real

Unlock the full library, generators, and templates with membership.

Unlock membership

Ads keep the free stuff free. Members browse ad-free — log in or see pricing.