How to freeze multiple rows in Google Sheets

When you have an intimidatingly long spreadsheet to go through, it’s easy to forget what your header looked like after multiple rows of scrolling. The solution is to freeze rows on your spreadsheet. Though most users only need one or two rows frozen, Google Sheets allows you to freeze up to as many rows you need.

Freezing rows freezes, or locks, specified rows in place. This will allow you to scroll through your Google spreadsheet without that particular row moving. You can apply the same function to columns in case you need to scroll horizontally as opposed to vertically.

Freeze Rows Limitations

Google Sheets is known for simplifying spreadsheet tasks and doing a good job at keeping up with some more of the advanced features Excel users have come to love. However, when it comes to the “freeze” feature, the simplicity may prove a bit limiting to some more advanced users.

As of now, Google Sheets only allows you to freeze rows that appear consecutively from the top down. For instance, you can freeze rows 1-4, but you cannot freeze row 4 on its own. This makes the feature a bit more limited than what you would find in a program like Microsoft Excel.

If You Want to Isolate a Non-Consecutive Row

If there is important information on a non-consecutive row that you need to see, you’ll have to freeze up to that row and hide the rows before the desired one. You can always undo any freeze/hide later on. Now with that little disclaimer, let’s get to showing you how to freeze rows on Google Sheets!

Using the Freeze Rows Feature

The process is a simple one. Even before you fill in your spreadsheet you’ll be given three different freeze options. The feature does not rely on populated cell data to work.

1. Go to View
2. From here, you will click on the Freeze option.
3. You should see the following:

• No rows
• 1 Row: If you want to freeze one row, select “1 Row.” This is a good option for those who have a simple header.
• 2 Rows: If you want to freeze up to two rows (both row 1 and 2), select “2 Rows.” This is a good option for those who have merged cell headers.
• Up to Current Row (x)

If you want to freeze rows further down the spreadsheet:

1. Click on the row number along the left-hand side. This will highlight the row.
2. Go to View
3. Click Freeze
4. Select Up to Current Row.

Readjusting Frozen Rows

Once any row or set of rows has been frozen, a thick, grey border will appear separating the frozen rows from the non-static portion of the sheet. You can move this border manually to readjust the rows you would like to keep static.

1. Mouse over the border.
2. A hand icon will appear.
3. Click and drag the border up or down according to your needs.

Unfreezing Rows

You can easily undo all frozen rows.

1. Go to View
2. Click Freeze
3. Select No Rows

You’ll know the changes have been applied when the grey border disappears and the entire spreadsheet is scrollable.

In Conclusion

This simple function can make a data-gathering session all that easier. Even with the limitations that come with it, it is a top-notch feature that adds to Google Sheets’ accessibility and ease of use.

Currently, Google Sheets can be used to "freeze" sections of a document so that those sections always persist when scrolling, as demonstrated in this video. However, a limitation of this is that only one section can be selected, and it must be relative to the beginning of the document, whether it's defined in rows or columns.

Is it at all possible to freeze a second, separate row further down the spreadsheet so that, when scrolling, the first frozen row persists at the top of the sheet until the second frozen row is encountered and replaces the first?

In Google Sheets, you can freeze rows and columns in your spreadsheet, so that a specified amount of rows and/or columns will stay locked in place when you scroll, such as when you want to lock your header rows, or lock a column on the left side of your sheet. This makes it much easier to read your sheets when the data extends beyond the screen view, where you want to be able to always show the row(s) at the top or the column(s) on the left.

In this lesson I am going to show you how to freeze rows, columns, both rows and columns at the same time, and I'll also show you how to unfreeze rows / columns.

There are two different ways to freeze rows and columns in Google Sheets. You can either use the click and drag method, or you can use the "View" menu, which is the main method that I will use in the examples, but below I will teach you how to use both of these methods.

To freeze rows and / or columns in Google Sheets, follow these steps:

• Select any cell that is in the column / row that you want to freeze (You may also select the entire row or column)
• Click "View" on the top toolbar menu
• Hover your cursor over "Freeze"
• Choose the number of columns or rows that you want to freeze. You can choose to freeze 1 or 2, or if you are freezing more than two columns / rows… you will have the option to freeze "Up to" the cell / row / column that you selected before opening the menu)

Click here to get your free Google Sheets cheat sheet

If you freeze a row, the frozen row will remain at the top as you scroll up and down.

