dthlogo cropped
digital hub logo white transparent

How to freeze row in google sheets guide

how to freeze row in google sheets completed
Table of Contents

How to freeze row in google sheets step by step guide

Over the years being an seo consultant, for my clients I have made thousands of SEO audits and reports for my clients using Google Sheets. Sometimes the data I have on a website is huge and very intricate, and I forget the header as I scroll down, so I need to know how to freeze row in Google Sheets.

Also, when helping friends and those new to Sheets, they would do the same and forget what the columns meant, so that was the inspiration for this blog on how to freeze a row in Google Sheets. There are only 3 steps, and it should only take you 30 seconds; hopefully, this will help save you so much time and frustration.

Why would you want to freeze a row in Google sheets?

As I mentioned I am used to large sets of data when I am working with my clients. Here are some common reasons on why you might want to freeze a row in Google Sheets:

  1. To keep headers visible when I am doing keyword research. Sometimes I might do an export from my SEO tools. I see CPC, keyword volume and there could be 4000 rows. Sometimes the data looks similar, and it's important for me to see the headers as I'm going down when I am analysing.
  2. To reduce any errors. Sometimes you may have a Google Sheet with lots of data in it and many columns, but not all the columns have actual data inside. So when you are going down, you can forget which header is for which column. Maybe you're in a sales business doing a posting campaign, and you want to know if you have made that post drop or not.
  3. Keeping summary totals, insights, or algorithms. One of the secret gems I like to use when I show you how to freeze row in Google sheets, is that you can actually freeze more than one row. So think about totals or formulas. When I forecast search volume for a blog content calendar, I like to total them up at the top. When I scroll down and add in more blogs, I can see the total at the top.
  4. Easier comparison. When looking at client site pages that I am optimising, I like to have my goal stats at the top. When I am going through each page, and some of my clients have 100s of pages, I can check out the stats that its performing by using reports from Search Console etc vs the goals I have set to compare how well it's doing.

How to freeze row in Google Sheets

Now, you can see below, here is an example of Google Sheets that has not been frozen. This is what you should see at the start, with your own data. From here, how to freeze row in Google Sheets actually takes 3 steps, and I will show you how below with pictures.

how to freeze row in google sheets titled google sheet with numbers

How to freeze row in Google Sheets - Step 1

Step one: look at the top of Google Sheets, and you will see File, Edit, View, Insert. Click the View button, and it will expand.

how to freeze row in google sheets step with view options

How to freeze row in Google Sheets - Step 2

So step 2 on how to freeze a row in Google Sheets, is to find the freeze button. It is the second option down after Show. Google Sheets actually makes it super easy to freeze, and the button is called Freeze.

how to freeze row in google sheets with freeze option opened

How to freeze a row in Google Sheets - step 3

Now from here there are a few options:

how to freeze a row in google sheets with columns and row options

No rows

There is the term "no rows" that literally means freeze no rows. No need to select that.

1 row

If you just want to freeze the first row and in my screenshot row is my header, go ahead and press that button and you have just successfully learnt how to freeze a row in google sheets.

2 rows

Sometimes your header may have 2 rows and there is a default setting in google sheets that allows you to freeze 2 rows, so select it if you want to freeze the top 2 rows.

Up to row (your number)

So its possible to freeze as many rows as you want. But be warned it will freeze every row up until that row, so I mean if you press up to row 8, it will freeze all rows 1-8. Now you might not see up to row 8 on your screen as that is my example. What you have to do is actually press the row before you start step 1 of how to freeze row in Google Sheets.

Then follow the 1-3 steps and now select the up to row 8 to freeze all of them. This is particularly useful this setting if I have a huge formula and headings with lots of things I want to compare as I am scrolling down.

How to freeze row in Google Sheets test for completion

So, to make sure you have frozen your rows, go and have a look at the row you think you have frozen and you should now see a grey line at the bottom of the row. Also, scroll up and down with your mouse or trackpad, and you should notice it is frozen. You can see that in the picture below, where my mouse is pointing.

how to freeze row in google sheets completed

How to un freeze row in Google Sheets

So sometimes you no longer need to have that row frozen, or you might have made a mistake freezing too many rows. To unfreeze a row in Google Sheets, simply follow steps 1-3: press View, press Freeze, but this time press the No rows button, and this will unfreeze the rows for you. Super simple.

