How to Stop Freezing Rows in Google Sheets: A Step-by-Step Guide

Freezing rows in Google Sheets is super handy when you’ve got a lot of data and you want to keep an eye on specific rows while scrolling through the rest. But sometimes, you need to get those rows unstuck. No worries, it’s an easy fix! Just follow these simple steps and your rows will be free to move around in no time.

Step by Step Tutorial: How to Stop Freezing Rows in Google Sheets

Before we get started, let’s quickly go over what we’ll be doing. The following steps will guide you through how to unfreeze rows in Google Sheets, so you can scroll through your spreadsheet without any locked rows.

Step 1: Open Your Google Sheets Document

Open the Google Sheets document you are working with.

When you’ve got your Google Sheets document open, make sure you’re on the right sheet where the rows are frozen. You can tell if rows are frozen if you see a thick gray line underneath the row numbers on the left side.

Step 2: Select the Rows

Click on the row number(s) below the frozen rows.

If you’ve got multiple rows frozen, click on the row number that comes right after the last frozen row. This selects the row and prepares it for the next step.

Step 3: Access the View Menu

Go to the ‘View’ menu at the top of your screen.

In the ‘View’ menu, you’ll see a bunch of options, but we’re interested in the ones that mention freezing and unfreezing. Don’t worry, it’s coming up next!

Step 4: Unfreeze Rows

Click on ‘Freeze’, then select ‘No rows’.

Doing this will immediately unfreeze the rows. You’ll notice that the thick gray line disappears, allowing you to scroll freely through your spreadsheet.

After you complete these steps, you’ll be able to scroll up and down your spreadsheet without any rows being stuck at the top. It’s that simple!

Tips: Enhancing Your Google Sheets Experience

  • If you change your mind and want to freeze rows again, simply go back to the ‘View’ menu and select the rows you want to freeze.
  • Remember that freezing rows is different from locking them. Locking rows requires setting permissions, while freezing just affects how you view the sheet.
  • Use keyboard shortcuts to freeze and unfreeze rows quickly. For example, you can use Alt + W + F + R on Windows to freeze the top row.
  • If you’re collaborating with others, make sure everyone is okay with you unfreezing the rows as it will affect their view as well.
  • Check out the Google Sheets Help Center for more tips and tricks on how to make the most out of your spreadsheets.

Frequently Asked Questions

Can I freeze columns as well?

Absolutely! Just like with rows, you can freeze and unfreeze columns using the ‘View’ menu.

Will unfreezing rows mess up my data?

Nope. Unfreezing rows won’t affect your data at all. It just changes the way you view your spreadsheet.

What if I can’t find the ‘View’ menu?

Make sure you’re using Google Sheets and not another spreadsheet program. The ‘View’ menu is at the top of the screen in Google Sheets.

Can I freeze and unfreeze rows on the mobile app?

Yes, you can! The steps are slightly different, but you’ll find the options to freeze and unfreeze rows in the app’s menu.

Does unfreezing rows save automatically?

Yes, just like any change in Google Sheets, it will save automatically.


  1. Open your Google Sheets document.
  2. Click on the row number(s) below frozen rows.
  3. Go to the ‘View’ menu.
  4. Click on ‘Freeze’, then ‘No rows’.


Freezing and unfreezing rows in Google Sheets is a breeze once you know how to do it. It’s a super useful feature for managing large spreadsheets and keeping track of important data. But when the time comes to let those rows run free, it’s just a few clicks away. Follow the steps outlined above, and you’ll have no trouble stopping the freeze. And hey, if you ever need to freeze them again, it’s just as easy to do.

Remember, Google Sheets is a powerful tool with lots of features to explore. So don’t stop at freezing and unfreezing rows. Dive in and see what else you can do to make your data work for you. Happy spreadsheeting!

Get Our Free Newsletter

How-to guides and tech deals

You may opt out at any time.
Read our Privacy Policy