How to Freeze Rows & Columns in Google Sheets

How to Freeze Rows & Columns in Google Sheets
Reading Time: 3 minutes

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.
Example of freeze rows & columns in Google Sheets.
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.
Example of freeze rows & columns in Google Sheets.
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.
Example of freeze rows & columns in Google Sheets.
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.
Example of freeze rows & columns in Google Sheets.
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).
Example of freeze rows & columns in Google Sheets.
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.
Example of freeze rows & columns in Google Sheets.
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