how to un freeze a row in google sheets option

How to freeze a column in Google Sheets

So some people work in rows looking downwards but for certain tasks I may look at my data left to right. Its important to know how to freeze a column in Google Sheets as well. Its actually the same exact process on how to freeze a row google sheets.

How to freeze a column in Google Sheets - step 1

Head over to the top of your page, and hit view, its in between edit and insert.

How to freeze a column in Google Sheets - step 2

From there hit the freeze button. The freeze button is the same magical step to freeze rows and columns.

How to freeze a column in Google Sheets - step 3

From here, you will see some freeze row options at the top, but what you want to do is scroll slightly down, and you will see similar options to freeze columns. No columns, 1 column, 2 columns, and up to columns options. Selection what you want to freeze.

The beauty is that you can actually freeze rows and columns in the same google sheet or independently of each other. This makes scrolling and analysing data so much quicker for me; all I have to do is scroll left to right and up and down, and I don't forget the headings.

How to freeze row in Google Sheets FAQ's

How to lock a row in Google Sheets so it doesn't scroll?

To lock a row in Google Sheets so it doesn't scroll, press View, press Freeze, and then choose the row or multiple rows; this will freeze them. Tip: If you don't see all the rows you want, come out of the selection and click the row with your mouse, then follow those steps; from the freeze selection, it will show up to the row you have selected with your mouse.

How do I freeze up to 3 rows in Google Sheets?

So by default, you will be able to freeze rows 1 row 2 to be able to freeze up to freeze 3 rows in Google Sheets. Click on row 3 with your mouse, the actual number, then follow the steps on how to freeze row in Google Sheets, and there should now be an option at Freeze saying: "Up to row 3".

What is the freeze option in Google Sheets?

The freeze option in Google Sheets allows you to freeze headings for rows and columns so when you are scrolling through data, you can still see the important headings you may have set.

How to freeze a row in Google Sheets mobile?

It's actually even easier to freeze a row in Google Sheets mobile than on the desktop app. Sometimes I work on the phone and want to look at my sheets and see all the headings. Go to the row you want to freeze, such as row 1, and tap the 1 (so before A1). Tap it again, and you will see some options.

I have a small iPhone, so you may see the options come up saying cut, copy, auto-fill, clear and then an arrow. Press the arrow and more options will appear saying delete row and then freeze row. Press freeze row and thats how to freeze a row in Google Sheets mobile. To unfreeze follow the same quick instructions, its super easy. You can also follow the same instructions to freeze a column in Google Sheets mobile.

account icon
date icon
comment bubble icon
maddison profile
ABOUT THE AUTHOR

Maddison R

With over 10 years experience in the SEO and search space, Maddison is an expert in traffic growth strategies and growing your presence online.

Leave a Reply

Your email address will not be published. Required fields are marked *

More Digital Marketing Tips & Tricks

November 5, 2026
What Is Online Storage, How Does It Work and What Are the Best Online Storage Options?

You've finished working on a document, closed your laptop and realised you need to send it to someone. The problem? It's saved on your work computer, and you're already home. That's where online storage comes in. Instead of keeping everything on one device, you can save your files online and pick them up wherever you're […]

Read More
October 23, 2026
How Nonprofits Can Get the Most Out of Google Ad Grants

Running a nonprofit means making every dollar count between delivering services, finding volunteers, and keeping supporters involved; there's much left for advertising that's where Google Ad Grants can help. The program gives qualified nonprofits access to free Google Search advertising, helping them reach people already looking for causes, services or chances to get involved but […]

Read More
October 19, 2026
Unlock Your Store's Potential: Black Friday Checklist 2026 - Free Black Friday Ecommerce Checklist Download

Turn Black Friday Website Traffic into Revenue with our Site & UX Black Friday Checklist Select your platform - Shopify, WooCommerce, Squarespace, BigCommerce and more. This holiday checklist for ecommerce store owners will get you ready for the sales season. This free ultimate black friday cyber monday ecommerce checklist is all about websiteperformance, UX and […]

Read More
search bites seo webinars
Sign up to Search Bites to get SEO and AI search tips - a quick overview of the best bits!
*Your details will be treated in accordance with our privacy policy
33 Berry St, North Sydney, NSW, Australia (by appointment only)
linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram