---
title: "How to freeze columns and rows in Google Sheets"
description: "Here's how to freeze columns and rows in Google Sheets so you can always see the data you need—even as you scroll through your spreadsheet."
image: "https://images.ctfassets.net/lzny33ho1g45/1d2ScS0XusebtTq7GvoL2T/783a6630bf45516429baa1a4e7ba4711/google-sheets-app-tips.jpg"
---

# How to freeze columns and rows in Google Sheets

Here's how to freeze columns and rows in Google Sheets so you can always see the data you need—even as you scroll through your spreadsheet.

Whenever I'm working with large datasets in [Google Sheets](https://vendors.selectsoftwarereviews.com/redirect/1767831752373x549042478702919700?p=1715808885462x244895206427328500), it's easy for me to lose track of what's what—especially without headers locked in place. Take this simple student grade sheet below, for example. 

Notice that as I scroll across the sheet, the student names and IDs disappear. With this view, it's nearly impossible for me to remember which grade belongs to which student. 

That's where the _Freeze_ function comes in. It lets you pin columns and rows in place so you can see the data you need at all times, even as you scroll through your spreadsheet. Here's how to do it. 

**Table of contents**: 

- [How to freeze columns in Google Sheets](#freeze-columns)
- [How to freeze rows in Google Sheets](#freeze-rows)
- [Automate Google Sheets](#automate)

## How to freeze columns in Google Sheets 

Here's the easiest way to freeze a column or multiple columns in [Google Sheets](https://zapier.com/blog/google-sheets-tutorial/). 

In the top-left corner of your spreadsheet, next to _column A_ and above _row 1_, there are two thick, gray bars running horizontally and vertically. 

Click the vertical bar and drag it across to the right side of the last column you want to freeze. For example, let's pin up to the student IDs in column C.

To unfreeze a column, drag the bar back to its original position. 

If you, like me, get frustrated about having to get your cursor in _just the right spot_, there's another way. 

1. Open a Google Sheets spreadsheet.
2. Select the columns you want to freeze.
3. Click **View**, and then select **Freeze**.
4. Click **Up to column [column letter]**.

To unfreeze a column, repeat the same steps, but instead of clicking _Up to column C_, click **No columns**. 

## How to freeze rows in Google Sheets 

You can freeze rows in Google Sheets the same way you can with columns. 

The easiest method: Click and drag the horizontal gray bar (next to _column A_ and above _row 1) _below the last row you want to freeze. 

Alternatively, you can take the route that requires less cursor accuracy: 

1. Open a Google Sheets spreadsheet.
2. Select the rows you want to freeze.
3. Click **View**, and then select **Freeze**.
4. Click **Up to row [row number]**.

These are simple examples, but when you're reviewing grades for 40 or so students—or you're working with a large dataset of any sort—freezing columns and rows makes scrolling through the data much more manageable.

## Automate Google Sheets

Manual data entry is ripe for human error. With Zapier, you can [connect Google Sheets](https://zapier.com/apps/google-sheets/integrations) with thousands of other apps and make Sheets your source of truth. Automatically do things like add lead data and form submissions to an existing spreadsheet, analyze that data with AI, or send spreadsheet data to another app in your tech stack. Learn more about [how to automate Google Sheets](https://zapier.com/blog/automate-google-sheets/), or get started with one of these workflow templates.   

**Related reading:**

- [Google Sheets add-ons to boost your productivity](https://zapier.com/blog/best-google-sheets-addons/)
- [Google Sheets vs. Excel: Which is right for you?](https://zapier.com/blog/google-sheets-vs-excel/)
- [How to use VLOOKUP in Google Sheets](https://zapier.com/blog/vlookup-in-google-sheets/)
- [How to lock cells in Google Sheets](https://zapier.com/blog/how-to-lock-cells-google-sheets)
- [How to hide rows in Google Sheets](https://zapier.com/blog/how-to-hide-rows-google-sheets)

_This article was originally published in December 2023. The most recent update was in May 2025. _