Google Sheets Freeze Rows Shortcut and Menu Steps

Google Sheets has no dedicated keyboard shortcut that immediately freezes rows. In a web browser, use View > Freeze > 1 row to keep the top row visible; to freeze more rows, choose the option that reaches the row you need.

Is there a keyboard shortcut to freeze rows?

Not a direct one. Google Sheets does not assign a standard key combination specifically to freeze the first row, freeze two rows, or freeze through a selected row. That means shortcuts you may see mentioned for other spreadsheet apps should not be assumed to work in Sheets.

You can still reach commands with the keyboard. In Google Sheets on Windows, press Alt+/ to open the menu search, type freeze, and select the relevant freeze command if it appears in the results. On a Mac, the menu-search shortcut is Option+/. This is a way to search for and invoke a menu command, not a dedicated freeze-rows shortcut; the exact command to choose depends on how many rows you want frozen.

If you want a dependable route that is easy to explain to someone else, use the menu path: View > Freeze, then select the row option. The menu method is also useful when you need to check which freeze setting is currently applied.

Freeze the top row from the menu

To keep column headings visible while you scroll down a sheet, freeze the first row. In a desktop web browser, follow these steps:

Open the spreadsheet and select any cell; selecting a particular cell is not required to freeze the first row.
Click View in the menu bar.
Point to or open Freeze.
Choose 1 row.
Scroll down to confirm that row 1 remains at the top of the grid.

The setting applies to the current sheet tab, not automatically to every tab in the spreadsheet. If a workbook has several tabs with headers, repeat the steps on each tab where you want the header to stay visible. The frozen row remains visible as you scroll through that sheet, which makes it easier to identify what each column contains.

Freeze two or more rows

Freezing more than one row is helpful when a sheet has a title above its column headings, or when a report uses two header rows. In View > Freeze, choose the option that freezes through the last row you want to keep visible. For example, to keep rows 1 through 3 on screen, choose the option for freezing up to row 3, if it is shown in the menu.

Frozen rows must form one continuous block starting at the top of the sheet. You cannot freeze row 1 and row 4 while allowing rows 2 and 3 to scroll away. If the headings you need are separated by blank rows or notes, consider reorganizing the sheet so the useful header information is together at the top.

Before freezing several rows, check how much space they occupy. A large header area can leave little room for the data when the spreadsheet is viewed on a laptop or in a small browser window. Freeze only the rows readers need to understand the columns, and leave explanatory notes or long titles unfrozen when practical.

Choose the right rows for your sheet

The best setting depends on how people read the data. A simple table usually needs only its column-label row. A monthly report might need a title and a column-label row, while a schedule could have two rows of dates and category names. Try to freeze the smallest block that keeps the information understandable.

One header row: Freeze 1 row for labels such as Date, Customer, and Amount.
Title plus headings: Freeze through row 2 if row 1 is a report title and row 2 contains the actual column names.
Multi-level headings: Freeze through the final heading row when labels span two or more rows.
No permanent header: Leave rows unfrozen if the sheet is a short list that does not need labels while scrolling.

For example, imagine a sales sheet with a report title in row 1, month and region labels in row 2, and records beginning in row 3. Freezing through row 2 keeps both the context and the field names visible as someone reviews later records. If row 1 is a long title that takes up screen space, freezing just row 2 is not possible by itself: freeze settings start at the top, so the choice is to freeze rows 1 and 2 together or rearrange the sheet.

Freeze rows and columns together

Google Sheets can freeze rows and columns independently. This is useful when a sheet has both column headings at the top and identifying values, such as employee names or product codes, in the first column. Use View > Freeze to choose a row setting and a column setting; the two choices can be combined.

For instance, freeze row 1 and column A in a wide tracking sheet. When you scroll down, the headings in row 1 remain visible; when you scroll sideways, the labels in column A remain visible. This can make it easier to match a distant value to its record. It does not freeze an arbitrary column in the middle of the sheet while leaving the columns before it free; the frozen columns are a continuous block starting at column A.

Keep the total frozen area modest. If several rows and columns are pinned, they take up space that would otherwise show data, especially on a small display. A reader may have to scroll more within the remaining grid, so test the arrangement at a realistic window size.

