# How to merge cells in Google Sheets on Mac: step by step in Chrome

> How to merge cells in Google Sheets on Mac: open Format > Merge cells, pick a merge type, and unmerge safely. Covers data loss and sorting errors.

URL: https://www.lazur.app/how-to/merge-cells-in-google-sheets
Updated: 2026-11-06

To merge cells in Google Sheets on a Mac, select the cells, then click Format > Merge cells and choose a merge type. Only the top-left value survives a merge, so copy any other values first, and unmerging will not restore them.

## Quick answer

- Select the cells, then go to Format > Merge cells and choose a merge type.
- On a Mac, ⌃⌥O opens the Format menu. Google's shortcut page lists no merge shortcut.
- Only the top-left value survives a merge. Unmerging does not bring the others back.
- To split cells again, use Format > Merge cells > Unmerge.
- Before sorting, unmerge, fill the blanks, then sort.

Applies to: Google Sheets in Chrome on macOS, with no separate Mac app. Time: 5 min. Difficulty: Easy.

## What you need

- Google Chrome on macOS, with the sheet open
- Edit access to the spreadsheet file
- Cells selected as one block of adjacent cells

## How to Merge cells in Google Sheets on a Mac in Google Sheets on a Mac

1. **Open the sheet in Chrome.** Open the Google Sheets file in a Chrome window on your Mac. Sheets is a browser app, so there is no separate Mac program to launch. The menu bar sits inside the page, below the file name.
2. **Select the cells to merge.** Shortcut: ⇧ + click. Click the first cell, then drag to the last cell. You can also click the first cell and hold Shift while you click the last one. Merge works on one block of adjacent cells, so select only the cells you intend to combine. Tip: Select at least two adjacent cells, or the merge options will not apply.
3. **Check the top-left cell.** The value in the top-left cell is the only one that survives a merge. Read it, then move or copy any other values you need. Check each formula in the block too, since merging can change or break them.
4. **Open the Format menu.** (Format) Shortcut: ⌃⌥O. Press Ctrl + Option + O to open the Format menu, or click Format in the menu bar. Google writes this shortcut as Ctrl + Option + O on Mac. The shortcut only opens the menu, so you still choose Merge cells next. Tip: If the shortcut does nothing, click Format in the sheet's menu bar instead.
5. **Open Merge cells.** (Format > Merge cells) Hover over Merge cells to open its options. The submenu shows the available merge types. Choose the one that matches the shape of your selection. Tip: Merge cells needs more than one selected cell, so check your selection first.
6. **Pick a merge type.** (Format > Merge cells > Merge all) Shortcut: Enter. Click Merge all to combine the whole selection into one cell. Unito says that pressing Enter after the menu opens also selects Merge all. Google's pages do not confirm that shortcut, so test it before you rely on it. Tip: For a single row, Merge horizontally gives the same result as Merge all.
7. **Read and confirm the warning.** If more than one cell holds data, Sheets shows a pop-up warning, according to Unito. Read it carefully. If the values in the other cells are safe to drop, confirm the merge. If you are not sure, cancel and copy those values out first. Tip: Cancelling costs nothing, so use it when the data matters.
8. **Check the merged result.** Shortcut: ⌘Z. The merged cell now shows the top-left value across the whole block. Click it and read the formula bar. Confirm that nothing you need is gone before you move on to other edits. Tip: If the result is wrong, press ⌘Z to undo the merge, then check the file's revision history.

Google Sheets has no native Mac app. Bricks, a guide to using Sheets on Mac, describes it as a browser tool. The steps below use Google Chrome on macOS. Sheets draws its own menu bar inside the page, just under the file name. Format lives in that bar, not in the menu bar at the top of your screen.

## What merging does to your data

Merging joins a block of cells into one cell. Google keeps only the value in the top-left cell and drops the rest. Unito, a third-party guide, says Sheets shows a pop-up warning when several cells hold data. Read that warning as your last chance to copy values out. Unmerging does not bring the dropped values back.

Here is a worked example. Say A1 holds a customer name, while B1 and C1 hold a date and an amount. Merging A1 through C1 keeps the name and nothing else. The date and the amount are gone. Copy them to another row before you merge, and nothing is lost.

## Before you merge: a short checklist

1. Copy any values from the cells that the merge will cover.
2. Check each cell in the block for formulas, and note which ones point into the block.
3. Confirm that you want a merged cell, not text that only looks centered.
4. Make a copy of the file with File > Make a copy if the data matters.
5. Check whether a sort or filter range includes these cells.

## Choose the right merge type

