How to Freeze Columns in Google Sheets: A Step-by-Step Guide

Freezing columns in Google Sheets is a nifty trick that can make navigating large spreadsheets a breeze. It’s like putting a sticky note on the columns you always want to see, no matter where you scroll. In less than a minute, you can lock as many columns as you need, and they’ll stay put. So, let’s get into it, shall we?

Step by Step Tutorial: How to Freeze Columns in Google Sheets

First things first, let’s understand what we’re about to do. Freezing columns in Google Sheets means that certain columns won’t move when you scroll horizontally. This is particularly useful when you’re dealing with wide spreadsheets and want to keep track of the data in the first few columns.

Step 1: Open your Google Sheet

Open the Google Sheet where you want to freeze the columns.
This is the starting point. Make sure you’re logged into your Google account and have the spreadsheet open.

Step 2: Select the column(s)

Click on the letter at the top of the column you want to freeze.
If you want to freeze multiple columns, click and drag to select them all.

Step 3: Go to the View menu

Click on ‘View’ in the top menu.
You’ll find this between ‘Insert’ and ‘Format’.

Step 4: Choose ‘Freeze’

In the ‘View’ dropdown, hover over ‘Freeze’.
This will open a side menu with options to freeze up to 10 rows or 5 columns.

Step 5: Select how many columns to freeze

Click on ‘1 column’, ‘2 columns’, or ‘Up to current column’ based on your needs.
If you choose ‘Up to current column’, everything from the first column to the one you selected will be frozen.

After you’ve completed these steps, you’ll notice that the frozen columns will stay in place as you scroll through the rest of your data. It’s like they’re glued to the screen!

Tips: Enhancing Your Google Sheets Experience

  • Keep in mind that you can freeze both rows and columns at the same time for even better navigation.
  • If you’ve frozen too many columns, simply go back to the ‘View’ menu and adjust accordingly.
  • Consider using the ‘Freeze’ feature when working with large datasets, as it can help keep important information in view.
  • Remember that freezing columns will be visible to anyone you share the spreadsheet with, so it can be a handy tool for collaboration.
  • Lastly, don’t forget that you can unfreeze columns just as easily by following the same steps and selecting ‘No columns’ in the ‘Freeze’ menu.

Frequently Asked Questions

Can I freeze columns in the Google Sheets mobile app?

Yes, you can! The steps are similar but might look slightly different depending on your device.

Will freezing columns affect how my data is sorted or filtered?

Nope! Freezing columns is only about what you see on your screen. Sorting and filtering will work the same way.

Can I still edit the frozen columns?

Absolutely. Freezing columns doesn’t lock the data—it just keeps it in view.

If I freeze columns, will it print that way?

No, freezing columns is only for on-screen navigation. Printing settings are managed separately.

How do I unfreeze columns if I change my mind?

Just head back to the ‘View’ menu, go to ‘Freeze’, and select ‘No columns’. Easy peasy!


  1. Open your Google Sheet.
  2. Select the column(s).
  3. Click on ‘View’.
  4. Hover over ‘Freeze’.
  5. Click on the desired freeze option.


Freezing columns in Google Sheets is like giving yourself a set of superpowers for navigating your data. With just a few clicks, those important columns are always within sight, no matter how far to the right you scroll. It’s a simple yet effective way to manage large spreadsheets, and once you start using it, you’ll wonder how you ever got by without it.

But remember, with great power comes great responsibility. Use the freeze feature wisely, and don’t overdo it, as freezing too many columns could make navigating the rest of your data more challenging. Play around with it, find what works best for your specific needs, and optimize your data management skills.

Whether you’re crunching numbers, organizing project timelines, or just keeping track of your personal expenses, knowing how to freeze columns in Google Sheets can make your digital life a whole lot easier. So go ahead, give it a try, and watch how a little freeze can go a long way in your data-driven endeavors.

Get Our Free Newsletter

How-to guides and tech deals

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