How to Merge Cells in Excel: The Complete Guide (2026)

Merging cells is one of Excel’s most commonly used formatting tricks — perfect for creating a clean title across the top of a report, combining header labels, or making a table look more presentable before sharing it with a client or manager. But it’s also a feature with a few hidden gotchas: it silently deletes data from all but one cell, and it can quietly break sorting, filtering, and pivot tables down the line if you’re not careful.

This guide covers every way to merge cells in Excel on both Windows and Mac, how to merge without losing your data, the keyboard shortcuts that make it fast, and — just as importantly — when you should avoid merging altogether in favor of a safer alternative.

What Happens When You Merge Cells in Excel

Before merging anything, it helps to understand exactly what the feature does. When you merge multiple cells together, Excel combines them into a single larger cell, but only the contents of one cell survive — specifically, the upper-left cell in the selection (or the upper-right cell if you’re working in a right-to-left language). Everything else in the selected range is deleted the moment you merge.

This is the single most important thing to know before merging anything with existing data in more than one cell, since there’s no built-in warning that walks you through what’s about to be lost beyond a single confirmation popup.

How to Merge Cells in Excel on Windows (Using the Ribbon)

1. Open your Excel spreadsheet and select the two or more adjacent cells you want to merge by clicking and dragging your mouse across them.
2. In the Alignment group, click the Merge & Center button, or click the small dropdown arrow next to it for more options.
3. From the dropdown, choose one of the following:
   • Merge Across — merges each row within your selection separately, useful when you’ve selected multiple rows and columns but want each row to merge independently rather than combining into one giant block.
   • Merge Cells — merges the selection into one cell without applying any centering.
   • Unmerge Cells — reverses a previous merge, splitting the cell back into its original individual cells.

 

Merge Cells on Mac

The process is nearly identical to Windows, since Mac Excel uses the same ribbon-based interface:

1. Open Excel on your Mac and select the cells you want to merge by clicking and dragging.
2. Go to the Home tab.
3. Find the Merge & Center option in the Alignment section of the ribbon.
4. Click the small arrow next to it to see the same set of options — Merge & Center, Merge Across, Merge Cells, or Unmerge Cells.
5. Choose your preferred option to complete the merge.

If you’re selecting non-contiguous cells (cells that aren’t right next to each other) on Mac, hold Command while clicking each individual cell before applying the merge.

Keyboard Shortcuts to Merge Cells

If you’d rather skip the ribbon entirely, Excel supports keyboard shortcuts for merging — though the process looks a little different depending on your platform.

On Windows

Excel’s ribbon shortcuts work as a sequence of keys pressed one after another (not held simultaneously):

• Merge Cells: Alt, then H, then M, then M
• Merge & Center: Alt, then H, then M, then C
• Merge Across: Alt, then H, then M, then A

Press Alt first and release, then press each subsequent letter in order — you’ll see small letter overlays appear on the ribbon guiding you through each step, which is Excel’s built-in way of showing you these ribbon-based keyboard shortcuts.

On Mac

Since Mac keyboards don’t have an Alt key in the same sense Windows does, merging cells via a direct keyboard shortcut isn’t built in by default the same way. Instead, you have two options:

1. Use the built-in shortcut some versions support: Command + Option + M, followed by M, C, or A depending on whether you want a plain merge, merge and center, or merge across.
2. Create your own custom shortcut:
   • Go to the Tools menu in Excel’s navigation bar.
   • Select Customize Keyboard.
   • In the popup window, under Categories, select Home Tab.
   • Under Commands, choose Merge Cells (or Merge & Center, Merge Across, Unmerge Cells — repeat this process for each one you’d like a shortcut for).
   • Click into the box under Press new keyboard shortcut, and enter your preferred key combination, such as Control + M.
   • Click OK to save.

Many Mac users who work regularly alongside Windows colleagues set up a custom shortcut like Control+M specifically to create parity with the Windows Alt+H+M+C sequence, making it easier to switch between machines without relearning muscle memory.

How to Merge Cells Without Losing Data

Since a standard merge deletes all but one cell’s contents, here are a few reliable ways to combine cell contents while keeping everything intact.

Method 1: The CONCATENATE Formula

1. Select an empty cell — not one of the cells you’re combining — where you want the combined result to appear.
2. Type a formula like: =CONCATENATE(A1," ",B1)
3. Press Enter.

The result will show the combined text from both cells, separated by whatever separator you specify inside the quotation marks (a space, comma, dash, or nothing at all if you leave the quotes empty).

Method 2: The Ampersand (&) Operator

A simpler alternative to CONCATENATE that many people find more intuitive:

1. In an empty cell, type a formula like: =A1 & " " & B1
2. Press Enter.

This produces the same result as CONCATENATE but with slightly shorter, more readable syntax for simple two-cell combinations.

Method 3: TEXTJOIN for Multiple Cells

If you’re combining more than two cells and want a cleaner formula, TEXTJOIN is often the best option:

1. In an empty cell, type: =TEXTJOIN(", ", TRUE, A1:B1)
2. Press Enter.

The first argument sets your separator (a comma and space, in this example), the second argument (TRUE) tells Excel to ignore any empty cells in the range, and the final argument is the range of cells you want joined together.

