How To Freeze Rows In Google Sheets In 2 Easy Ways

Whenever we’re making a datasheet, the information we put can sometimes be overwhelming and can make it difficult for us to scroll through the contents of the document. But, that’s when freezing certain rows and columns in sheets becomes necessary.


It allows us to easily scroll and browse through all the data we have in a certain sheet or page. Freezing rows and columns can easily be done on any device so you don’t have to worry about trying it on your mobile phone or desktop.

Here’s a guide that can greatly help you with it.

Freezing Rows and Columns With the Menu Options

There are actually two ways you can use to freeze rows and columns, and the first one is using the menu options. This is actually the long method but later I’ll be teaching you how to do it with fewer clicks.

1. Open Google Sheets and select the rows or columns you want to freeze.

When you’re on google sheet, open the document you wish to edit. Afterward, choose the columns or rows you wish to freeze. To show you a better example of it, let’s say we’re going to freeze the first and second row in the data set below.

2. Click View at the Menu bar and select “Freeze”.

After clicking View, the very first option to show would be “Freeze”.

Now when you select freeze, you will have to choose what row(s) you want to freeze. Since we achieve to freeze the first two rows, make sure to click the “2 rows” option.

After accomplishing this step, you’d be able to freeze the first two rows in the worksheet

Freezing Rows and Columns Using the Mouse

The first one I taught you was the long method, now it’s time to teach you the shortcut. You can actually freeze the rows and columns you want using just the mouse, and it’s much easier too. Here’s how to do it.

1. Take your cursor to the top-left gray part of the worksheet.

If you’re having a hard time locating this, here’s what it really looks like:

2. Hold and drag it down until you reach the end of the row(s) you want to freeze.

When you place your cursor at that horizontal gray line, wait for it to turn into a hand icon. After that, move it down and just stop until the end of the row you want to freeze.

For the example below, I dragged the line just below the second row because that’s just what I wish to freeze.

Manage Your Worksheets Better

Freezing rows can make your scrolling in a worksheet full of data be convenient and easier. There isn’t a limit to the number of rows or columns you can freeze, just make sure to follow these steps to successfully achieve what you want in freezing rows or columns.

When handling large datasets, applying this feature can be very useful. I hope this guide helped you a lot!