SheetDo
English
Home / Tools / Google Sheets Merge Cells Shortcut & Quick Guide
Shortcuts & Tools Google Sheets + Excel

Google Sheets Merge Cells Shortcut & Quick Guide

Looking for the fastest shortcut for merging cells in Google Sheets or Excel? While Google Sheets lacks a single-key default shortcut, you can merge in seconds using keyboard menu access, quick search (Alt+/), or the F4 repeat key. Check the cheat sheet below, then test what happens to your data in the interactive grid.

Quick Shortcuts & Menu Paths

At-a-glance comparison for Google Sheets and Microsoft Excel. Master hotkeys, quick search, and step-by-step clicks:

Google Sheets
Most Searched
👆 Click Path (Menu Bar)
1 Select Cells
2 Format
3 Merge cells
4 Merge all

Or click the Merge icon [⊞] on the main toolbar for one-click merge

⌨️ Menu Shortcuts (Sequential Access)
Windows
Alt + O then M then Enter

If your browser intercepts Alt, use Alt + Shift + O instead

Mac
Ctrl + Option + O then M then Enter

Opens the Format menu, then M triggers Merge all

⚡ Fastest Universal Trick (Quick Search)
Win: Alt + / · Mac: Option + /

Type 'merge' and press Enter to merge selected cells instantly

F4 Merge once, then select any other range and press F4 (or Ctrl/Cmd + Y) to repeat instantly!
Microsoft Excel
Ribbon Hotkeys
👆 Click Path (Ribbon)
1 Select Cells
2 Home tab
3 Merge & Center

Click the dropdown arrow for 'Merge Across', 'Merge Cells', or 'Unmerge Cells'

⌨️ Windows Ribbon Shortcuts (Sequential)
Win (Center)
Alt ➔ H ➔ M ➔ C
Win (Merge)
Alt ➔ H ➔ M ➔ M
Win (Unmerge)
Alt ➔ H ➔ M ➔ U
Mac

Mac Excel has no built-in single shortcut. Use F4 to repeat the last merge, or assign a custom shortcut in macOS System Settings.

💡 How Excel ribbon hotkeys work

Press and release Alt to see the ribbon KeyTips, then press H (Home), M (Merge), and C (Center). You don't need to hold all keys down together!

Interactive Merge Simulator: Watch What Happens to Data

A1:B2 holds 4 different values. Test the merge button or menu in the live grid below to see data loss in real time:

Three Gotchas You Must Know

⚠️ Gotcha 1

Only the top-left value survives

Merging A1:B2 silently and permanently discards B1, A2, and B2. Back up important data first, or use Center Across Selection instead.

⚠️ Gotcha 2

Sorting and filtering break

A merged block only exists in its top-left cell. Sorting, filtering, and range formulas like SUM or AVERAGE covering the area will fail.

⚠️ Gotcha 3

Unmerge does NOT restore deleted values

Unmerging only restores the cell grid lines. The discarded values are gone permanently unless you undo immediately.

Better Alternatives to Merging Cells

Zero Data Loss

Center Across Selection (Excel)

In Excel, select your horizontal range and press Ctrl+1 → Alignment tab → choose 'Center Across Selection' in the Horizontal menu. Your title centers visually across columns, while every single cell remains distinct! Sorting and formulas never break.

Safest

Text Combination Formulas (Sheets & Excel)

Need to combine data from multiple cells without losing values? Use =TEXTJOIN(" ", TRUE, A1:B1) or =JOIN(" ", A1:B1) to safely join all contents into one cell first before styling.

Practice text cleanup formulas → More Excel shortcuts cheat sheet →

FAQ

What is the Google Sheets merge cells shortcut on Windows and Mac?

On Windows, use the menu shortcut Alt + O, then M, then Enter (or Alt + Shift + O depending on browser settings). On Mac, press Ctrl + Option + O, then M, then Enter. Alternatively, press Alt + / (Windows) or Option + / (Mac) to open Quick Search, type 'merge', and press Enter.

Is there a single-key shortcut for merging cells in Google Sheets?

Google Sheets does not have a native single-key shortcut like Ctrl+M (which indents text). However, after merging a cell once via the toolbar or menu, you can press F4 (or Ctrl+Y on Windows / Cmd+Y on Mac) on any other selection to repeat the merge immediately.

What is the Excel shortcut to merge cells and center?

In Excel for Windows, select the range and press Alt → H → M → C to Merge & Center, or Alt → H → M → M to Merge Cells without centering. To unmerge, press Alt → H → M → U. On Mac, there is no built-in single shortcut, but you can assign a custom shortcut in macOS System Settings or use F4 to repeat.

How do I merge cells in Google Sheets or Excel without losing data?

Standard merging always discards all data except the top-left cell. To keep all your text, combine the cells using a formula first like =JOIN(" ", A1:B1) or =TEXTJOIN(" ", TRUE, A1:B1). In Excel, you can also use 'Center Across Selection' (Ctrl+1 → Alignment) to visually center across columns without merging.

How do I unmerge cells in Google Sheets and Excel?

In Google Sheets, select the merged cell and click the Merge icon in the toolbar, or choose Format → Merge cells → Unmerge. In Excel, click Merge & Center again or press Alt → H → M → U. Unmerge restores the cell grid, but deleted values are permanently lost.