If you freeze a column, the frozen column will remain on the left as you scroll left and right.

The two methods for freezing rows and columns in Google Sheets

First, let's go over the two different ways to freeze rows and columns in Google Sheets. We'll start with the click and drag method, and then we'll go over the "View" menu method for the rest of the examples in the lesson.

Click and drag method for freezing rows / columns in Google Sheets

You can use your mouse to freeze rows / columns with the click and drag method, without having to open any menus.

As is shown in the image below, in your Google spreadsheet you will see thick grey lines at the top left of the sheet (Above row 1 and to the left of column A). These thick grey lines / borders can be clicked and dragged downwards to freeze rows, or clicked and dragged to the right to freeze columns.

When you hover your cursor over these thick grey lines, your cursor will turn into a hand when it is in the correct position.

How to freeze rows with the click and drag method

To freeze rows with the click and drag method, find the thick grey horizontal line that is on the left of the sheet, above row 1. Hover your cursor over this thick grey line until the hand appears, click your mouse, hold the click, and then drag your cursor downwards until you have reached the row that you want to freeze, and then release your click. You will see a thick grey line / border across the entire row that is frozen.

How to freeze columns with the click and drag method

To freeze columns with the click and drag method, find the thick grey vertical line that is at the top of the sheet, to the left of column A. Hover your cursor over this thick grey line until the hand appears, click your mouse, hold the click, and then drag your cursor to the right until you have reached the column that you want to freeze, and then release your click. You will see a thick grey line / border across the entire column that is frozen.

"View" menu method for freezing rows / columns in Google Sheets

The traditional method for freezing rows and columns in Google Sheets, is by using the "View" menu. As shown below, you can open the "Freeze" menu by clicking "View" on the top toolbar. From this menu you can choose how many rows or columns that you want to freeze.

You will be able to choose between, "No rows", "1 rows", "2 rows", or "Up to row…"

When freezing more than two rows, you must first select the row or column that you want to freeze "Up to" before opening the freeze menu. I'll tell you more about this in an example later in the lesson.

To freeze rows or columns with the "View" menu method in Google Sheets, click "View" on the top toolbar, then click "Freeze", and then select how many rows / columns that you want to freeze.

Now let's go over some detailed examples on how to freeze rows, columns, both, and how to unfreeze.

Unfrozen example data

The image below shows data where there are no rows frozen and no columns frozen (before freezing). The example data is a list of potential applicants, their address, and notes on their qualifications. In the examples below we will use this data as an example to freeze rows, columns, both, and more.

How to freeze a row in Google Sheets

So let's say that we want to freeze one row, which in this case means freezing the headers, so that when we scroll down the headers stay frozen at the top. To do this we will choose "1 row" from the "Freeze" menu.

To freeze a row in Google Sheets, follow these steps:

1. Click "View" on the top toolbar
2. Hover your cursor over "Freeze"
3. Click "1 row"

Directly below is an image that shows the steps to take to freeze one row in Google Sheets.

The example image below shows the example data after freezing the first row. Notice that there is a thick grey bar / border between the first and second row, indicating that the first row is frozen. Now when we scroll down, the header row will remain frozen at the top.

How to freeze a column in Google Sheets

Now let's freeze a column instead of a row, so that when we scroll right, column A stays frozen on the left. To do this we will choose "1 column" from the "Freeze" menu.

To freeze a column in Google Sheets, follow these steps:

1. Click "View" on the top toolbar
2. Hover your cursor over "Freeze"
3. Click "1 column"

The image directly below shows the steps to take to freeze one column in Google Sheets.

The example image below shows the example data after freezing one column. Notice that there is a thick grey bar / border between the first and second column, indicating that the first column is frozen. Now when we scroll to the right, column A will remain frozen on the left.

How to freeze both rows and columns in Google Sheets

Now let's freeze both rows and columns, so that when we scroll down the top row is locked on top, and when we scroll right the first column is locked on the left. To do this we will first freeze a row, and then we will freeze a column (Or vice versa, but they must be frozen one at a time).

To freeze both rows and columns in Google Sheets, follow these steps:

1. Click "View" on the top toolbar
2. Hover your cursor over "Freeze"
3. Select the number of rows that you want to freeze
4. Repeat the process for columns: Click "View"
5. Hover your cursor over "Freeze"
6. Select the number of columns that you want to freeze

