Guide on How to Freeze Rows/Columns in Google Sheets

When dealing with large datasets in Google Sheets that require frequent scrolling, you might find it helpful to freeze/lock certain rows to facilitate easier navigation. Let’s explore this topic further in the following article.

Freezing rows at the top ensures they remain visible at all times, providing a constant reference point and helping you identify which columns represent specific data.

Let’s examine the following data table:

The first row is evidently frozen to remain visible as you scroll through the dataset.

We’ll show you two quick ways to easily freeze rows in Google Sheets.

#1 Use the Mouse

This is an ultra-fast way to freeze rows in Google Sheets.

At the top-left corner of the sheet, you’ll notice a gray empty box. Click on it.

All you need to do is hover your mouse over this box, and when you see the hand icon, left-click and drag down.

This will instantly freeze all the rows above the gray line (as shown below):

#2 Use the View Option in Google Sheets

While the mouse trick explained in the previous guide is handy and time-saving, there’s another equally convenient way to freeze rows in Google Sheets.

Follow these steps:

  1. Select the cell in the rows you want to freeze. For example, if you want to lock the top 5 rows, select a cell in row 5.
  2. Go to the View tab > Freeze > Up to Current Row (5). Note that the number in parentheses will vary based on the cell you selected.

Additionally, note that Google Sheets provides two default options – freeze the top row or freeze the top two rows.

Unfreeze Rows

Once again, there are two similar ways to unfreeze rows in Google Sheets:

Using the mouse: Hover over the gray bar that appears just below the last frozen row. Left-click and drag it to the top. This will unfreeze all the frozen rows.

Using the View option: Go to View > Freeze > No rows.

So, we’ve provided you with comprehensive methods to quickly freeze rows in Google Sheets. Hopefully, after reading this article, you’ll be able to use Google Sheets features more efficiently, saving you time.

Leave a Comment

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

Shopping Basket
Scroll to Top