Unlike a standard merge, all of these formula-based methods leave your original cells completely untouched — the combined result simply lives in a separate cell, referencing the originals.

Merge & Center vs. Center Across Selection: A Safer Alternative

If your main goal with merging is purely visual — like centering a title across several columns — there’s a lesser-known but often better option: Center Across Selection.

1. Select the range of cells you want the text to visually span.
2. Press Ctrl + 1 (Windows) or Command + 1 (Mac) to open the Format Cells dialog.
3. Go to the Alignment tab.
4. Click OK.

This achieves the same centered, spanning visual effect as Merge & Center, but critically, it doesn’t actually merge the underlying cells. Your spreadsheet’s structure stays completely intact — which matters a lot more than it sounds like, as covered in the next section.

Why You Should Think Twice Before Merging Cells

Merged cells look clean, but they come with real functional costs that catch a lot of people off guard later:

• Sorting breaks. Excel can’t sort ranges that include merged cells of different sizes, often producing an error or simply refusing to sort the selection at all.
• Filtering behaves unpredictably. Applying filters to a dataset containing merged cells can produce inconsistent or misleading results, since Excel doesn’t always handle the merged rows the way you’d expect a normal, uniform table to behave.
• Pivot tables can break entirely. Attempting to build a PivotTable from a data range containing merged cells is a common source of errors and missing data, since PivotTables expect a strictly uniform, unmerged grid of individual cells.
• Copy-pasting and formulas get finicky. Referencing merged cells in formulas elsewhere in your workbook can behave inconsistently, especially when copying formulas across a range that includes merged and unmerged cells side by side.

For these reasons, professional analysts and heavy Excel users often reserve merging strictly for cosmetic elements like a report title, and use Center Across Selection instead for anything that might later need to be sorted, filtered, or fed into a PivotTable.

How to Unmerge Cells

If you’ve merged cells and want to reverse it:

1. Select the merged cell you want to split back apart.
2. Go to the Home tab.
3. Click the small dropdown arrow next to Merge & Center.
4. Select Unmerge Cells.

Keep in mind that unmerging does not restore any data that was deleted during the original merge — it only splits the merged cell back into its original individual cell boundaries, all of which (except the one that retained the data) will now be empty.

Splitting a Single Cell (What to Do Instead)

Excel doesn’t actually support splitting one individual cell into multiple smaller ones the way you might expect. However, there’s a practical workaround for text data that needs separating:

1. Select the cell or column containing the text you want to split.
2. Choose Delimited, then click Next.
3. Check the box matching how your data is separated — Space, Comma, or another delimiter — and uncheck the rest.
4. Preview the split in the panel at the bottom of the wizard.
5. Click Next, choose a format for your new columns (Text is often safest if you’re unsure), and click Finish.

Make sure there are enough empty columns to the right of your data before running this, since Text to Columns will overwrite whatever’s already there.

Frequently Asked Questions

1. What happens to data in cells that I merge together? Only the contents of the upper-left cell in your selection are kept. All other data in the merged range is permanently deleted the moment you confirm the merge.

2. How do I merge cells without losing the data in each one? Use a formula instead of a standard merge — CONCATENATE, the ampersand (&) operator, or TEXTJOIN can all combine cell contents into a new cell while leaving your original cells untouched.

3. What’s the keyboard shortcut to merge and center cells in Excel on Windows? Press Alt, then H, then M, then C, in sequence (not all at once) to merge and center your selected cells.

4. How do I merge cells in Excel on a Mac without a built-in shortcut? You can create a custom shortcut through Tools > Customize Keyboard, selecting the Merge Cells (or related) command under the Home Tab category, then assigning a key combination like Control+M.

5. Why can’t I sort my data after merging some cells? Excel generally can’t sort a range that includes merged cells of inconsistent sizes, since sorting depends on a uniform grid structure that merging disrupts.

6. What’s a safer alternative to merging if I just want centered text across columns? Use Center Across Selection instead, found under Format Cells > Alignment > Horizontal. It visually centers text across multiple columns without actually merging the underlying cells, preserving your spreadsheet’s structure.

7. Can I merge non-adjacent cells in Excel? Not directly as a single merge. Excel’s merge function only works on a contiguous, rectangular range of selected cells — you can’t merge cells that are separated by other cells or rows.

8. Does merging cells affect PivotTables built from that data? Yes, often significantly. PivotTables generally expect a clean, unmerged data range, and merged cells within your source data are a common cause of PivotTable errors, missing rows, or unpredictable behavior.

Conclusion

Merging cells in Excel takes just a couple of clicks — or a quick keyboard shortcut once you’ve built the muscle memory — but the real skill is knowing when to use it. For a clean report title or a header that spans several columns, merging (or better yet, Center Across Selection) works beautifully. For anything involving actual data you’ll want to sort, filter, or analyze later, it’s almost always safer to keep your cells unmerged and rely on formulas like CONCATENATE or TEXTJOIN if you need to combine content visually. Knowing both sides of that trade-off is really what separates a tidy-looking spreadsheet from one that quietly causes headaches down the line.