Merging cells combines two or more cells into one larger cell

When you merge cells in Excel, you are combining adjacent cells — usually in the same row or column — into a single cell that spans the space of all of them. The merged cell displays whatever content was in the top-left cell of the group; Excel discards the content of the other cells you merged. This is useful when you want a title or label to stretch across multiple columns, or when you are building a layout where one piece of information needs more visual space than a single cell provides.

Merging is different from straightforward making a cell wider. A merged cell actually removes the cell boundaries between the cells you combine, so it behaves as one unit when you copy, move, or sort data. This matters because merged cells can cause problems if you later try to sort or filter your spreadsheet — Excel will either refuse to sort, or will sort unpredictably. For this reason, most spreadsheet experts recommend merging only in headers, titles, or labels, not in data rows you plan to sort.

Key Takeaways

  • Select the cells you want to merge by clicking the first cell and dragging to the last, or by holding Shift and clicking the last cell.
  • Go to the Home tab, find the Merge & Center button in the Alignment group, and choose Merge Cells from the dropdown menu.
  • Merged cells keep only the content from the top-left cell; Excel deletes the content of all other cells in the merge.
  • Avoid merging cells in rows you plan to sort or filter, because merged cells often cause sorting to fail or behave unexpectedly.
  • You can unmerge cells later by selecting the merged cell, opening the Merge & Center dropdown, and choosing Unmerge Cells.

How to select the cells you want to merge

Click on the first cell you want to include in the merge. Then hold down your mouse button and drag to the last cell in the group. Release the mouse. All the cells in between will highlight in blue, showing they are selected.

If dragging is awkward — for example, if the cells are far apart or you want to select a large block — use the keyboard instead. Click the first cell, then hold Shift and click the last cell. Excel will select everything in the rectangle between those two cells. This works whether the cells are next to each other or separated by several rows or columns.

The merge process in the Home tab

Once your cells are selected, look at the ribbon at the top of the screen and make sure you are on the Home tab. In the Alignment group — usually in the middle-right area of the ribbon — you will see a button labeled Merge & Center. Click the small arrow next to it to open a dropdown menu.

The dropdown shows three options: Merge Cells, Merge & Center, and Merge Across. Choose Merge Cells if you want to keep the content left-aligned. Choose Merge & Center if you want the content centered in the merged cell. Choose Merge Across only if you are merging cells in a single row and want each row to merge separately (this is rarely needed). After you click, the cells combine into one.

What happens to the content of the cells you merge

Excel keeps the content from the top-left cell of your selection and deletes the content of all other cells. If you select cells A1 through D1, and A1 contains "Sales Report" while B1, C1, and D1 contain other text, only "Sales Report" will appear in the merged cell. The other text is gone permanently.

For this reason, before you merge, check that the top-left cell contains the text you want to keep. If it does not, delete the merged cell, undo the merge (Ctrl+Z), move the text you want to the top-left position, and merge again. This is faster than trying to fix it after the merge.

Why merged cells cause problems with sorting and filtering

If you merge cells in a data row — for example, merging cells in row 5 across columns A through C — and then try to sort your spreadsheet, Excel will either refuse to sort at all, or will sort only part of your data. This happens because sorting expects each row to have the same structure: one cell per column. A merged cell breaks that structure.

Filtering has the same issue. If your header row contains merged cells, the filter buttons may not appear, or they may not work correctly. The safest approach is to use merging only in title rows or label rows that you will never sort. If you have already merged cells in a data range and need to sort, unmerge first, sort, and then merge again if you want.

How to unmerge cells

Click on the merged cell you want to split apart. Go to the Home tab, click the arrow next to Merge & Center, and choose Unmerge Cells. The merged cell will split back into its original separate cells. The content will remain in the top-left cell; the other cells will be empty.

If you unmerge and then want to redo the merge, you can use Ctrl+Z to undo the unmerge. This is useful if you unmerge by accident or change your mind about the layout.

When merging cells makes sense and when it does not

Merge when: You are creating a title that spans multiple columns at the top of a sheet. You are labeling a section of data with a heading that should visually stretch across that section. You are building a form or template where the layout matters more than sorting.

Do not merge when: The cells are part of a data table you plan to sort or filter. You are working with a spreadsheet that other people will edit or add data to. You are building a summary or analysis sheet where the data structure needs to stay consistent. In these cases, use column width or text alignment instead to achieve the visual effect you want.

Frequently Asked Questions

Can I merge cells that are not next to each other?

No. Excel only merges adjacent cells — cells that touch each other in a rectangle. If you select cells A1, C1, and E1 (skipping B1 and D1), Excel will not merge them. You must select a continuous block.

What happens if I merge cells and then add more data to the sheet?

The merged cell stays merged. If you add new rows below it, those rows are not affected. If you insert a new row inside the merged cell, Excel will unmerge the cell to make room for the new row, then ask whether you want to keep the content or delete it.

Can I merge cells in different columns and rows at the same time?

Yes. You can select a block that spans multiple rows and columns — for example, A1 through D5 — and merge them all into one large cell. The content from A1 will appear in the merged cell, and all other content will be deleted.

Why does Excel warn me about merged cells when I try to sort?

Excel detects that your data range contains merged cells, which breaks the row-by-row structure that sorting needs. The warning is telling you that the sort may not work as expected. Unmerge the cells, sort, and then merge again if you need to.

Is there a way to merge cells without losing the content of the other cells?

Not directly. If you need to keep the content, copy it to another location first, or combine it manually into the top-left cell before merging. After you merge, you can edit the merged cell to include all the text you want.