Google Sheets Freeze Rows on Mac: Quick Steps & Tips

To freeze rows in Google Sheets on a Mac, open the spreadsheet in a web browser, choose View > Freeze, then select 1 row, 2 rows, or Up to current row. The frozen rows stay visible as you scroll down, so column headings or other key information remain in view.

How freezing rows works in Google Sheets

Freezing keeps selected rows at the top of the sheet while the rest of the grid scrolls. It changes how the sheet is displayed, not the underlying data: it does not lock cells, protect them from editing, or move any rows. Anyone with access to the spreadsheet can still edit the frozen cells if their permissions allow it.

This is particularly useful when a table is longer than the screen. For example, if row 1 contains headings such as Date, Customer, and Amount, freezing that row lets you scroll through hundreds of records without losing track of what each column means. You can also keep several introductory rows visible, such as a report title, a date range, and the table headings.

Google Sheets is used in a browser on a Mac, so the menus are the same whether you open the sheet in Safari or Chrome. The menu names may look different if your Google account uses another language, but the freeze controls are still under the View menu.

Freeze the first row or first two rows

For a simple header, the quickest method is to choose one of the built-in options:

Open the spreadsheet at sheets.google.com, or open it from Google Drive.
Click View in the menu bar at the top of the sheet.
Point to Freeze to open the available choices.
Choose 1 row or 2 rows, depending on how many rows you want to keep visible.

After choosing an option, look for a thicker gray divider beneath the frozen area. Scroll down in the sheet to confirm the selected rows remain at the top. If you choose 1 row, only row 1 is fixed. If you choose 2 rows, both rows 1 and 2 stay visible; the setting does not mean that Sheets will freeze whichever two rows happen to be selected.

These preset choices work well when the content to keep visible starts at the top of the sheet. If the information you need is lower down, use the option for freezing through the current row instead.

Freeze through a particular row

To keep more than two rows visible, click a cell in the last row you want to freeze. Then choose View > Freeze > Up to current row. For example, click a cell in row 4 and choose that command to keep rows 1 through 4 visible. Sheets freezes the rows from the top through the active cell’s row; it does not freeze only row 4.

This is useful for a sheet with several lines of context above its data. Imagine a monthly inventory sheet where row 1 has the report title, row 2 has the month, row 3 has a note about units, and row 4 contains the column labels. Freezing through row 4 keeps all of those details visible as you inspect the inventory below.

Be deliberate about how many rows you include. A large frozen block takes up more screen space and leaves less room to view the scrolling data, especially on a smaller MacBook display. If the title and headings are all you need, freezing just those rows is usually easier to work with than freezing a long block of notes.

Use the divider to adjust frozen rows

You can also adjust a freeze by dragging its divider. After freezing rows, find the thick gray line below the frozen section and drag it up or down to change how many top rows stay in place. The divider is separate from the ordinary gridlines, which are much thinner.

Dragging can be convenient when you want to change the freeze quickly, but the menu is more precise when you are unsure which row number is currently frozen. If you do not see a divider, open View > Freeze and check the current setting, or apply the desired setting from the menu. The precise appearance of the divider can vary with the browser window size and the sheet’s layout.

Freeze rows and columns together

Rows and columns can be frozen at the same time. This is helpful for a wide table where the top row contains field names and the first column contains names, product codes, or dates. Freeze the top row using View > Freeze > 1 row, then use View > Freeze to choose a column option, such as 1 column. The row stays at the top while the column stays at the left as you scroll in the corresponding directions.

For more than one column, select a cell in the last column you want to keep fixed and use the menu option to freeze through the current column. For instance, if columns A and B contain a product ID and product name, freezing through column B can keep both identifiers visible while you scroll horizontally to later columns.

Freezing rows and columns is different from splitting a window into separate views. A freeze keeps the chosen top rows or left columns attached to the edge of the same sheet. It does not create an independently scrolling pane or make a duplicate copy of the data.

Unfreeze rows when you no longer need them

To remove a row freeze, choose View > Freeze > No rows. The sheet then scrolls normally from the top. If columns are frozen too, remove their freeze separately by choosing View > Freeze > No columns. Removing a freeze changes only the view; it does not delete rows, clear their contents, or change their order.

If you are sharing a sheet and another person says the top rows are stuck, check the Freeze menu before assuming that the spreadsheet is damaged. The setting may have been applied intentionally by someone organizing the sheet. You can unfreeze it for your own work, but remember that view changes may be visible to collaborators depending on the spreadsheet and its current use. If maintaining a shared layout matters, agree on the change with the other editors.

Common problems and quick fixes

The wrong number of rows stays visible: Open View > Freeze and select the intended setting. To freeze through a particular row, make sure the active cell is in that row before choosing Up to current row.
The freeze seems to have disappeared: Confirm you are scrolling within the sheet, not switching to another tab at the bottom. Check the Freeze menu and look for the divider under the frozen rows.
Too much of the screen is taken up: Reduce the frozen area to one or two rows, or drag the divider closer to the top. A tall header block can make it difficult to see the rows you are reviewing.
You cannot change the setting: Check whether you have permission to edit the spreadsheet. A viewer may be able to inspect the sheet but not change its structure or view settings in the same way as an editor.
The menu is hard to find: Make sure you are in the spreadsheet itself, rather than viewing a file preview in Drive. Open the file in Google Sheets, then use the menu at the top of the grid.

Also check whether the sheet is simply scrolled down. A frozen header remains visible, but the row numbers in the main grid will change as you move through the data. That is normal and does not indicate that rows have been duplicated or rearranged.

Frozen rows versus printed headers

A common misconception is that freezing a row makes it repeat on every printed page. It does not. Freezing controls what stays visible while someone scrolls through the sheet on screen. Printing uses separate print settings, so a frozen header should not be treated as a guarantee that the header will appear on each page of a printout or PDF.

If you are preparing a printout, use File > Print to review the print layout and its available formatting options. Check the preview before printing, particularly if the table spans multiple pages. A sheet that is easy to navigate on screen may need different print formatting to make the column labels clear on paper.

Freezing is also not the same as protecting a row. If your goal is to stop collaborators from changing headings, use Google Sheets’ protection controls rather than relying on a freeze. A frozen row remains editable when the user has editing access.

Google Sheets on Mac compared with Excel

These instructions apply to Google Sheets in a browser on macOS. Google Sheets uses its own menus, so follow View > Freeze rather than searching for an Excel ribbon command. In Excel for Mac or Windows, the feature is called Freeze Panes and is found on the View tab; the interface and available commands differ from Google Sheets.

There is no need to install a separate Mac version of Google Sheets to use the browser steps. If you open the spreadsheet in a browser, the important control is the Sheets menu, not a Mac system setting. Browser keyboard shortcuts are not required for freezing, which can help avoid confusion with shortcuts that differ between applications or keyboard layouts.

Frequently Asked Questions

How do I freeze the top row in Google Sheets on a Mac?
Open the sheet in a browser and choose View > Freeze > 1 row. Row 1 stays visible while you scroll down.

How do I freeze more than two rows?
Click a cell in the last row you want to keep visible, then select View > Freeze > Up to current row. Choosing this while your active cell is in row 5 freezes rows 1 through 5.

Can I freeze the first row and first column at the same time?
Yes. Set the row freeze and column freeze separately from View > Freeze. The row remains at the top and the column remains at the left as you scroll.

How do I unfreeze rows in Google Sheets?
Choose View > Freeze > No rows. If columns are also frozen, choose No columns separately to remove that freeze too.

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 features and set the appropriate permissions.

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.