Is There a Merge Cells Shortcut in Excel for Mac? (Merge & Center, Unmerge and Better Options)

Is There a Merge Cells Shortcut in Excel for Mac? (Merge & Center, Unmerge and Better Options)

On Windows, merging a title across a table is a reflex: Alt, H, M, C and you're done. On a Mac, people usually try Option+H, get a stray ˙ character in the cell, and then go hunting through the Ribbon. Excel for Mac can merge cells perfectly well. It just doesn't come with a keyboard shortcut for it.

Quick answer: Excel for Mac has no default keyboard shortcut for Merge & Center. Select the cells and click Home → Merge & Center, or press ⌘1, open the Alignment tab and tick Merge cells. To get a real shortcut, assign one under Tools → Customize Keyboard (search for "merge"), or try KeyTips (Microsoft 365, version 16.89 or later) under Excel → Settings → Accessibility. For headings across a table, Center Across Selection usually works better than merging.

What merging does — and what it deletes

Merging turns several adjacent cells into one larger cell. It's mostly used for titles and group headings, such as "Q1 2026" spanning three month columns.

The catch is in Microsoft's own documentation: only the upper-left cell's contents are kept. Everything in the other cells is deleted. Excel shows a warning when that will happen, but it's easy to click through it at speed.

Merged cells also cause trouble later. They're the most common reason for these errors:

  • Sort: "To do this, all the merged cells need to be the same size."

  • Paste: "We can't do that to a merged cell."

  • Filter: only the first row of a merged block shows up, because the value only exists in the top-left cell.

So the rule of thumb is: merge for presentation, never inside a data table.

At a glance: every way to merge on a Mac

MethodHowBest forTrade-off
Ribbon buttonHome → Merge & CenterOccasional mergesMouse trip every time
Format Cells⌘1 → Alignment → Merge cellsKeyboard users, combining with wrap or alignmentSeveral steps, and it doesn't centre automatically
Custom shortcutTools → Customize KeyboardPeople who merge dailyOne-time setup per Mac
KeyTips (16.89+)Turn on in Keyboard-first Microsoft 365 usersOff by default; many Windows Alt sequences don't work; not on perpetual versions
Mac Excel Shortcuts appType Windows switchers who don't want to relearnSeparate app with Accessibility permissions

Method 1: Merge & Center from the Ribbon

  1. Select the cells you want to merge, for example A1:D1.

  2. On the Home tab, click Merge & Center.

To choose a different merge type, click the small arrow next to the button:

OptionWhat it doesWindows sequence
Merge & CenterMerges the selection into one cell and centres the textAlt, H, M, C
Merge AcrossMerges each selected row separately (useful for multi-row labels)Alt, H, M, A
Merge CellsMerges without changing the alignmentAlt, H, M, M
Unmerge CellsSplits a merged cell back into individual cellsAlt, H, M, U

Merge Across is the one people forget exists. If you select A1:D3 and choose Merge Across, you get three merged rows (A1:D1, A2:D2, A3:D3) instead of one big block. That's exactly what you want for a stack of labels.

Method 2: Merge with the keyboard using Format Cells (⌘1)

This is the closest thing to a built-in keyboard route:

  1. Select the range with Shift+arrow keys.

  2. Press ⌘1 to open Format Cells.

  3. Go to the Alignment tab.

  4. Tick Merge cells. While you're there, set Horizontal to Center if you want the Merge & Center result.

  5. Press Return.

It's slower than one click, but it lets you set merge, alignment and Wrap text in one go. That's handy for multi-line headers.

Method 3: Create your own Merge & Center shortcut

Excel for Mac has a keyboard customiser that most Windows switchers never find, because Windows Excel doesn't have one.

  1. In the menu bar, choose Tools → Customize Keyboard…

  2. In Categories, choose the Home tab group (or type "merge" in the search box).

  3. Select Merge and Center in the Commands list.

  4. Click in Press new keyboard shortcut and press the combination you want, for example ⌃⌥M.

  5. Check that the box below doesn't say it's already assigned, then click Add and OK.

Pick something that macOS isn't already using. ⌘⌥M is a popular suggestion online, but macOS uses it to minimise all windows, so Excel never sees it.

Tip: Use the same dialog to give Unmerge Cells a shortcut too. Unmerging is often the more frequent job when you're cleaning up someone else's file.

You may also see advice to use macOS System Settings → Keyboard → Keyboard Shortcuts → App Shortcuts. That route only works for commands in Excel's menu bar, and Merge & Center lives in the Ribbon. Use Excel's own Customize Keyboard instead.

Method 4: Turn on KeyTips (Microsoft 365 for Mac, 16.89+)

Recent Microsoft 365 builds of Excel for Mac include KeyTips — the letter badges you see on the Ribbon when you press Alt in Windows. They're off by default.

  1. Choose Excel → Settings… (or press ⌘,).

  2. Open Accessibility.

  3. Under KeyTips, set the Activation keystroke to Option (⌥) or Shift+Option.

  4. Back in your sheet, press the activation key and follow the letters shown on the Ribbon.

KeyTips need a current Microsoft 365 subscription build. Perpetual-licence versions such as Excel 2019 and 2021 for Mac don't get new features, so they won't have them. Check Excel → About Excel for your version.

