Merging cells combines two or more cells into one — useful for centering a title across columns or building a header. Excel offers a few merge options, and one important alternative you should know about, because merged cells can cause problems.
How to merge cells
- Select the cells you want to merge (they must be adjacent).
- On the Home tab, find the Merge & Center button (in the Alignment group).
- Click it, and the selected cells become one, with the content centered.
The merge options
Click the small arrow next to Merge & Center for the full menu:
- Merge & Center — combines the cells and centers the content. Best for titles spanning columns.
- Merge Across — merges cells in each row separately (so a selection spanning several rows becomes one merged cell per row, not one big block).
- Merge Cells — combines into one cell without centering the content.
- Unmerge Cells — splits a merged cell back into individual cells.
The important warning
Merged cells look tidy but cause real problems:
- They break sorting and filtering. Excel often refuses to sort or filter ranges containing merged cells, or throws errors.
- They interfere with formulas and selection. Referencing and navigating merged areas gets awkward.
- They disrupt copy-paste and can block features like tables and pivot tables.
- Only the top-left value survives. When you merge cells that contain data, Excel keeps only the upper-left cell's content and discards the rest (with a warning).
Because of this, experienced Excel users avoid merging in data areas and use it only for display headers, if at all.
The better alternative: Center Across Selection
If you only want to center a title across columns (the most common reason people merge), there's a cleaner way that doesn't create the problems above:
- Type your title in the leftmost cell.
- Select that cell plus the cells you want to center across.
- Press Ctrl+1 to open Format Cells.
- Go to the Alignment tab.
- Under Horizontal, choose Center Across Selection.
- Click OK.
The text now appears centered across all those columns — visually identical to merging — but the cells aren't actually merged, so sorting, filtering, and formulas keep working normally. This is the professional's trick, and it's worth using instead of Merge & Center whenever you just need centered display text.
Unmerging
If you inherit a sheet full of merged cells causing trouble: select the range (or the whole sheet with Ctrl+A), then click Merge & Center to toggle it off, or choose Unmerge Cells from the dropdown. This restores normal cells.
The takeaway
Merge cells with Home > Merge & Center, but know the cost: merged cells break sorting, filtering, and formulas. For the common case of centering a title across columns, use Center Across Selection (Format Cells > Alignment) instead — it looks the same without any of the downsides. Reserve real merging for display-only headers where you won't need to sort or filter.