Freeze Rows & Columns in Google Sheets- 2 Min Easy Guide

Reading Time: 3 minutes

Table of Contents

Objective

Learn how to freeze rows & columns in Google Sheets.

Why freeze rows & columns in Google Sheets?

Want to scroll down the dataset keeping specific rows and columns visible? Google Sheets has a provision for such cases. You can freeze the rows and columns you want to be visible while scrolling down or right. This article will run you through the process of freezing rows and columns.

Freeze Rows & Columns in Google Sheets Using Menu Options:

Freeze Top Row

To scroll through the dataset by freezing the top row, click on View.
Next hover over and select the Freeze option.
Select the 1 Row option.

Figure 1: Example to freeze top row of the dataset

Freeze Top 2 Rows

To scroll through the dataset by freezing the top 2 rows, click on View.
Next hover over and select the Freeze option.
Select the 2 Rows option.

Figure 2: Example to freeze top 2 rows of the dataset

Freeze N top Rows

To scroll through the dataset by freezing the top N rows, select any cell of the row.
Click on View.
Next hover over and select the Freeze option.
Select the Up to Row N option.

Figure 3: Example of freezing top N rows

Freeze Left column

To scroll through the dataset by freezing the leftmost row, click on View.
Next hover over and select the Freeze option.
Select the 1 Column option.

Figure 4: Example of freezing leftmost column of the dataset

Freeze N left columns

To scroll through the dataset by freezing the N left columns, select any cell of the column.
Click on View.
Next hover over and select the Freeze option.
Select the Up to Column N option.

Figure 5: Example of freezing N left columns of the dataset.

Freeze Rows & Columns in Google Sheets using Mouse

You can freeze columns or rows just by the use of your mouse.
Take your cursor to the top-left corner (grey box with thick grey lines).

Figure 6: Displaying the grey coloured box used for freezing rows and columns

You can drag the horizontal line to the row you want to freeze.
Similarly, you can drag the vertical grey line to the right till the columns you want to freeze.
Here, I have shown that the horizontal line has been dragged to the fourth row, thereby freezing top 4 rows.

Figure 7: Example of freeze rows & columns in Google Sheets using mouse

See Also

Conditional Formatting in Google Sheets: Get started with Conditional Formatting in Google Sheets

Double Bar Graph In Google Sheets: Learn How to Make a Double Bar Graph In Google Sheets

How to Freeze Rows & Columns in Google Sheets

Objective

Why freeze rows & columns in Google Sheets?