Google Sheets: How to Freeze the Top Two Rows on Screen

To freeze the top two rows in Google Sheets, open the spreadsheet in a web browser and choose View > Freeze > 2 rows. Rows 1 and 2 will stay visible as you scroll down, so titles, column headings, or other reference information remain on screen.

How to freeze the top two rows

The menu command is the simplest method because it selects exactly the first two rows without requiring you to drag a boundary or select cells first. In the Google Sheets browser interface:

Open the spreadsheet and identify the information in rows 1 and 2 that you want to keep visible.
Click View in the menu bar.
Point to or open Freeze.
Choose 2 rows.

Scroll down the sheet to confirm the result. The two rows should remain at the top of the grid while the other rows move beneath them. You do not need to select rows 1 and 2 before using this menu option. If the Freeze menu offers an option such as Up to row 2 in your current interface, that also freezes rows 1 and 2, including every row above the selected boundary.

Google Sheets saves the freeze setting with the sheet. If you do not see a change right away, scroll vertically; the effect is easiest to notice once row 3 or a later row moves into view.

What freezing rows does

Freezing keeps selected rows in a fixed position on screen while you navigate through the rest of the worksheet. It does not lock those rows against editing, hide them, or make them repeat in every printed page automatically. A frozen row can still be changed by anyone with permission to edit the sheet.

This is useful when a worksheet has a heading or context that would otherwise disappear during scrolling. For example, a sales tracker might use row 1 for the report title and row 2 for headings such as Date, Region, Product, and Revenue. After freezing both rows, a person reviewing a record far down the sheet can still see what each column represents.

Freezing changes how the sheet is displayed, not the data itself. It does not change cell values, formulas, sorting, or the number of rows. It also does not mean that rows 1 and 2 are the only rows you can edit; it simply keeps them visible while you move around the grid.

When to freeze two rows instead of one

Choose two rows when both the first and second rows contain information that is useful during scrolling. A common arrangement is a report name in row 1 and field labels in row 2. Another is a category label in row 1 and the detailed column headings immediately below it. Keeping both visible makes it easier to interpret entries without repeatedly scrolling back to the top.

If row 1 is blank, decorative, or not needed once you reach the data, freezing two rows may take up more screen space than necessary. In that case, freeze only one row, or consider moving the useful headings into the first row before choosing a freeze setting. On a small laptop screen, each frozen row reduces the visible area available for scrolling content, so use the fewest rows that provide meaningful context.

For a sheet with several header rows, freeze through the last row needed for orientation. Google Sheets freezes a continuous block from the top; it cannot keep only row 1 and row 3 fixed while letting row 2 scroll. If the headings are in rows 1 through 4, freezing four rows keeps all four, but it also uses more screen space.

Freeze columns as well as rows

You can keep a row header and one or more columns visible at the same time. This can help with a wide sheet where the first column contains names or IDs and the top rows contain field headings. In the browser, use View > Freeze to choose a row setting and then a column setting. For example, select 2 rows and 1 column to keep rows 1 and 2 and column A visible while scrolling vertically or horizontally.

Freezing a column does not change which rows are frozen, and vice versa. Use the narrow gray freeze boundary in the grid as a visual guide: the horizontal boundary marks frozen rows, and the vertical boundary marks frozen columns. If a sheet is already frozen in one direction, you can adjust the other direction without necessarily removing the first setting.

Think about the labels readers need to retain. In a monthly budget, two heading rows may be useful, while the first column contains expense categories. In an inventory list, a single product-ID column may be more important than a second frozen row. Freezing too much can make a compact display feel cramped, so test the layout at the screen size people are likely to use.

Change or remove the freeze

To change the number of frozen rows, return to View > Freeze and choose a different row option. To remove the row freeze, choose No rows. If columns are frozen too, remove or adjust them separately through the column options in the same menu. Removing a freeze restores ordinary scrolling; it does not delete or move any cells.

You can also adjust the boundary directly in the grid. Look for the thicker gray line below the frozen rows, near the row numbers, and drag it to the desired position. Dragging can be convenient when you want to freeze through a particular row, but the menu is often easier to use when you want exactly two rows. If the boundary is difficult to find, use the Freeze menu instead.

Common problems and useful checks

The rows do not seem frozen: Scroll down far enough for row 3 to move. At the very top of the sheet, a freeze can be hard to notice because all rows are already in their starting positions.
The wrong number of rows stays visible: Reopen View > Freeze and select the intended setting. If you dragged the boundary, check whether it landed below row 2 or below a later row.
The freeze boundary is in an unexpected place: Another person may have changed the sheet layout, or an earlier setting may still be active. Use the menu to set the row and column options explicitly.
There is too little room to see the data: Reduce the number of frozen rows, especially on a short display. Keeping two rows fixed is helpful only if the remaining grid is still comfortable to use.
The rows are visible but cannot be edited: Freezing is not the cause. Check whether you have edit access and whether the cells or sheet are protected; those are separate controls.

If the menu is unavailable or the sheet is view-only, you may not have permission to change its layout. Ask the owner or an editor to update it, or make a copy if your access and the owner’s settings allow that. A freeze setting is also separate from a filter: filtering changes which records are shown, while freezing keeps selected rows or columns in place during scrolling.

Sharing, printing, and related distinctions

In a shared spreadsheet, a freeze is a sheet layout setting rather than a private reading aid like a personal filter view. A change to the freeze layout can therefore affect how the sheet appears to other people working with it. If collaborators rely on a particular layout, coordinate before changing it, especially in a shared operational tracker.

Freezing is primarily for navigating the on-screen grid. Do not assume that a row frozen for scrolling will automatically appear at the top of every printed page. Before printing, open the print settings and review the page preview; printed-page headers and repeated rows are handled through print options, not simply by freezing a row for screen use.

It is also different from protecting a range. Protection controls who can edit selected cells or a sheet, subject to permissions. Freezing controls what remains visible as you scroll. A sheet can have frozen rows without protected cells, protected cells without frozen rows, or both.

Google Sheets compared with Excel

The steps above are for Google Sheets in a web browser. Excel has a similar feature, but the menu path differs: in Excel for Microsoft 365 on Windows, select the row below the rows to keep visible and choose View > Freeze Panes > Freeze Panes. To freeze the top two rows, select row 3 first. Google Sheets instead provides a direct View > Freeze > 2 rows choice, so you do not need to select row 3.

In both programs, freezing is a view and navigation aid, not a way to prevent edits. If you switch between Excel and Sheets, check the freeze setting after importing or exporting a file, since the menus and available options are not identical.

Frequently Asked Questions

Can I freeze only the top two rows in Google Sheets?
Yes. In the browser, choose View > Freeze > 2 rows. This keeps rows 1 and 2 visible while the rest of the sheet scrolls.

Do I have to select row 2 before freezing it?
No. Use the menu’s 2 rows option directly. If you use a boundary-drag method instead, place the horizontal boundary below row 2 so both top rows stay fixed.

How do I unfreeze the top rows?
Choose View > Freeze > No rows. This removes the row freeze but does not delete, hide, or alter the contents of those rows.

Can I freeze the top two rows and the first column?
Yes. Set the row option to 2 rows and the column option to 1 column under View > Freeze. The rows and column can remain fixed together.

Does freezing protect the headings from edits?
No. Frozen headings stay visible during scrolling but remain editable if your permissions allow it. Use Google Sheets’ protection controls if you need to limit editing.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.