How To Freeze Cells In Google Sheets

In this tutorial, you will learn how to freeze cells in Google Sheets.

How To Freeze Cells In Google Sheets

Users that are working with data in a spreadsheet may find it overwhelming or tedious to handle large datasets.

It can be helpful to “freeze” certain rows or columns so they stay visible while you scroll. This option can be a great way to keep the top row of your spreadsheet in view while you scroll down, or keep a certain column visible while you scroll to the right.

Fortunately, Google Sheets makes it easy to freeze or lock certain cells. In this guide, we will show you how to freeze cells in Google Sheets, and explain when you might want to use this feature.

How To Freeze Rows and Columns In Google Sheets

Here’s how to freeze rows and columns in Google Sheets.

Step 1

We’ll first explain how to freeze rows in Google Sheets.

First, select the row you want to freeze by clicking on the row header.

In this example, we want to freeze the first row which contains the column headers of our employee directory table.

Step 2

Select View > Freeze> 1 row to apply the Freeze option to the current sheet.

Step 3

The first row of your sheet should now remain in place even as you scroll down.

Step 4

Suppose you want to freeze the top two rows of the current sheet. We can do this by selecting the second row.

Step 5

Now click on View > Freeze > Up to row 2.

Users can perform this procedure for any arbitrary number of rows.

Step 6

The frozen cells can be identified by a thicker border separating them from the unfrozen cells.

Step 7

To freeze columns, select one or more rows on the left-hand side of the spreadsheet.

Step 8

Select the option in View > Freeze > Up to column A.

Step 9

The frozen columns should now remain in place as you scroll the spreadshee to the right.

Step 10

To unfreeze columns or rows, first select the range you want to unfreeze.

Next, head to the View menu and hover over the Freeze option. You can click either No rows or No columns.

Summary

This guide should be everything you need to freeze cells in Google Sheets. You may make a copy of this example spreadsheet to test it out on your own.