Excel does not truly merge cells — it combines them into one space and hides the rest
When you merge cells in Excel, the program combines multiple cells into a single larger cell. The content from the leftmost cell stays visible; content in the other cells disappears from view. This matters because merged cells can break sorting, filtering, and formulas in ways that unmerged cells do not.
If you need to keep all your data and just want text to span across columns visually, centering text across selection is safer than merging. If you do merge, understand that Excel treats the merged area as a single cell for all future operations — you cannot sort a column that contains merged cells, and formulas that reference merged cells sometimes behave unexpectedly.
Key Takeaways
- Merging cells hides data from all but the leftmost cell, so only merge when you have a single piece of information that should span multiple columns.
- Use "Center Across Selection" from the Format Cells dialog if you want text to look centered across columns without actually merging them.
- Merged cells prevent sorting and filtering, so avoid merging in data tables where you plan to reorganize rows.
- To unmerge cells, select the merged area, open Format Cells, and click "Unmerge Cells" — your original data will not reappear unless you undo when ready.
How to merge cells step by step
Select the cells you want to merge by clicking the first cell and dragging to the last one, or by clicking the first cell, holding Shift, and clicking the last cell. The cells must form a rectangle — you cannot merge cells in an L-shape or scattered pattern.
Open the Home tab at the top of the screen. In the Alignment group (toward the right side of the ribbon), click the small arrow next to "Merge & Center". A dropdown menu appears with four options: Merge & Center, Merge Across, Merge Cells, and Unmerge Cells. Choose the one that matches what you need. Merge & Center combines the cells and centers the text. Merge Across merges cells in the same row only. Merge Cells combines them without centering.
After you click, the cells become one. If you selected cells with data in more than one cell, only the content from the top-left cell remains visible. The other content is not deleted — it is hidden. If you undo when ready (Ctrl+Z), the hidden content reappears.
When merging makes sense and when it does not
Merge cells when you have a title or label that should span multiple columns and you do not plan to sort or filter that data. A header row that says "Sales by Quarter" across four columns is a good use. A table of customer names, addresses, and phone numbers is not — merged cells in a data table will prevent you from sorting by any column.
If your spreadsheet is mostly static — a report you print or email without changing the row order — merged cells are less of a problem. If you plan to add data, sort it, or use it as a lookup table, avoid merging. Many spreadsheets that start straightforward grow into tools that need sorting later, so it is safer to skip merging unless you are certain you will not need it.
Center Across Selection as a safer alternative
If you want text to look centered across multiple columns but need to keep your data structure intact, use Center Across Selection instead. Select the cells you want the text to span across. Open the Home tab, click the small arrow in the Alignment group, and choose "Format Cells". In the Alignment tab, find the Horizontal dropdown and select "Center Across Selection". Click OK.
The text now appears centered across the selected cells, but they remain separate cells underneath. You can still sort, filter, and reference individual cells. The text only looks merged — the structure is not. This is the better choice for most working spreadsheets.
Unmerging cells and recovering hidden data
Select the merged cell or cells you want to unmerge. Open the Home tab, click the arrow next to "Merge & Center", and select "Unmerge Cells". The merged area splits back into individual cells.
If the merged cell contained data from only one original cell, that data reappears in the top-left cell when you unmerge. If it contained data from multiple cells that were merged, only the top-left content was kept — the rest is gone unless you undo when ready. If you realize too late that you lost data, press Ctrl+Z to undo the merge and recover the hidden content.
Why merged cells break sorting and filtering
Excel's sort and filter features work on columns — they assume each row has the same structure. When you merge cells, you create rows with different structures. A merged cell that spans columns A through D takes up space in all four columns, but it is treated as a single cell. When you try to sort, Excel cannot align the data properly because the merged cell does not fit the column-by-column logic that sorting requires.
Filtering has the same problem. If you filter a column that contains merged cells, the filter may hide or show unexpected rows because the merged cell breaks the assumption that each row contains one value per column. For this reason, data tables should never contain merged cells. Reserve merging for headers, titles, and labels that sit outside your actual data.
Merged cells in formulas and references
When you reference a merged cell in a formula, Excel treats it as a single cell with the address of its top-left corner. If you merge cells A1 through D1, the merged cell is still called A1. A formula that says =A1 will return the content of that merged cell.
The problem arises when you delete or move merged cells. If a formula references a merged cell and you later unmerge it, the formula still points to the top-left cell of where the merge was, which may no longer contain the data you expected. For this reason, avoid merging cells that other formulas depend on. If you must merge, do it before you write formulas that reference those cells, and do not unmerge them later.
Frequently Asked Questions
Can I merge cells that contain different data?
Yes, but only the content of the top-left cell will remain visible after the merge. The other data is hidden and will be lost if you unmerge and then save the file. If you need to keep all the data, do not merge — use Center Across Selection instead, or leave the cells separate.
What happens if I merge cells in the middle of a sorted table?
Excel will usually warn you that the table contains merged cells and ask if you want to proceed. If you do, the sort may produce unexpected results because the merged cell breaks the row structure. It is better to unmerge first, sort, and then merge again if needed.
Can I merge cells in different rows and columns at the same time?
No. Merged cells must form a rectangle — you can merge cells A1 through C3, but not A1, C1, and A3 together. If you need a more complex layout, use Center Across Selection or adjust column widths instead.
How do I unmerge cells without losing data?
If the merged cell contains data from only one original cell, unmerging will not lose anything — that data reappears in the top-left cell. If it contains hidden data from other cells, you cannot recover it unless you undo the merge when ready. To avoid this, use Center Across Selection instead of merging when you have multiple pieces of data.
Does merging cells affect printing?
No. Merged cells print the same way they appear on screen — as a single larger cell with centered text. Merging does not change how the printed page looks, only how the spreadsheet behaves when you try to sort, filter, or reference the cells.