Merging cells combines multiple cells into one larger cell
When you merge cells in Excel, you combine two or more adjacent cells into a single cell. The merged cell spans the width or height of all the cells you selected. Excel keeps the content from the top-left cell and discards the content from the other cells, so you lose data if those cells contain information.
Merging is useful when you want a title to stretch across several columns, or when you're formatting a header row. It's purely visual — it doesn't change how Excel calculates or stores data. If you later unmerge the cells, only the original top-left content returns.
The process takes three steps: select the cells you want to merge, open the Merge Cells menu, and choose your merge option. Excel offers different merge styles depending on what you're trying to do.
Key Takeaways
- Merging combines multiple cells into one larger cell, keeping only the content from the top-left cell and deleting the rest.
- You select adjacent cells, then use the Merge Cells button in the Alignment group on the Home tab to combine them.
- Excel offers four merge options: merge all cells, merge across (by row), merge down (by column), and merge without losing data by using a formula instead.
- Unmerging returns the cells to their original separate state, but only the top-left content survives the merge.
- For keeping data from multiple cells, use concatenation with the ampersand (&) or CONCATENATE function instead of merging.
How to select and merge cells step by step
Start by clicking on the first cell you want to merge. Then hold Shift and click on the last cell in the range you want to combine. This selects all the cells between them. Make sure the cells are adjacent — they must form a rectangle with no gaps.
Once your cells are selected, go to the Home tab at the top of the ribbon. In the Alignment group (toward the right side of the ribbon), click the Merge & Center button. A dropdown menu appears with four options: Merge & Center, Merge Across, Merge Down, and Merge Cells. Choose the option that fits what you're doing. If you just want to merge without centering the text, click Merge Cells instead of Merge & Center.
Excel will when ready combine your selected cells. The merged cell takes the address of the top-left cell in your selection. Any content in the other cells disappears.
The four merge options and when to use each one
Merge & Center combines all selected cells into one and centers the text horizontally and vertically. Use this for titles and headers that should stand out. It's the most common choice for spreadsheet headers that span multiple columns.
Merge Across merges cells in each row separately, rather than combining all cells into one. If you select cells A1:C2 and choose Merge Across, Excel creates two merged cells: one spanning A1:C1 and another spanning A2:C2. This is useful when you have multiple rows of headers that each need to span several columns.
Merge Down merges cells in each column separately. If you select A1:A3 and choose Merge Down, Excel combines them into a single tall cell. Use this when you want a label to run vertically down several rows.
Merge Cells combines all selected cells without centering. The text stays left-aligned and top-aligned. Choose this when you want the merged appearance but don't want automatic centering.
Why merging can cause problems with your data
Merged cells create issues when you sort, filter, or copy data. Excel's sorting and filtering features don't work reliably on merged cells because the program expects each row to have the same structure. If some cells are merged and others aren't, Excel may skip rows or produce unexpected results.
Merged cells also cause problems when you're trying to move or copy data. If you copy a merged cell and paste it elsewhere, Excel may not paste it as merged, or it may merge cells in unexpected ways. Formulas that reference merged cells can behave unpredictably.
For these reasons, many spreadsheet experts recommend avoiding merges in data tables. Use merges only for titles, headers, and labels — not for cells that contain actual data you'll analyze or reorganize later.
Using formulas to combine text instead of merging cells
If you need to combine content from multiple cells without losing the original data, use a formula instead of merging. The simplest method is the ampersand (&) operator. Type a formula like =A1&" "&B1 in a new cell, and Excel combines the content of A1 and B1 with a space between them.
For more control, use the CONCATENATE function. The formula =CONCATENATE(A1," ",B1) does the same thing as the ampersand method but is easier to read when you're combining many cells. In newer versions of Excel, the CONCAT function works the same way but with simpler syntax.
This approach keeps your original data intact in separate cells while displaying combined text in a new cell. It also works reliably with sorting, filtering, and other Excel features. If you later need to change one of the original values, the combined text updates automatically.
How to unmerge cells and get your data back
To unmerge cells, select the merged cell and go to the Home tab. Click the Merge & Center dropdown and select Unmerge Cells. Excel when ready splits the merged cell back into its original separate cells.
When you unmerge, only the content that was in the top-left cell before the merge returns. Any content that was in the other cells is gone permanently — unmerging doesn't restore it. If you need that data back, you'll have to retype it or undo the merge when ready after you created it.
This is why it's important to check what data is in each cell before you merge. If cells contain important information, copy that information somewhere else first, or use a formula to combine the text instead of merging.
Common mistakes when merging cells in Excel
The most common mistake is merging cells that contain data you need to keep. Once you merge, the data in all but the top-left cell is deleted. Always check what's in each cell before you merge, and copy important information to another location first if you're unsure.
Another mistake is merging cells in the middle of a data table. If you have a table with headers in row 1 and data in rows 2 and below, don't merge cells in the data rows. This breaks sorting, filtering, and formulas that reference the table. Merge only the header row if you need to.
A third mistake is merging cells and then trying to use them in a formula. Formulas can reference merged cells, but the results are often unexpected. If you need to combine data from multiple cells, use a formula in a separate cell instead of merging the original cells.
Frequently Asked Questions
Can I merge cells that aren't next to each other?
No. Excel only merges adjacent cells that form a rectangle. If you select cells that aren't touching, the Merge Cells button will be grayed out. You must select a continuous block of cells with no gaps.
What happens to formulas in cells I merge?
If the cells you're merging contain formulas, Excel keeps only the formula from the top-left cell and deletes the formulas in the other cells. The merged cell displays the result of the top-left formula. If those formulas were calculating important values, you'll lose that data.
Can I merge cells and still sort my data?
Sorting doesn't work reliably on tables with merged cells. Excel may skip rows, produce unexpected results, or refuse to sort at all. If you need to sort data, unmerge the cells first. Use merges only for headers and labels, not for data you plan to sort or filter.
How do I center text in a cell without merging?
Select the cell, go to the Home tab, and click the Center button in the Alignment group. This centers the text within the cell without merging. You can also right-click the cell, choose Format Cells, go to the Alignment tab, and set the horizontal alignment to Center.
Is there a keyboard shortcut for merging cells?
Excel doesn't have a built-in keyboard shortcut for merging. You must use the Merge & Center button on the Home tab or access it through the Format menu. If you merge cells frequently, you can create a custom keyboard shortcut through Excel's options, but this requires setup in the program settings.