How to Merge Cells in Excel, and When Not To
By ExcelReady TeamUpdated 4 min read
The short answer
To merge cells in Excel, select them and click Home > Merge & Center, or press Alt, H, M, C on Windows. Excel keeps only the upper-left value, so join text with & first if you need it all. Avoid merging inside data tables: it breaks sorting, filtering and copying. Center Across Selection looks the same without those problems.
Key takeaways
- Home > Merge & Center (Alt, H, M, C on Windows) turns several cells into one big cell.
- Merging keeps only the upper-left value; combine text with & or TEXTJOIN first to keep everything.
- Merged cells inside a data table break sorting, filtering, copying and selecting.
- Center Across Selection gives the same look for titles without actually merging.
- Unmerge with Home > Merge & Center > Unmerge Cells, then fill the blanks if needed.
On this page+
To merge cells in Excel, select them and click Home > Merge & Center. The cells become one large cell, which is handy for a report title. But merging has a cost: Excel keeps only the upper-left value, and merged cells inside a data table break sorting, filtering and copying. This guide shows how to merge and unmerge on Windows and Mac, how to keep all your text, and the better option for most layouts.
How to merge cells in Excel#
Merging joins two or more neighbouring cells into one. The new cell takes the address of the upper-left cell, so merging A1:E1 gives one cell called A1.
- Select the cells, for example A1:E1.
- On the Home tab, in the Alignment group, click Merge & Center.
- The cells merge and the text is centred across them.
On Windows, the keyboard sequence is Alt, H, M, C: press and release each key in turn. Excel for Mac has no built-in shortcut, but the Merge & Center button is on the Home tab, and you can also tick Merge cells in Format Cells (⌘1) > Alignment.
What are the merge options?#
Click the small arrow next to Merge & Center to see four choices.
| Option | What it does | Windows keys |
|---|---|---|
| Merge & Center | Merges the cells and centres the text | Alt, H, M, C |
| Merge Across | Merges each selected row separately | Alt, H, M, A |
| Merge Cells | Merges without changing the alignment | Alt, H, M, M |
| Unmerge Cells | Splits a merged cell back into normal cells | Alt, H, M, U |
Merge Across is useful when you select A1:D3 and want three wide rows rather than one big block.
Why does merging delete my data?#
A merged cell can hold only one value, so Excel keeps the upper-left value and deletes the others. Excel shows a warning before it does this. If you click OK, the other values are gone.
If you didn't mean to lose them, undo right away with Ctrl+Z (⌘Z on a Mac). The guide to editing cells and undo and redo explains how far back undo goes.
How to merge cells without losing data#
Combine the values with a formula first, then decide whether you still need to merge. To join a first name in A2 and a last name in B2 with a space:
=A2&" "&B2With Maria and Okafor, the result is Maria Okafor. For many cells at once, TEXTJOIN adds the separator for you: =TEXTJOIN(" ",TRUE,A2:C2) (Excel 2019 or later). To make the result permanent, copy it and paste it as values.
Often the combined cell is all you need, and you don't have to merge at all.
When not to merge cells#
Don't merge cells inside any range you plan to sort, filter, copy or analyse. Merged cells cause these problems:
- Sorting fails. Excel shows an error that all the merged cells need to be the same size.
- Filtering hides data. Only the first row of a merged block is linked to the value, so filters miss the other rows.
- Copying and pasting go wrong. You can't paste into part of a merged cell.
- Selecting a column grabs extra columns. Clicking one column letter can select every column the merged cell touches.
- Formulas and pivot tables see blanks. Only the upper-left cell holds the value; the rest are empty.
- AutoFit doesn't work. Rows with merged, wrapped cells won't resize by themselves.
Merging inside an Excel Table isn't allowed at all, which is one reason tables stay so tidy. Merged cells are fine in a title or header area above the data, as long as the data rows themselves stay unmerged.
Center Across Selection: the better alternative#
Center Across Selection centres text across several cells without merging them. It looks the same as Merge & Center, but every cell stays separate, so nothing breaks.
- Select the cells, for example A1:E1, with the title in A1.
- Open Format Cells: Ctrl+1 on Windows, ⌘1 on a Mac.
- On the Alignment tab, under Horizontal, choose Center Across Selection.
- Click OK.
The only limit is direction: it works across a row, not down a column. For a label that spans rows, use vertical alignment and a border instead. Number and alignment settings live in the same dialog, which the guide to formatting numbers as currency and percent explains.
How to unmerge cells and fill the blanks#
To unmerge, select the merged cell and click Merge & Center again, or choose Unmerge Cells from its menu. The value goes back to the upper-left cell and the other cells are empty.
That often leaves gaps, for example a region name in row 2 and blanks in rows 3 to 5. Fill them with the value above in one step using Go To Special, as shown in how to fill blank cells in Excel.
To find every merged cell on a sheet, press Ctrl+F (⌘F on a Mac), click Options > Format, tick Merge cells on the Alignment tab and click Find All.
If Merge & Center is greyed out, check three things: the cells may be in an Excel Table, the sheet may be protected (see how to protect a sheet and lock cells), or you may still be editing a cell. Press Esc and try again.
Practise it#
Good formatting is about choosing the right tool, not the most dramatic one. Try the exercise on this page to combine names without losing data. Then open the More formatting lesson to practise italic, underline, comma style, date formats and resetting a cell to General in a live spreadsheet. Each step is checked instantly.
Try it yourself
This is a live spreadsheet. Type the formula in the green cell and press Enter.
Merging would keep only the first name. Join both names instead: click C2, type =A2&" "&B2 and press Enter.
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Full Name | |||
| 2 | Okafor | |||
| 3 | Lindqvist | |||
| 4 | Tanaka | |||
| 5 | ||||
| 6 | ||||
| 7 |
Tip: Use & to join A2, a space in double quotes, and B2.
Practise this in a lesson
Frequently asked questions
How do I merge cells in Excel without losing data?
Excel keeps only the upper-left value when you merge. Combine the text in a new cell first with a formula like =A2&" "&B2, copy and paste it as values, then merge or simply use the combined cell.
What is the shortcut for Merge and Center in Excel?
On Windows, press Alt, then H, then M, then C, one key after the other. Excel for Mac has no built-in shortcut, so use the Merge & Center button on the Home tab.
Why can't I merge cells in Excel?
The button is greyed out when the cells are inside an Excel Table, when the sheet is protected, or when you are editing a cell. Convert the table to a range, unprotect the sheet, or press Esc first.
Why does Excel say merged cells need to be the same size?
That error appears when you sort a range that contains merged cells of different sizes. Unmerge the cells in the data, then sort again.
What can I use instead of merging cells?
Use Center Across Selection: select the cells, open Format Cells, go to Alignment and choose it under Horizontal. The text looks centred across the cells, but each cell stays separate.