What merging cells actually does
Merging cells combines two or more adjacent cells into a single larger cell. When you merge, Excel treats the merged area as one cell instead of many. The cell keeps the content from the top-left cell in the range you selected and discards the rest.
Merging is useful for headers that span multiple columns, labels that sit above grouped data, or creating visual separation in a report. It does not combine the numbers or text inside the cells — it only combines the cell containers themselves. If you need to add numbers together, you want a formula, not a merge.
Many people confuse merging with consolidating data. Merging is visual and structural. Consolidating is mathematical — it pulls data from multiple places and calculates a result. This guide covers merging. If you need to add up values from different cells, use a SUM formula instead.
Key Takeaways
- Merging combines the cell boxes themselves, not the data inside them, and keeps only the content from the top-left cell.
- Select the range of cells you want to merge, then use the Merge Cells button in the Alignment group on the Home tab.
- Merged cells can cause problems with sorting and filtering, so use them mainly for headers and labels, not for data rows.
- To unmerge, select the merged cell and click Merge Cells again to toggle it off.
- If you need to combine text from multiple cells into one, use the CONCATENATE function or the ampersand (&) operator instead of merging.
How to merge cells in Excel
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 be adjacent — they must touch each other in a rectangle shape. You cannot merge cells that are scattered across the sheet.
Go to the Home tab at the top of the ribbon. In the Alignment group (the middle section of buttons), find the Merge & Center button. Click the small arrow next to it to see your options: Merge Cells, Merge & Center, Merge Across, or Merge Down. Choose Merge Cells if you want to keep the content left-aligned, or Merge & Center if you want it centered in the merged area. Click your choice.
Excel will merge the selected cells and keep the content from the top-left cell. Any text or numbers in the other cells will be deleted. If you have data in those cells that you need, copy it somewhere else first.
When merging causes problems
Merged cells break sorting and filtering. If you try to sort a column that contains merged cells, Excel will either refuse to sort or will sort unpredictably because the merged cell does not fit neatly into a single row. Filtering also behaves strangely with merged cells in the header row.
For this reason, use merging only for headers, titles, and labels — not for the data rows themselves. If you have a table where each row is a record (like a customer list or inventory), do not merge cells in the data area. Merge only the header row or the title area above the table.
If you need to unmerge cells later, select the merged cell and click the Merge & Center arrow again, then choose Unmerge Cells. The content stays in the top-left cell, and the other cells reappear empty.
Merging for headers and titles
The most common use for merging is a title that spans the width of your data. For example, if you have a sales report with columns for Date, Product, and Amount, you might merge cells A1 through C1 and type "Q4 Sales Report" as the title. This makes the report easier to read and gives it a professional appearance.
Another common use is a category header. If you have columns for First Name, Last Name, and Email, you might merge cells A1 and B1 and type "Customer Name" above them, then put "Email" in C1. This groups related columns visually.
To create a title that spans your entire data range, select from the first column to the last column in row 1, then merge and center. Leave row 2 empty or use it for your actual column headers (Date, Product, Amount, and so on). This keeps your data organized and your report readable.
Combining text from multiple cells without merging
If you need to join text from different cells into one cell, merging is not the right tool. Instead, use a formula. The CONCATENATE function joins text together, or you can use the ampersand (&) operator, which does the same thing and is faster to type.
For example, if cell A1 contains "John" and cell B1 contains "Smith", you can create a full name in cell C1 by typing =A1&" "&B1. This creates "John Smith" in C1. The original cells stay separate and unchanged. If you later change A1 to "Jane", C1 automatically updates to "Jane Smith".
This approach is better than merging because the formula updates automatically if you change the source data, and it does not interfere with sorting or filtering. You can also add spaces, punctuation, or other text between the values.
Merging cells in different versions of Excel
The steps above work in Excel 2016, 2019, 2021, and Microsoft 365 (the subscription version). The Merge Cells button is always in the Alignment group on the Home tab.
In Excel Online (the free version you use in a web browser), the process is the same: select your cells, go to Home, find Merge & Center in the Alignment group, and click it. Excel Online has fewer formatting options than the desktop version, but merging works the same way.
In Google Sheets (a different spreadsheet program), merging is similar but in a different location. Select your cells, then go to Format menu, choose Merge Cells, and pick your merge type. The behavior is the same — the cells combine into one, and sorting and filtering can be affected.
Unmerging cells and fixing merged-cell problems
To unmerge cells, select the merged cell and click the Merge & Center arrow on the Home tab, then choose Unmerge Cells. The content stays in the top-left cell, and the other cells reappear as separate cells again.
If you inherited a spreadsheet with merged cells in the data area and you need to sort or filter, you have two options. First, unmerge all the cells in that area, then recreate your formatting without merging. Second, copy the data to a new sheet, unmerge it there, and work with the clean version. The second option is safer if the original sheet is important and you do not want to change it.
If a merged cell is causing an error or behaving strangely, unmerging is usually the fastest fix. Merged cells are a formatting choice, not a data choice, so removing them does not lose information — it just changes how the cells look.
Frequently Asked Questions
Does merging cells combine the numbers inside them?
No. Merging only combines the cell boxes, not the data. If you merge cells containing 5, 10, and 15, the result is a single cell containing only 5 (the content of the top-left cell). The 10 and 15 are deleted. To add numbers together, use a SUM formula instead.
Can I merge cells that are not next to each other?
No. You can only merge cells that form a rectangle — they must be adjacent and touch each other. If you need to combine data from cells that are far apart, use a formula like CONCATENATE or an ampersand (&) to join them instead.
Why does sorting stop working when I have merged cells?
Merged cells confuse Excel's sorting logic because a merged cell spans multiple rows or columns, but sorting expects each row to be a single unit. If your data area contains merged cells, Excel cannot sort reliably. Unmerge the data area and use merging only for headers and titles above your table.
What is the difference between merging and using Merge & Center?
Merge Cells keeps the content left-aligned in the merged area. Merge & Center centers the content. Both combine the cells the same way — the difference is only how the text appears. Choose based on what looks right for your report.
If I merge cells and then change my mind, will I lose the data?
You will lose the data from all cells except the top-left one. If you need that data, undo the merge when ready by pressing Ctrl+Z (or Cmd+Z on Mac). If you have already saved, copy the data from those cells before merging, or unmerge and restore the data manually.