How to merge and unmerge cells in Excel
In Excel for Windows, select adjacent cells and choose Merge & Center on the Home tab to combine them. Choose Unmerge Cells from the same menu to restore the individual cells. In a left-to-right sheet, merging keeps only the upper-left value, so check the selected range first.
Center a heading over several columns
- In a blank worksheet, type Monthly report in B2 and leave C2 and D2 empty. Select B2:D2. In your own workbook, put the heading you want to keep in the upper-left cell.
- Choose Merge & Center in the Home tab’s Alignment group. If Excel warns that other values will be lost, cancel and move or copy those values first.
The heading is centered in the merged B2:D2 area. The columns in the rows below are still separate, so you can fill them individually.
Choose a merge mode
Open the arrow next to Merge & Center to see Merge Across, Merge Cells, and Unmerge Cells. Pick the command based on the area you want to combine and whether the heading should be centered. Try each mode on a fresh sheet so a previous merge does not overlap the new selection.
Choose Merge Across to merge horizontally within each selected row. Select B2:D3 to try it on two rows. Put the value you want to keep at the start of each row before merging.
Excel produces two merged areas, B2:D2 and B3:D3. Each row still has its own heading cell.
Choose Merge Cells to combine all of B2:D3 into one area without applying new centering. Check the alignment after merging if the heading should stay left-aligned.
What happens when several cells contain values
In a test sheet, type 1 in B2, 2 in C2, and 3 in D2, then select B2:D2. Save a copy before trying the equivalent operation on real data.
When you choose to merge, Excel warns that other values will be lost. Cancel if you need to keep 2 and 3, then copy them elsewhere. If you want one cell containing all the values, combine them with CONCAT or TEXTJOIN first.
If you continue, only 1 remains in a left-to-right sheet. Microsoft notes that right-to-left layouts retain the upper-right value.
If the merge was a mistake, press Ctrl+Z immediately and check for the original values. If undo is unavailable or you have made many changes since, consult the saved copy.
Unmerge cells and verify the result
- Select the merged cell. On the Home tab open the merge menu and choose Unmerge Cells.
The separate cells reappear. In a left-to-right sheet, the surviving content appears in the upper-left cell. In the exercise, B2 still contains 1 and C2 and D2 stay empty.
Unmerge Cells applies to an existing merge. A regular grid cell cannot be subdivided by this command. To distribute a string such as a comma-separated list from a single cell across columns, use Text to Columns on the Data tab. Check that the destination columns are clear before splitting the text.
When to keep a data range unmerged
Merging is useful for a report heading above a data range. Keep each row’s column structure intact in data you need to sort or filter. Place a spanning heading outside the range used for those operations.
If the command is unavailable, finish editing the cell and check whether the selected cells are inside an Excel table. If you need table features, try placing the heading outside the table first.
Microsoft Support guide to merging and unmerging Excel cells