The example image below shows the example data after freezing a row and a column (Both row 1 and column A are frozen). Notice that there is a thick grey bar / border between the first and second row, as well as between the first and second column, indicating that the first row and the first column are both frozen. Now when we scroll down the first row will remain frozen at the top, and when we scroll right the first column will remain frozen on the left.

How to "Freeze panes" in Google Sheets

"Freeze panes" is an option / button that is available in Excel. To freeze panes in Google Sheets, follow the instructions above to freeze both rows and columns. Remember that selecting the exact cell where you want the rows / columns to be frozen "Up to", makes it faster to freeze both rows and columns because you only need to select the one cell, rather than selecting a row, and then selecting a column.

How to freeze two rows or two columns in Google Sheets

You can also freeze multiple rows or multiple columns in your Google spreadsheet. To do this we will choose "2 rows" or "2 columns" from the "Freeze" menu. In the next example I'll show you how to freeze more than 2 rows / columns.

To freeze two rows or two columns in Google Sheets, follow these steps:

1. Click "View" on the top toolbar
2. Hover your cursor over "Freeze"
3. Click "2 rows", or click "2 columns"

Directly below is an image that shows the steps to take to freeze two rows or two columns in Google Sheets.

The example image below shows the example data after freezing two rows. Notice that there is a thick grey bar / border between the second and third column, which indicates that the first two rows are frozen. Now when we scroll down, both row 1 and row 2 will remain frozen on the top of your spreadsheet.

This content was originally created by Corey Bustos / SpreadsheetClass.com

How to freeze more than two rows / columns in Google Sheets

If you want, you can freeze more than 2 rows / columns in a Google spreadsheet. The "Freeze" menu has an option to freeze "Up to" the selected row / column, and so this is how you can freeze 3 or more rows / columns. To do this we will choose "Up to row 3" or "Up to column C" from the "Freeze" menu.

When freezing more than 2 rows or columns in Google Sheets, you'll first need to select the cell that is within the row / column that you want to freeze, and then the "Freeze" menu will give you the option to freeze "Up to" the selected row / column. If you want, you can select the entire row / column that you want to freeze up to, but you can also simply select the exact cell where you want Google Sheets to freeze up to, and this will allow you to freeze both rows and columns "Up to" the selected cell.

Instead of being numbered, columns in a spreadsheet have letters, where the first column is labeled "A". So if you want to freeze three columns, this means that you will freeze "Up to" column C.

So if you want to freeze up to row 3, you can select row 3, then click "View"> "Freeze" > "Up to row 3"

If you want to freeze up to column C, you can select column C, then click "View"> "Freeze" > "Up to column C"

Or, you can select cell C3, which will give you the option to freeze "Up to row 3" or "Up to column C" in the "Freeze" menu.

To freeze more than 2 rows or more than 2 columns in Google Sheets, follow these steps:

1. Select the cell in your spreadsheet that is in the row / column that you want to freeze
2. Click "View" on the top toolbar
3. Hover your cursor over "Freeze"
4. Click "Up to row 3" / "Up to column C", (Or whichever row number / column letter that it says when the appropriate cell is selected)

The image directly below shows the steps to take to freeze more than two rows / columns in Google Sheets.

The example image below shows the example data after freezing three rows. Notice that there is a thick grey bar / border between the third and fourth column, which indicates that the first three rows are frozen. Now when we scroll down, rows 1 through 3 will remain frozen on the top of your spreadsheet.

by SpreadsheetClass.com

Now that you know how to freeze rows and columns, you'll want to know how to unfreeze rows or columns in Google Sheets. Unfreezing rows and columns can also be done through the "Freeze" menu. To unfreeze rows and columns, we will choose "No rows" or "No columns" from the "Freeze" menu.

To unfreeze rows and columns in Google Sheets, follow these steps:

1. Click "View" on the top toolbar
2. Hover your cursor over "Freeze"
3. Click "No rows", or click "No columns"

Directly below is an image that shows the steps to take to unfreeze rows and columns in Google Sheets.

The example image below shows the example data after unfreezing rows / columns. Notice that there is NOT a thick grey bar / border between the rows / columns (which indicates that there are no frozen rows, and no frozen columns).

Now you know how to freeze rows and columns in your Google spreadsheet (as well as how to unfreeze)! This will make your spreadsheets much easier to read and work with, so that you don't constantly have to scroll up or to the right to see the labels for your rows / columns.

Click here to get your free Google Sheets cheat sheet