# How to freeze the top row in Google Sheets on Mac, in Chrome or Safari

> How to freeze the top row in Google Sheets on Mac: select row 1, then choose View > Freeze > 1 row. Works in Chrome or Safari.

URL: https://www.lazur.app/how-to/freeze-the-top-row-in-google-sheets
Updated: 2026-11-06

To freeze the top row in Google Sheets on a Mac, select row 1, then choose View > Freeze > 1 row. Google Sheets has no Mac app, so you do this in Chrome or Safari, and the steps work in either browser.

## Quick answer

- Google Sheets has no Mac app. You freeze the top row in Chrome or Safari.
- Click the row number 1, then choose View > Freeze > 1 row.
- To unfreeze, choose View > Freeze > No rows.
- If you cannot find the menu, press ⌥ / and type freeze.
- Freeze from the top down. Sheets freezes every row above the one you pick.

Applies to: Google Sheets in Chrome or Safari on macOS, web app as checked November 2026. Time: 2 min. Difficulty: Easy.

## What you need

- A Mac with Chrome or Safari installed
- A Google account signed in to Google Sheets
- Edit access to the spreadsheet
- The sheet open in the browser, since Sheets has no Mac app

## How to Freeze the top row in Google Sheets on a Mac in Google Sheets on a Mac

1. **Open the sheet in Chrome or Safari.** Open the spreadsheet in Chrome or Safari on your Mac. Google Sheets runs in the browser, so there is no Mac app to launch. Confirm that you have edit access before you start. Tip: If the file opens read only, ask the owner for edit access.
2. **Select row 1.** Click the number 1 on the left edge of the grid. The whole top row highlights. Sheets freezes the selected row and every row above it, so row 1 is the simplest case. Tip: Click the row number, not a cell. A cell click selects only that cell.
3. **Open the View menu.** (View > Freeze) Click View in the menu row under the file name. Hover over Freeze to open its submenu. This menu sits inside the page, not in the Mac menu bar.
4. **Choose 1 row.** (View > Freeze > 1 row) Click 1 row. Row 1 now stays on screen while the rest of the sheet scrolls. You should see a divider under row 1 that marks the boundary.
5. **Test the freeze.** Scroll down with the trackpad. Row 1 should stay in place while the data moves beneath it. If it moves, clear the freeze with No rows and try again.
6. **Freeze rows 1 to 3.** (View > Freeze > Up to row 3) Click the number 3 on the left to select row 3. Then choose View > Freeze > Up to row 3. Rows 1 to 3 stay on screen. Sheetgo calls this option Up to row X, where X is the row you selected.
7. **Freeze with the right-click menu.** (Right-click row number > Freeze) Right-click the number 1 on the left. Choose Freeze, then pick the row count you need. Google added Freeze to the right-click menu in October 2021.
8. **Find Freeze with Tool finder.** (Tool finder) Shortcut: ⌥ /. Press ⌥ /, type freeze, then choose the match with the arrow keys and press Return. Google's shortcut page says Tool finder was formerly called Search the menus.
9. **Unfreeze the top row.** (View > Freeze > No rows) Click View, then Freeze, then No rows. The row freeze clears. Any column freeze stays until you clear it with No columns.
10. **Keep Sheets in its own window (optional).** (Chrome three-dot menu > More Tools > Create Shortcut) In Chrome, open the three-dot menu, go to More Tools, choose Create Shortcut, and check Open as window. In Safari, choose File > Add to Dock instead.

## Why you freeze rows in the browser, not in a Mac app

Google does not publish a Google Sheets app for the Mac. The Google Sheets product page does not mention a Mac or desktop app either. So you open the spreadsheet in a browser, and the freeze controls live inside the Sheets page.

The menus sit under the file name, inside the page. They are not in the menu bar across the top of your screen. If you look up there for View, you will not find it. Look just below the file name instead.

You can make Sheets feel more like an app. In Chrome, open the three-dot menu, go to More Tools, choose Create Shortcut, and check Open as window. In Safari, choose File > Add to Dock. The Bricks guide describes both routes, and neither one installs a Google app.

