How to Freeze Rows in Google Sheets: Easy Guide 2021 -

In this tutorial, we will learn, How to freeze rows in Google sheets

To freeze rows in google sheets :

Use the right click mouse button
Use the Freeze option in the Main menu

We often work with large datasets in Google sheets where it becomes difficult to analyze the data by scrolling down or moving to the right of your sheet.

To fix this issue we need to freeze rows in google sheets so that the relevant rows and columns are visible to analyze the required data.

Let’s find out How to freeze rows in google sheets.

How to freeze rows in Google sheets : Step by Step Guide

Following are the steps to freeze rows in google sheets.

Simply using mouse click

Step 1: Open Google sheets

Open google sheets where you want to freeze the rows

Step 2: Move your mouse cursor to the upper left corner of the sheet until it changes into a hand icon as shown below

Step 3: Now press and hold the right mouse click and move the line down

If you want to freeze only the first row drag the line below the first row and release the right click.

If you want to freeze all the rows drag the line below the last row and release the right click.

Using Freeze Option in the Menu ->View

Go to View menu in the Main menubar
Under View -> go to Freeze->Up to row 1

This will freeze the first row of the worksheet.

Following the same method, you can freeze more than 1 row.

However, if you want to freeze more than 6 rows, follow the below steps.

Select a cell on the sixth row as we want to freeze until 6th row

Navigate to the Main menu and go to click on View.
Under View menu drop down ,Select Freeze
Under Freeze click on “Up to row 6”

This will immediately lock the first 6 rows of the google sheet which will be always visible when you scroll.

How to Unfreeze Rows in Google Sheets

Follow the below steps to unfreeze rows and columns in google sheets

To Unfreeze row :

Navigate to the Main menu and go to click on View.
Under View menu drop down ,Select Freeze
Under Freeze click on “No rows “

To Unfreeze columns :

Navigate to the Main menu and go to click on View.
Under View menu drop down ,Select Freeze
Under Freeze click on “No Columns “

We hope this tutorial has helped you learn about how to freeze/unfreeze a row in google sheets. So next time you work with large data sets, you can confidently freeze a row or column to make your life easier.