Unito lists two options in the Format > Merge cells dropdown, Merge all and Merge horizontally. It says Merge vertically sits in the shortcut section. Google's merge help page says you choose a merge type, but it does not name the options. Treat the labels as coming from a third-party guide, and check your own menu.

- Merge all joins every cell in the selection into one cell.
- Merge horizontally joins the cells across each row, so each row becomes one cell.
- Merge vertically joins the cells down each column, so each column becomes one cell.

A title that spans A1 through F1 is a single row. Merge all and Merge horizontally give the same result there. A block of A1 through F3 behaves differently. Merge all gives one cell, while Merge horizontally gives three cells, one for each row.

![Person on a Mac learning how to merge cells in Google Sheets in a browser window](https://lfobmih1tpj3sgpo.public.blob.vercel-storage.com/content-images/howto/merge-cells-in-google-sheets/how-to-merge-cells-in-google-sheets-1-bf910a.jpg)

## Keyboard shortcuts for merging on a Mac

Google's keyboard shortcut page lists ⌃⌥O for the Format menu on Mac. Google writes it as Ctrl + Option + O. The same page lists no shortcut for merging cells. Unito says that pressing Enter then selects Merge all. Google's pages do not confirm that, so test it on your screen first.

For the full list of Sheets shortcuts on Mac, read [how to show keyboard shortcuts in Google Sheets on Mac](https://www.lazur.app/how-to/show-keyboard-shortcuts-in-google-sheets). When a key does not respond, check the official list before you assume the shortcut changed.

## How to unmerge cells in Google Sheets on Mac

Click the merged cell so it is selected. Then go to Format > Merge cells > Unmerge. Unito also describes the merge icon in the toolbar, followed by Unmerge. Use the menu path if the icon is hard to find. Unmerging returns the cell to the grid, but the dropped values stay gone.

## Merged cells break sorting and filtering

Sorting a column that contains merged cells makes Google Sheets show error messages, according to Unito. Filtering a range with merged cells can cause errors too. The Bricks guide explains the cause. A merge keeps only the top-left value, so the other cells look empty to the sort.

The usual fix has three parts. Unmerge the cells. Fill each blank with the value it should hold. Then sort. Filling the blanks means copying the right value into every cell that a merge once covered. After the sort, you can merge again for display, ideally on a copy of the file.

For the sort itself, see [how to sort data by column in Google Sheets on Mac](https://www.lazur.app/how-to/sort-data-by-column-in-google-sheets).

| Problem | Likely cause | What to do |
| --- | --- | --- |
| Sort shows error messages | Merged cells hide values from the sort | Unmerge, fill the blanks, then sort |
| Values disappeared | A merge keeps only the top-left value | Copy values out before you merge |
| Formula results changed | Merging cells that hold formulas can cause errors or change values | Check each formula after the merge |
| Lost values will not return | Unmerging does not bring dropped values back | Use your copy or the file's revision history |

_Common merge problems and fixes, from the Unito and Bricks guides._

## Merging cells that hold formulas

Formulas add a second risk. Unito says merging cells that hold formulas can create errors or change values. Before you merge, click each cell in the block and read its formula. If a formula points at a cell you plan to merge, move it first.

After the merge, click the merged cell and read the formula again. Compare the result with what you expected. If the value changed, press ⌘Z to undo the merge straight away.

## Mistakes people make with merged cells

- Merging a whole column just to center a title. Sorting that column later causes errors.
- Merging without reading the top-left cell first. That value is the one that stays.
- Assuming unmerge brings values back. It does not.
- Merging cells that a filter or formula depends on, then wondering why the results look empty.
- Merging in a shared file without telling the other editors. Their formulas and sorts may break.

## Working with Sheets offline on a Mac

Google's offline help says you can edit Sheets without a connection. Offline editing requires Google Chrome or Microsoft Edge. It does not work in private browsing, and you need the Google Docs Offline extension plus a setting at drive.google.com/drive/settings. The page does not mention Safari or Firefox.

Check the merged result after you reconnect, and before you share the file. That habit catches formulas that changed while you worked.

## File size limits for large sheets

Google's Drive Help page says a Sheets spreadsheet can have up to 20 million cells or 100MB. Merging rarely pushes a file near that limit on its own. If your file is close to the cap, split the data across tabs before you format it.

## What to do instead of merging

Often you only want a heading to look centered. Type the heading in the first cell, leave the other cells empty, and set the alignment with the toolbar buttons. The text stays in one cell, so the grid stays intact for sorting and filtering.

![Man working on a MacBook at an office desk, a common setup for spreadsheet work](https://lfobmih1tpj3sgpo.public.blob.vercel-storage.com/content-images/howto/merge-cells-in-google-sheets/how-to-merge-cells-in-google-sheets-2-7b24a3.jpg)

If one label should cover several columns, put it in a row above the headers. Keep the header row itself unmerged. That gives you a clean grid under the label.

## Next steps after your merge

Once the merge looks right, check the sort, filter and formula ranges around it. Those are the places where merged cells cause trouble. If the header row needs to stay visible while you scroll, read [how to freeze the top row in Google Sheets on Mac](https://www.lazur.app/how-to/freeze-the-top-row-in-google-sheets).

## Shortcuts

- Open the Format menu in Google Sheets on Mac: ⌃⌥O
- Choose Merge all once the menu is open, per Unito: Enter
- Undo the last change, including a merge: ⌘Z
- Extend a selection to adjacent cells before merging: ⇧ + arrow keys

## If it does not work

- **Merge cells does nothing or stays unavailable** Select at least two adjacent cells before you open Format > Merge cells. Click the first cell, then Shift-click the last one.
- **Sorting shows error messages after a merge** Unmerge the cells, fill each blank with the value it should hold, then sort. Bricks describes this fix for merged cells.
- **Values disappeared after I merged** Only the top-left value is kept. Unmerging does not restore the rest, so use your copy or the file's revision history.
- **Enter does not choose Merge all** Google's official pages do not list that shortcut. Click Merge all with the mouse, or check the menu on your screen.
- **The menu looks different from these steps** I found no source for a 2026 menu change, but Google can rename items. Follow the closest match in the Format menu.

## 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 Merge cells option in this sheet?”: Lazur points at the Format menu, then at Merge cells, and waits for each click. It does not click for you. (Walks you through it)

## FAQ

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

No. Google Sheets has no native Mac app, so you use it in a browser. Bricks describes Sheets on Mac as a browser tool, and Google's Sheets product page does not mention a Mac app. The steps here use Chrome on macOS.

### What is the keyboard shortcut to merge cells in Google Sheets on Mac?

Google's official list has no merge shortcut. It does list ⌃⌥O for the Format menu on Mac. Unito says Enter then picks Merge all, but Google's pages do not confirm it, so test it before you rely on it.

### Can I get values back after I merge cells?

Not from the merge itself. Only the top-left value stays, and unmerging does not restore the rest. Use your own copy of the data or the file's revision history to recover them.

### Why does sorting fail after I merge cells?

A merge keeps only the top-left value, so the other cells look empty to the sort. Unmerge the cells, fill the blanks, then sort. Unito also reports error messages when you sort a column with merged cells.

### How do I unmerge cells in Google Sheets on Mac?

Select the merged cell, then go to Format > Merge cells > Unmerge. Unito also describes the merge icon in the toolbar, followed by Unmerge. Unmerging does not bring back values that the merge dropped.

### Does merging cells work in Safari on Mac?

The sources for this page do not test merging in Safari. Google's offline help names Chrome and Microsoft Edge, and it does not mention Safari or Firefox. If the menus act differently for you, switch to Chrome for this task.

## Sources

1. [Freeze, group, hide, or merge rows & columns - Computer - Google Docs Editors Help](https://support.google.com/docs/answer/9060449?hl=en), Google, checked 2026-11-07
2. [Keyboard shortcuts for Google Sheets - Google Docs Editors Help](https://support.google.com/docs/answer/181110?hl=en&co=GENIE.Platform%3DDesktop), Google, checked 2026-11-07
3. [How to Merge Cells in Google Sheets - Unito.io](https://unito.io/blog/merge-cells-google-sheets/), Unito, checked 2026-11-07
4. [Google Sheets - Google Workspace](https://workspace.google.com/products/sheets/), Google, checked 2026-11-07
5. [Use Google Drive files offline - Computer - Google Drive Help](https://support.google.com/drive/answer/2375012?hl=en&co=GENIE.Platform%3DDesktop), Google, checked 2026-11-07
6. [Google Drive Help - file size and limit information](https://support.google.com/drive/answer/37603?hl=en), Google, checked 2026-11-07
7. [How to Use Google Sheets Offline on Mac - Bricks](https://www.thebricks.com/resources/guide-how-to-use-google-sheets-offline-on-mac), Bricks, checked 2026-11-07
8. [How to Sort Merged Cells in Google Sheets - Bricks](https://www.thebricks.com/resources/guide-how-to-sort-merged-cells-in-google-sheets), Bricks, checked 2026-11-07