Don't expect them to behave exactly like Windows, either. Mac KeyTips are a partial implementation: many Alt sequences that work on Windows, such as Alt, E, S, V for Paste Values, don't work on the Mac.

Method 5: Keep your Windows muscle memory

If you've merged cells with Alt, H, M, C for years, the Mac Excel Shortcuts app lets you type the same sequence in Excel for Mac. It supports the full merge family: Alt, H, M, C (Merge & Center), Alt, H, M, A (Merge Across), Alt, H, M, M (Merge Cells) and Alt, H, M, U (Unmerge). Press the keys one after another, as on Windows; you don't hold them together.

The better alternative: Center Across Selection

If you're merging to centre a title over a table, Center Across Selection gives the same look without actually merging anything. Sorting, filtering, copying and selecting columns all keep working.

  1. Type the title in the leftmost cell, for example A1.

  2. Select the full width, for example A1:F1.

  3. Press ⌘1, open the Alignment tab.

  4. Set Horizontal to Center Across Selection.

  5. Press Return.

The text sits centred across A1:F1, but each cell is still a separate cell. Financial modellers often have a firm rule against merged cells for exactly this reason.

Center Across Selection only works horizontally. For a label that spans several rows vertically, merging is still the only built-in option.

How to unmerge cells (and find merged cells) on Mac

To unmerge one cell, select it and choose Home → Merge & Center ▾ → Unmerge Cells, or click Merge & Center again to toggle it off. If you only just merged, ⌘Z undoes it.

Finding merged cells is harder on a Mac. On Windows you can search for them with Find → Format → Merge cells, but the Find dialog in Excel for Mac has no Format option. The practical workaround is:

  1. Press ⌘A (or click the triangle at the top-left corner of the grid) to select the whole sheet.

  2. Choose Home → Merge & Center ▾ → Unmerge Cells.

That removes every merge on the sheet in one go, which is usually what you want before sorting or building a PivotTable. Only the upper-left cell of each former merge keeps its value. The other cells will be empty.

When people say "merge" but mean combine text

A lot of searches for "merge cells in Excel on Mac" are really about combining the text of two cells, such as first and last name, without losing either. Merging won't do that. Use a formula instead:

GoalFormulaResult
Join with a space=A2&" "&B2Ada Lovelace
Join with CONCAT=CONCAT(A2," ",B2)Ada Lovelace
Join a range with commas, skipping blanks=TEXTJOIN(", ",TRUE,A2:D2)London, UK, 1815

CONCAT and TEXTJOIN work in Microsoft 365 for Mac and Excel 2019 or later. In Excel 2016 for Mac, use & or CONCATENATE.

When the results look right, copy the formula column and use Paste Special → Values (⌃⌘V, then V) so you can safely delete the original columns.

Common mistakes

Pressing Option+H and getting "˙"

Option isn't a Ribbon key on a Mac unless KeyTips are turned on. Without them, Option+letter types special characters.

Merging inside a data table

It breaks sorting, filtering, pasting and PivotTables. Merge only in report headers, or use Center Across Selection.

Merge & Center is greyed out

Check for these causes:

  • You're still editing a cell. Press Esc or Return first.

  • The cells are inside an Excel Table. Tables don't allow merging. Use Table → Convert to Range if you really need it.

  • The sheet is protected (Review → Unprotect Sheet).

Losing data you didn't mean to lose

If Excel warns that merging keeps only the upper-left value, cancel and combine the text with a formula first.

Windows equivalent

TaskWindows ExcelExcel for Mac (built-in)
Merge & CenterAlt, H, M, CHome → Merge & Center, or a custom shortcut
Merge AcrossAlt, H, M, AHome → Merge & Center ▾ → Merge Across
Merge CellsAlt, H, M, M⌘1 → Alignment → Merge cells
UnmergeAlt, H, M, UHome → Merge & Center ▾ → Unmerge Cells
Format CellsCtrl+1⌘1
Find merged cellsCtrl+F → Format → Merge cellsNot available; select all → Unmerge

FAQs

What is the shortcut for Merge & Center in Excel for Mac?

There isn't a default one. Assign your own with Tools → Customize Keyboard, use KeyTips in Microsoft 365 (16.89+), or use the Mac Excel Shortcuts app to type Alt, H, M, C.

Does ⌘⌥M merge cells?

No. macOS uses ⌘⌥M to minimise all windows of the current app.

Can I merge cells without losing data?

Not with Merge & Center. Combine the text first with &, CONCAT or TEXTJOIN, paste the result as values, then merge if you still need to.

How do I merge cells vertically in Excel for Mac?

Select the cells in one column (for example A2:A5) and use Merge & Center or Merge Cells. Center Across Selection doesn't work vertically.

Why can't I sort after merging cells?

Excel can only sort ranges where every merged cell is the same size. Unmerge the range (select all, then Unmerge Cells), and use Center Across Selection for headings instead.

How do I find all merged cells in Excel for Mac?

The Mac Find dialog can't search by format. Select the whole sheet and choose Unmerge Cells to clear them all, or check headings and totals rows by eye. Those are where merges usually hide.

Related guides

Sources

← Back to all articles