How to Freeze Rows in Google Sheets 🧊 | 2 min easy guide

How to Freeze Rows in Google Sheets 🧊 | 2 min easy guide
Reading Time: 3 minutes
Freeze rows in Google Sheets
Freeze rows in Google Sheets

In this article we would have a look at how to freeze rows in Google Sheets.

When you are working with long tables then you’d still want to see the headers for the particular row or column. A good way to solve this problem would be to free row in Google Sheets. Freezing a row would basically make the corresponding row sticky and even if you scroll down, it would still appear on the screen. Similarly freezing a column would make the column sticky and it would still appear if you scroll right.

Freeze rows in Google Sheets using the shortcut

Let’s say there exists a table with a list of cities and their coordinates. This list has many entries and many fields. 

Sample table
Figure 1: Sample Table

Freezing the first row would be a great way to keep track of what data field we are looking at as it won’t be very apparent by looking at the values. To freeze the first row follow the given steps. 

  1. Take the mouse cursor to the top left grey box. This box is located just above the first row on the left side. It has two dark edges.
  2. Since we want to freeze rows, take the bottom edge and drag the edge to the number of rows you want to freeze. 
  3. Since we want to freeze the top row, we will just drag it by one row.

This would freeze the top row and it would look like this even if you scroll.

Freeze rows using shortcut
Figure 2: Freeze rows using Shortcut

If you want to freeze columns, you can do so by dragging the right grey border of the mentioned cell.

Freeze rows using the menu option

You can also freeze rows in Google Sheets using the menu option in Google Sheets. To do so follow the given steps. 

  1. Select any row or any cell till where you want to freeze.
  2. Go to View>Freeze
  3. Option to freeze one or two rows is given by default. But, if you want to freeze more, you’ll be given an additional option based on the selected cell in step 1.
Freeze rows using menu
Figure 3: Freeze rows using Menu

This would freeze the desired rows. 

Additionally, if you want to freeze columns you can do so by the same menu options. 

How to unfreeze rows in Google Sheets

Unfreezing rows is as easy as freezing them. There are essentially two ways in which you can unfreeze your cells. 

  1. There appears a grey bar till the point you have frozen the rows. You simply have to drag that grey bar back to the cell where it was originally( See the section “Freeze rows in Google Sheets using the shortcut”). This will unfreeze the frozen rows.
  2. The second option is to go to View>Freeze>No rows. This would unfreeze any frozen rows. To unfreeze columns, you can click on “No columns” option.
Unfreezing a frozen row
Figure 4: Unfreezing a frozen row

Conclusion

We saw how to freeze rows in Google Sheets. Additionally, we also saw how to freeze columns. In the end we saw how to unfreeze them. As side note, freezing a row is also called anchoring, since you are using the frozen rows as anchors. You can check the official documentation for this feature here

See Also

You can checkout other equally good articles on Google Sheets here.

How to Create Google Calendar Events from Google Sheets: Learn how to create Google Calendar events from Google Sheets.

ARRAYFORMULA in Google Sheets: Learn how to use the ARRAYFORMULA function in Google Sheets and its variations.

Delete Empty rows in Google Sheets: In this article we would see how to delete empty rows in Google Sheets using two different ways.

How to group rows in Google Sheets: We will learn how to group rows in Google Sheets. We will also have a look at nested grouping.