![Person at a laptop learning how to freeze the top row in Google Sheets on Mac](https://lfobmih1tpj3sgpo.public.blob.vercel-storage.com/content-images/howto/freeze-the-top-row-in-google-sheets/how-to-freeze-the-top-row-in-1-fe4fa1.jpg)

## The Freeze submenu and what each option keeps visible

Google's help page says to select the row, click View, then Freeze, and choose how many rows to freeze. It does not list the submenu labels. It also does not say how many rows you may freeze. The table below uses the labels from Sheetgo's guide, so check them against your own menu.

| Freeze option | What stays on screen | Path to use |
| --- | --- | --- |
| 1 row | Row 1 only, while the rest scrolls | View > Freeze > 1 row |
| 2 rows | Rows 1 and 2 | View > Freeze > 2 rows |
| Up to row X | Every row from 1 down to the row you selected | Select row X, then View > Freeze > Up to row X |
| No rows | Nothing. Clears the row freeze | View > Freeze > No rows |

_Freeze submenu labels as listed by Sheetgo. Confirm them in your own menu._

Use 1 row when you have one header line. Use 2 rows when a title sits above the header. Use Up to row X for anything taller, because it follows whichever row you selected.

## How to freeze two rows, three rows, or more

Many people believe Sheets stops at two frozen rows. FormulasHQ calls that a misconception. To freeze rows 1 to 3, click the number 3 on the left, then choose View > Freeze > Up to row 3. Google's help page sets no numeric cap on freezing, so the number of rows is up to you.

A frozen block always starts at row 1. Sheetgo says a frozen row must sit right next to the first row. That is why you cannot freeze row 15 alone. Freezing row 15 freezes rows 1 to 15, and that is what you should expect.

## A worked example: a title, a header, then data

Say your sheet has a title in row 1, column names in row 2, and data from row 3 down. Click the number 2 on the left. Then choose View > Freeze > Up to row 2. The title and the column names stay visible while you scroll through the data.

If you froze the title only, the column names would scroll away. That is the most common reason a sheet seems to ignore your freeze. Count the rows you need, then select the last one.

## Freeze the top row with the right-click menu

Right-click the number 1 on the left edge of the grid. Choose Freeze from the menu, then pick the row count you need. Google added this option to the right-click menu in October 2021, when it shortened the Sheets menus.

The right-click route is handy when the mouse is already on a row. It saves a trip to the top of the page. The result is the same as the View menu.

## Find Freeze fast with Option + /

Google's keyboard shortcuts page says that on a Mac, Tool finder opens with Option + /. The page notes that Tool finder was formerly called Search the menus. Press ⌥ /, type freeze, and pick the match.

Google's shortcut list has no direct key for freezing. So Tool finder is the closest thing to a shortcut for this job. It helps when you cannot remember where a command lives.

## Drag the freeze line if you prefer the mouse

Ben Collins describes a drag method in his guide. You hover near the edge of the header area until a hand icon appears. Then you click, hold, and drag the thick line down to the row you want. Release it there.

The drag works, but it is hard to repeat exactly. The menu gives you the same row every time. Use the drag for a quick change, and use the menu when the row must be exact.

- **20 million** Cells allowed in one spreadsheet in Google Sheets ([source](https://support.google.com/drive/answer/37603?hl=en))
- **100MB** File size limit for one spreadsheet in Google Sheets ([source](https://support.google.com/drive/answer/37603?hl=en))

## How to unfreeze the top row without breaking the sheet

Click View, then Freeze, then No rows. That clears the row freeze and leaves your data untouched. Freezing changes how the sheet scrolls, not the values in your cells. Your formulas stay where they are.

Column freezes work separately. If you froze a column too, clear it with No columns in the same submenu. Sheetgo lists No rows and No columns as separate options, so clear each one you set.

## Freeze the first column as well as the top row

Wide sheets often need a frozen first column too. Sheetgo lists 1 column, 2 columns, Up to column C, and No columns in the Freeze submenu. Pick the column that holds your names or IDs.

With the header row and the first column frozen, the data scrolls in the middle while your labels stay put. That layout makes a wide table much easier to read on a laptop screen.

## Mistakes that make a frozen row look broken

- Looking for View in the Mac menu bar. The Sheets menus sit inside the page, under the file name.
- Selecting row 3 and expecting only row 3 to freeze. Sheets freezes rows 1 to 3.
- Choosing 2 rows when you need 3. Use Up to row 3 instead.
- Trying to change the layout with view only access. You need edit access to set a freeze.

Most of these mistakes come from clicking the first label you see. Read the label before you click. The freeze then lands on the row you meant.

![Man at a MacBook reviewing a spreadsheet with a frozen header row](https://lfobmih1tpj3sgpo.public.blob.vercel-storage.com/content-images/howto/freeze-the-top-row-in-google-sheets/how-to-freeze-the-top-row-in-2-ea3deb.jpg)

## Limits to check before you build a long sheet

Google's limits page says a spreadsheet in Google Sheets can hold up to 20 million cells or 100MB. If you convert an Excel file, any cell with more than 50,000 characters is removed. Check the size of your file before you build on it.

Frozen headers help you read a large sheet, but they do not shrink it. A freeze changes the view only. It does not change how much data the file holds.

## Version notes and what to do after the top row stays put

Google's help pages carry no version numbers or publication dates. The steps here describe the web app as checked on November 7, 2026. If a label moved, follow the same path and look for the nearest match under View.

Once the header stays on screen, scroll to the bottom and back. Check that each column still lines up with its heading. If you analyze data all day, the [data analyst guide for Google Sheets on Mac](https://www.lazur.app/for/data-analysts/google-sheets) covers more of the setup.

## Shortcuts

- Tool finder (formerly Search the menus): ⌥ /

## If it does not work

- **The Freeze option is not where this guide says** Google's help page lists only the basic path, not every submenu label. Press ⌥ / and type freeze to find the command in your version.
- **Only two rows freeze, and I need three** Select row 3 and choose View > Freeze > Up to row 3. FormulasHQ calls the two-row limit a misconception.
- **The freeze landed on the wrong row** Clear it with View > Freeze > No rows. Then select the row you want as the last frozen row and choose Up to row X.
- **The Freeze menu does nothing for me** Check that you can edit the file. Freezing changes the sheet layout, so view only access will not let you set it.

## With Lazur

Lazur is a voice assistant for the Mac that lives in the notch. Hold ⌥ ⌘ and ask; it sees your screen, answers out loud, points at buttons and walks you through apps. Hold fn to dictate. Free for 3 days, then $18/month: https://www.lazur.app/download

- “Where is the Freeze option?”: Lazur circles View, waits for your click, then points at Freeze and the row count. You make each click yourself. (Walks you through it)

## FAQ

### Is there a Google Sheets app for Mac?

Google does not publish a Google Sheets app for the Mac. The Google Sheets product page does not mention a Mac or desktop app. You work in Sheets in Chrome or Safari, and you can add a window shortcut to your Dock.

### Can I freeze the top row on a Mac without using the View menu?

Yes. Right-click the number 1 on the left, then choose Freeze and 1 row. Google added Freeze to the right-click menu in October 2021. You can also press ⌥ / and type freeze to find the command.

### Why can't I freeze row 5 by itself?

A frozen block always starts at row 1. Sheetgo says a frozen row must sit right next to the first row. To freeze row 5, select row 5 and choose Up to row 5, which freezes rows 1 to 5.

### Why do some guides say you can only freeze two rows?

FormulasHQ calls the two-row limit a misconception. You can freeze more by selecting a lower row and choosing Up to row X. Google's help page does not state a numeric cap on freezing.

### How do I unfreeze the top row?

Choose View > Freeze > No rows. This clears the row freeze. Any column freeze stays until you clear it with No columns in the same submenu.

### Does freezing a row change my data or formulas?

No. Freezing changes how the sheet scrolls on screen. The values in your cells and your formulas stay where they are.

### What is the largest spreadsheet Google Sheets allows?

Google's limits page says a spreadsheet can have up to 20 million cells or 100MB. When you convert an Excel file, any cell with more than 50,000 characters is removed.

## Sources

1. [Freeze, group, hide, or merge rows & columns (Computer): Google Docs Editors Help](https://support.google.com/docs/answer/9060449?hl=en&co=GENIE.Platform%3DDesktop), Google, checked 2026-11-07
2. [Keyboard shortcuts for Google Sheets: Google Docs Editors Help](https://support.google.com/docs/answer/181110?hl=en), Google, checked 2026-11-07
3. [Enhanced menus in Google Sheets improves findability of key features](https://workspaceupdates.googleblog.com/2021/10/enhanced-menus-in-google-sheets.html), Google Workspace Updates, checked 2026-11-07
4. [Google Drive Help: Google Sheets limits](https://support.google.com/drive/answer/37603?hl=en), Google, checked 2026-11-07
5. [How to freeze rows and columns in Google Sheets](https://www.sheetgo.com/blog/google-sheets-features/freeze-rows-columns-google-sheets/), Sheetgo, checked 2026-11-07
6. [How To Freeze A Row In Google Sheets, Including A Secret Shortcut](https://www.benlcollins.com/spreadsheets/google-sheets-freeze-row/), Ben Collins, checked 2026-11-07
7. [How to Add Google Sheets to Desktop on Mac](https://www.thebricks.com/resources/guide-how-to-add-google-sheets-to-desktop-mac), The Bricks, checked 2026-11-07
8. [Why can't I freeze more than 2 rows in Google Sheets?](https://formulashq.com/why-cant-i-freeze-more-than-2-rows-in-google-sheets), FormulasHQ, checked 2026-11-07
9. [Google Sheets - Google Workspace](https://workspace.google.com/products/sheets/), Google, checked 2026-11-07