Better Sheets

How to unfreeze cells 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.

Related tutorials

These videos might help you go deeper on this topic.

Watch more tutorials

How to Merge Cells in Google Sheets

A master class on merging cells. How to merge two cells. How to merge mu...

Beginner

CONCATENATE() JOIN()

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.

Month in a Cell

Month in a Cell

Watch on YouTube →

Count First Digit of Cell

Count First Digit of Cell

Watch on YouTube →

Year on a Cell

Year on a Cell

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 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 a row 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 →

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