How to Freeze a Row & Columns in Google Sheets

To freeze a row or a column in Google Sheets is similar to locking specific a column or a row. When we are dealing with a lot of information in Google Sheets, sometimes we have to lock the column or a row to refer to the other information.

The locked or freeze columns and cells are visible to the users while scrolling through the information.

This blog will help the readers to understand the method of freezing a row or a column in Google Sheets. 

What is a Method to Freeze a Row and a Column in Google Sheets?

To freeze a row and a column in Google Sheets, some simple steps have to be followed. The steps are:

  • Select the row or a column that is supposed to be freeze.
  • At the menu bar, click on “View” and then choose “Freeze” from the drop-down menu.
  • Choose the number of rows or columns which are supposed to be freeze in Google Sheets.

What is a Method to Freeze a Row in Google Sheets?

To understand these steps, we will consider an example. We have a Google Sheet with the name “Students Results”:

In the above figure, we can notice that the spreadsheet contains more than 15 rows. Let’s scroll down the spreadsheet to view the last rows:

Now we will freeze the first row of the “Header” and to do so, we will follow the above steps.

Step 1: Select the First Row to Freeze

Select the first row by clicking on the row serial number:

Step 2: Click on the “View” on the Menu Bar

Click on the “View” option in the top menu bar of the sheet:

Step 3: Click on the “Freeze” in the Menu that Appeared

Now choose “Freeze” from the drop-down menu, and then choose the “2 rows”:

The specified rows have been freezed and it can be verified by scrolling down the sheet:

We can see that while scrolling down the sheet, the first two rows are frozen and remain visible. 

What is a Method to Freeze a Column in the Google Sheets?

Again consider the “Student Results” of the above example, and freeze the column of the “Student Names”. Freezing a column is similar to freezing a row, for example, select the first column of the “Student Results”:

Then choose “View” from the top menu, then click “Freeze”, and then “1 Column”:

Now to verify the column has been freeze scroll the sheet to the right:

The column has been successfully freeze. 

What is a Method to Unfreeze or unlock a Row and a Column in Google Sheets?

To unfreeze a row and column, follow all the steps used to freeze them. But instead of choosing the number of rows and columns to freeze, choose “No row” and “No Column”. For example, in our case, Select the first row, then click on “View” in the top menu, and choose “Freeze”:

Now choose the “No rows” and “No columns” from the drop-down menu:

And the frozen row and column have been unfrozen:

This is the simple approach by which you can unfreeze a column and a row in Google Sheets. 


To freeze a row & a column in Google Sheets, click on “View” in the menu bar and then select “Freeze” to freeze columns and rows. Multiple rows and columns can be freeze by choosing more rows and columns. This blog explains the steps with the example to freeze a column and a row of Google Sheets in detail.