What freezing changes—and what it does not

Freezing is a viewing aid. It keeps selected top rows, and optionally left-side columns, in place while the user scrolls through the rest of the sheet. It does not lock cells against editing, protect formulas, prevent changes to the data, or make a header repeat when the sheet is printed. Those are separate tasks or settings.

Frozen rows also remain part of the sheet’s data. Freezing row 1 does not automatically tell Google Sheets that it is a header row for sorting or filtering. When setting up a filter or sorting a range, make sure the selected range and any header-row option match the layout. A freeze line can help people see headings, but it is not a substitute for correctly configuring the data operation.

The setting belongs to the sheet tab, so switching to another tab may show different frozen rows. Sharing the spreadsheet does not turn freezing into an editing restriction: viewers see the layout, while people with edit access can still change the sheet and its settings according to their permissions.

Common problems and quick fixes

The header scrolls away: Confirm that the correct sheet tab is active, then check View > Freeze. Choose 1 row or the appropriate larger range.
Too much of the sheet is pinned: Open View > Freeze and select No rows, then apply the desired setting again.
The menu offers a different row count: Google Sheets can show an option based on the current selection or sheet position. Choose the entry that freezes through the intended final row, rather than relying on a remembered menu position.
The freeze line is hard to spot: Look for the thicker gray divider between the frozen area and the scrolling grid. A small browser window or zoom setting can make the boundary less obvious.
The setting did not carry to another tab: Freeze rows separately on each sheet tab that needs them.

If the grid seems to scroll strangely, verify that the frozen area is not larger than intended and that you are scrolling inside the sheet rather than the surrounding browser page. You can also clear the freeze setting and apply it again to establish a simple baseline.

Change or remove a freeze setting

To change the frozen area, open View > Freeze and select a different row or column option. For example, if row 1 is frozen but you now need both rows 1 and 2 to remain visible, choose the option that freezes through row 2. If you no longer want any rows pinned, choose No rows. Use the corresponding column option to remove or change frozen columns.

You may also be able to adjust a freeze by dragging the divider that marks the boundary of the frozen area. Dragging can be convenient for a small adjustment, but the menu gives you a clearer choice of the row or column range. If you are unsure what the drag will do, use the menu instead and check the result by scrolling.

These actions change the view arrangement, not the cell contents. They do not delete rows, move data, or change formulas. That distinction is useful when a spreadsheet looks different after a colleague changes its freeze setting: the data may be exactly the same even though the scrolling behavior has changed.

Google Sheets versus Excel

This guidance is for Google Sheets in a web browser. Excel has its own Freeze Panes controls and keyboard behavior, so a shortcut or menu instruction for Excel should not be treated as a Google Sheets instruction. In Sheets, the dependable menu route is View > Freeze; use the option that matches the rows or columns you want to keep visible.

Google Sheets in a mobile app also has a different interface from the browser version, and a physical keyboard shortcut may not be available or convenient on a phone or tablet. If you are following instructions on a mobile device, look for the app’s row or column freeze controls rather than expecting the desktop browser menu to appear in the same place.

Frequently Asked Questions

What is the shortcut to freeze the top row in Google Sheets?
There is no dedicated direct shortcut. In a browser, choose View > Freeze > 1 row. You can also use the menu-search shortcut, Alt+/ on Windows or Option+/ on Mac, to look for the freeze command.

How do I freeze the first two rows?
Open View > Freeze and choose the option that freezes through row 2. Both row 1 and row 2 will stay visible as you scroll down.

Can I freeze a row that is not at the top?
You cannot freeze a single isolated row while rows above it scroll away. Google Sheets freezes a continuous block from the top, so choosing a row farther down keeps the rows above it frozen too.

How do I unfreeze rows in Google Sheets?
Go to View > Freeze and select No rows. If columns are frozen too, change the column setting separately.

Does freezing a row protect it from edits?
No. Freezing only keeps the row visible during scrolling. To restrict editing, use the sheet’s protection and sharing controls; a frozen row is not automatically protected.

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.