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

 How to freeze rows in Google sheets

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.

Freeze Your Excel Formulas
Freeze Your Excel Formulas

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.

Freeze a row in Google Sheets FAQs

What does it mean to freeze a row in Google Sheets ?

Freezing a row or column is used to keep data in the same position and see it as you scroll.

How do I freeze a row in Google Sheets app ?

Freeze or unfreeze rows or columns

  • Open Google Sheets app on your Android Smartphone.
  • Select a row or column.
  • From the menu select the option freeze or unfreeze.

Can you freeze more than 2 rows in Google Sheets ?

Yes, you can freeze more than 2 rows in google sheets.

Simply select the number of rows your want to freeze.

Go to the View menu->Freeze->Up to row n ( n will be the number of rows you have selected 3 or 4 or 5 )

Related articles :

How to recover deleted google sheets

How To Transpose Data in Google Sheets

How to count non-empty cells in google sheets

How to Count Cells based on Color in Google Sheets