How to freeze rows and columns in Google Sheets

By Zekeriya Mulbay
Table of contents

If you work with large tables and do not use the freeze function, adding or removing tables, or even navigating through the table, must be very tiring for you.

Consider a table of 10 rows with 100 columns. Did you forget what you were looking at until you got to the end?

Let's take a closer look at the freeze function. In this article, we will proceed as follows:

  • Freeze Rows
  • Freeze Columns
  • Cancel the freezing process

We will do these operations from the menu. There is also a shortcut to do them, which you can find at the end of the article.

How to freeze rows in Google Sheets?

  1. Click on any cell in the first row.
  2. Come to the menu and select the view.
  3. Click on the freeze and click 'Up to row 1'.

It is done. Scroll down as much as you want, the titles are always constant. You can also select '1 row' here. Again, this makes the first row/title constant. We will come back to this again.

How to freeze columns in Google Sheets?

  1. Click on any cell in the first column.
  2. Come to the menu and select the view.
  3. Click on the freeze and click 'Up to column 1'.

It is done. Scroll to the right as much as you want, the first column is always constant. You can also select '1 column' here. Again, this makes the first column constant. We will talk about this again in a moment.

What if I want to freeze Row 3 and Column 3?

For this, you need to come to a cell in the row and column you selected. Then, you have to do the following steps in order.

  1. Come to C3
  2. View
  3. Freeze
  4. Up to row 3
  5. Up to column C

That is it, no matter how far to the right or down you go, the first 3 rows and columns are always constant.

Did you realize that the choices you make for 1 row and 2 rows here do not matter? You do not need to do this for the 1st and 2nd Row/Column while freezing after clicking on the row and column you specified. You can select them even if you click anywhere and go to the menu.

How to unfreeze rows or columns in Google Sheets

To cancel the freezing operations we have done, without clicking any cell, it will be sufficient to come to the menu, click the freeze and select no rows for rows and no column for columns.

Now let's show you a shortcut of what we do. The gray lines at the intersection of Row 1 and Column A do our freezing process in a short way. We can drag these lines to the row and column we want and perform the freezing process. For Line 5, simply drop the gray line below Line 5. For its cancellation, we leave it back to the starting point.

That is it! Now you can navigate large tables without confusion.

Spread the word