Merging cells can make a title or header span several columns, but it has a sharp edge: Excel keeps only the top-left cell value and removes the other selected values. Use a formula instead when the content in multiple cells must be preserved.
Does this affect you?
Use this for Excel for Microsoft 365, Excel 2021, and Excel 2019 on Windows or Mac when you need either a visual merge for layout or a real text combination without losing data.
Merge cells the standard way
Use this only when the selected range has content in one cell, or when you are sure the other cell contents are disposable.
- Select the adjacent cells to merge, such as A1:D1 for a title across four columns.
- Open the Home tab.
- Click Merge & Center in the Alignment group.
- Excel combines the cells and centers the upper-left cell value in the merged area.
For other layouts, open the Merge & Center dropdown. Merge Across merges each row separately, and Merge Cells merges the selection without centering the content.
Combine text without losing anything
Use a formula when several cells contain text that needs to be kept.
- Click an empty cell where the combined result should appear.
- Use a joining formula such as =A1&” “&B1&” “&C1, changing the separator as needed.
- In Microsoft 365, use =TEXTJOIN(” “,TRUE,A1:C1) to join a range while skipping blanks.
- Press Enter.
- To keep the combined result as plain text, copy it and use Paste Special > Values.
This does not create one large visual cell, but it preserves every source value and gives you one combined result to use elsewhere.
More control
Take the warning seriously
If Excel says only the upper-left value will be kept, cancel unless that is exactly what you want. Once the other values are discarded, unmerging will not bring them back.
Avoid merges inside sortable data
Merged cells inside a table often break sorting, filtering, and row-by-row formulas because the cells are no longer the same size. Keep merges for titles and headers outside the actual data range.
Use Center Across Selection instead
For a title that only needs to look centered across columns, select the range, press Ctrl+1, open Alignment, and set Horizontal to Center Across Selection. It looks like a merge but keeps each cell separate.
Unmerge cells
Select the merged cell, open the Merge & Center dropdown, and choose Unmerge Cells. The visible value returns to the top-left cell; the cells that lost data remain blank.
Sources
- Microsoft Support – Merge and unmerge cells (2025)
- Microsoft Support – CONCAT function (2025)
- Microsoft Support – TEXTJOIN function (2025)