How to freeze rows in google sheets

Freezing rows can help you in better visualization and analysis of the spreadsheet data.

2 Ways to Freeze Rows in Google Sheets

  • Freeze the first row 
  • Freeze a certain number of rows up to the current row

Freezing the rows will also ensure that the row sticks on the top while scrolling. So if you want to pin a row to the top, check the above 2 methods.


Method 1: Freeze the First Row in Google Sheets 

Step 1: Open up your Google Sheets file. 

Step 2: Go to the View menu. 

Once we have a spreadsheet opened, go ahead and click the View button found at the Menu bar. This will be located at the top-left corner of your Google Sheets window.

Step 3: Freeze the first row of your spreadsheet. 

After you’ve clicked on the View tab and have opened the drop-down menu, click on Freeze.

This will open up another drop-down menu with different options and features. From there, simply click on and select the 1 row option. 

Alternatively, if you want to freeze the first two rows, then select 2 rows from the list of Freeze options. 

Important Point:

Once you freeze the row, it will also make it sticky. In other words, the frozen row will stick to the top while scrolling.


Method 2: Freeze Rows up to the Current Row

Here’s how you can freeze a certain number of rows.

Step 1: Open up your Google Sheets file. 

Step 2: Select or highlight a row. 

Now that we have our file opened, click the last row of the chosen set of rows that you want to freeze. You will need to click on the row number to select a row. Note that Google Sheets will always start from row 1 up to the row you have selected. 

For this example, we will select row 10

Alternatively, you can simply select a cell in that row. Both ways will work the same way.

Step 3: Go to the View menu.   

From there, go to the View menu. Once again, you’ll find this at the top-left corner of your screen. After opening the drop-down menu, select Freeze to show more options.

Now, select Up to current row (#)

If you are using a copy of our document or click on the same row we did, it should say Up to current row (10).  

Once you try to scroll up or down, you should notice that the first 10 rows are fixed in place.

Now, if you’re curious about how many rows you can actually freeze in Google Sheets, then go ahead and try. But, to save you the trouble, we tried this out ourselves. Here’s what we got: 


Unfreeze Rows in Google Sheets 

Simply expand the Freeze options and select No rows


Freezing Columns in Google Sheets

Alternatively, you’ll also find it useful to learn about how to freeze columns in Google Sheets. The steps are pretty much the same, except for the obvious fact that you will be selecting columns instead of rows. 

Freeze the first column of your spreadsheet 

Go to the View menu and select Freeze. This will show you more options. Select 1 column or 2 columns to freeze the first column or the first two columns, respectively. 

  1. Select 1 column to freeze the first column. 
  2. Select 2 columns to freeze the first 2 columns. 

Freeze up to the current column

If you want to freeze more than 2 columns, you will have to select a column of reference. Google Sheets will always freeze columns from column A to the column you selected.

For this example, we will freeze columns A to D.

Just like the rows, you cannot freeze more columns than the width of your window. This would make the point of freezing them useless. 


Conclusion

You have finally arrived at the end of this guide. We hope that we’ve helped you figure out how to freeze rows in Google Sheets.

Leave a Comment