What merging cells does and when you need it
Merging cells combines two or more adjacent cells into a single larger cell. When you merge cells, Excel treats them as one cell for display purposes — the content appears centered across the merged area, and the cell reference becomes the top-left cell of the merged range.
You merge cells most often to create titles that span multiple columns, to label sections of a spreadsheet, or to make headers that align with grouped data below them. For example, if you have sales data for three regions across columns B, C, and D, you might merge cells B1 through D1 and type "Sales by Region" so the title sits above all three columns instead of cramped in one cell.
Merging is a formatting choice — it changes how the spreadsheet looks on screen and in print, but it does not change how Excel calculates or stores the data. The merged cell still holds only the content from the original top-left cell; any text in the other cells you merge gets deleted unless you copy it first.
Key Takeaways
- Merging cells combines multiple cells into one larger cell, and Excel deletes any content in the cells being merged except the top-left cell.
- The simplest way to merge is to select the cells you want to combine, then use the Merge & Center button in the Home tab of the ribbon.
- You can merge cells without centering the content, or merge cells while keeping the data in all of them by using Merge Across instead of standard merge.
- Unmerging cells returns them to separate cells, and the content stays in the top-left cell of what was merged.
Select the cells you want to merge
Click on the first cell in the range you want to merge. If you are merging cells B2 through D2 to create a title row, click on cell B2.
Hold down the left mouse button and drag to the last cell you want to include, or click on the first cell, then hold Shift and click on the last cell. Either method selects the entire range. You will see the selected cells highlighted in blue.
You can merge cells in a row (B2 through D2), in a column (B2 through B5), or in a rectangular block (B2 through D5). Excel does not merge cells that are not adjacent to each other.
Use the Merge & Center button to combine the cells
With your cells selected, look at the Home tab in the ribbon at the top of the screen. On the right side of the Alignment section, you will see a button that looks like a small grid with lines — this is the Merge & Center button. Click the small arrow next to it to see your options.
Click Merge & Center to merge the cells and center the content horizontally across the merged area. This is the most common choice for titles and headers. The text from the top-left cell moves to the center of the merged cell, and any content in the other cells is deleted.
If you want to merge without centering — for example, to keep text aligned to the left — click the arrow next to Merge & Center and select Merge Cells instead. The content stays left-aligned within the merged area.
What happens to your data when you merge
When you merge cells, Excel keeps only the content from the top-left cell in the range. If you have text or numbers in the other cells you are merging, that content is deleted. Excel will warn you before this happens — a dialog box appears asking whether you want to continue. Click OK to proceed, or click Cancel to stop.
To keep data from cells you are about to merge, copy that data to another location first, or type all the content you want into the top-left cell before merging. For example, if you want to merge B2 through D2 and keep text from all three cells, type all the text into B2 first (separated by line breaks or spaces as you prefer), then merge.
The cell reference for a merged cell is always the top-left cell of the merged range. If you merge B2 through D2, the merged cell is called B2, and any formula that refers to it uses B2.
Merge cells across columns without losing data
If you want to merge cells but keep the content from each cell visible, use Merge Across instead of standard merge. This option is useful when you have data in multiple cells that you want to display together without losing any of it.
Select your cells, click the arrow next to Merge & Center, and choose Merge Across. This merges the cells but preserves the content from each cell — each piece of content stays in its original position within the merged area. This works best when each cell contains a small amount of text or a single value.
Merge Across is less common than standard merge because it can make the spreadsheet harder to read if the content is not carefully organized. Use it when you specifically need to display multiple values side by side within a merged area.
Unmerge cells to separate them again
To reverse a merge and return cells to separate cells, select the merged cell (or any part of it), click the arrow next to Merge & Center, and choose Unmerge Cells. The cells separate when ready, and the content stays in the top-left cell of what was merged.
Unmerging does not restore content that was deleted when you originally merged. If you merged B2 through D2 and the original content in C2 and D2 was deleted, unmerging will not bring that content back. The text or numbers will still be in B2 only.
Common problems when merging cells
The most frequent issue is that merged cells can cause problems with sorting and filtering. If you have a merged cell in a data range and try to sort by that column, Excel may not sort correctly or may show an error. To avoid this, do not merge cells within data ranges — only merge cells in header rows or title areas above your actual data.
Another common problem is that merged cells in a column can make it hard to see all your data. If you merge cells vertically (for example, B2 through B5), the merged cell takes up space for four rows but displays content as if it were one row. This can make the spreadsheet confusing to read. Use vertical merges sparingly, and only when the merged content applies to all the rows below it.
If you are working with a spreadsheet that someone else created and you see merged cells, be careful when inserting or deleting rows and columns near them. Merged cells can shift unexpectedly, and you may accidentally delete more data than you intended.
Frequently Asked Questions
Can I merge cells that are not next to each other?
No. Excel only merges cells that are adjacent — touching each other in a continuous row, column, or rectangle. If you select cells that are separated (for example, B2 and D2 with C2 not selected), the Merge & Center button will not work.
What happens to formulas in cells I merge?
If the top-left cell contains a formula, that formula stays in the merged cell and continues to calculate. If any other cell in the merge range contains a formula, that formula is deleted. Copy formulas to a safe location before merging if you need to keep them.
Can I merge cells in different rows and columns at the same time?
No. You can only merge one rectangular block of cells at a time. If you want to merge multiple separate areas, you must do each one individually — select the first range, merge it, then select the next range and merge that.
Does merging cells change how Excel stores the data?
No. Merging is purely a display change. The data itself is stored the same way, and formulas that reference the merged cell work normally. Unmerging the cells does not affect any calculations or other cells that depend on the merged cell.
Why does my merged cell look misaligned when I print?
Merged cells sometimes print differently than they appear on screen, especially if the column widths are very narrow or very wide. Adjust the column width to match the content, and preview your print before printing to see how it will look on paper.