Merge Cells in Excel: the right way (and the trap)

Merging joins several cells into one big cell. People use it for headings that span columns.

Merge cells

1. Select the cells — for example A1 to D1.
2. On the Home tab click Merge & Center.

Only the top-left value survives. Anything in the other cells is deleted, so merge before you type.

Unmerge

Select the merged cell and click Merge & Center again.

The trap

Merged cells break sorting, filtering, copy-paste and selecting whole columns. Excel shows “To do this, all merged cells need to be the same size” and stops. If the merge sits inside a data table, you will hit this.

The better alternative

Center Across Selection looks identical but keeps the cells separate:

1. Type the heading in A1. Select A1 to D1.
2. Press Ctrl + 1 › Alignment tab.
3. Under Horizontal choose Center Across Selection. OK.

The text sits centred over the four columns and sorting still works.

Merge without centring

Click the small arrow next to Merge & Center: Merge Across merges each row separately; Merge Cells merges without centring.