How to Stop Freezing Rows in Google Sheets

Many of the issues that you might encounter when working with a spreadsheet may not actually have anything to do with the data in your cells. After you’ve gone through the trouble of generating your data and created all your formulas and charts, you may find that you’re having trouble simply navigating through all of that data.

One way to resolve this issue is by freezing a row or two at the top of the sheet. This lets you scroll down while still keeping important data, such as your row headings, visible. But if you’re working on a sheet that was created by someone else and it has these frozen rows, then you may be looking for a way to unfreeze them. Our guide below will show you how.

How to Unfreeze Rows in Google Sheets

The steps in this article were performed in the desktop version of the Google Chrome Web browser, but will also work in other desktop browsers like Edge and Firefox.

Step 1: Sign into your Google Drive at and open the spreadsheet with the row(s) that you want to unfreeze.

Step 2: Click the View tab at the top of the window.

click the view tab

Step 3: Select the Freeze option, then click the No rows option.

how to stop freezing rows in google sheets

If you are looking for a way to freeze your rows, rather than unfreeze them, then this article will show you how.

See also

Newest Guides