Merge 2 Cells in Excel: A Step-by-Step Guide

To merge two cells in Excel, select the adjacent cells, then choose Home > Merge & Center ▼ > Merge Cells. This combines them into one larger cell. Excel keeps only the value in the upper-left cell, so check both cells first if either contains information you need.

Merging is useful for creating a heading across columns or making a label span several rows. It changes the worksheet layout; it does not join the contents of two cells into one text string. If you want to keep both values, use a formula or place the combined text in another cell instead.

What You’ll Need

A workbook open in Microsoft Excel for Microsoft 365 on Windows. The same basic ribbon command is available in Excel for Mac and Excel for the web, though the layout may look slightly different.
Two adjacent cells in the same worksheet. They can be side by side or one above the other, but they must form a single rectangular selection.
A copy of any important data in the second cell if you may need it later. Merging can discard that cell’s content, and unmerging does not bring it back.

Step-by-Step

Check what is in both cells. Click each cell and look at its value in the formula bar, or read the displayed contents. Excel retains the content in the upper-left cell of the selected range and removes the contents of the other cell or cells. For two cells side by side, the left cell is the upper-left one. For two cells stacked vertically, the top cell is the upper-left one. Copy any value you want to keep somewhere safe before continuing.
Select exactly the two cells. Click the first cell and drag to the adjacent cell, or click the first and then Shift-click the second. You can also click the first cell and hold Shift while pressing an arrow key toward the other cell. Confirm that the selection covers only the two cells you intend to combine. A selection of three or more cells will merge the whole selected range, not just one pair.
Open the merge options. On the Windows ribbon, select the Home tab. In the Alignment group, find Merge & Center. Select the small arrow beside that button to open its menu. If the ribbon is collapsed, expand it or use the Home tab to make the command visible. In Excel for Mac, use the Home tab and the Merge & Center menu; in Excel for the web, use the Home tab and its merge control.
Choose Merge Cells. Click Merge Cells in the menu. This merges the selected cells without asking Excel to center the remaining content. If both selected cells contain data, Excel may show a warning that only the upper-left value will be kept. Read it carefully and choose the option to continue only if losing the other cell’s contents is acceptable. Cancel if you need to copy or combine that content first.
Check the result. The selection should now appear as one larger cell spanning the original two cells. Click it and check the formula bar to confirm which value remains. If the text is not positioned the way you want, use the horizontal and vertical alignment controls in Home > Alignment. Merging does not automatically mean the text must be centered when you choose Merge Cells.
Adjust the appearance if needed. You can change the merged cell’s alignment, font, fill, border, or row height using the usual Home tab controls. If the text looks cut off, widen the column or increase the row height. A merged cell can span columns or rows, but Excel still treats it as one cell for many editing and layout tasks.
Save the workbook. Save after checking the merged cell and any nearby headings or data. If you are working in a shared or important workbook, make sure the change is appropriate for the people who use it. Merged cells can affect sorting, filtering, copying, and future editing, so keep the original layout or a backup if those tasks matter.

Example: If A1 contains a report title and B1 is empty, selecting A1:B1 and choosing Merge Cells makes one cell spanning columns A and B, with the title from A1 retained. If B1 contains a date, that date is not appended to the title; it is removed from the worksheet cell when the range is merged. Copy it elsewhere before merging if you need it.

Common Mistakes

Expecting Excel to combine the text. Merge Cells combines the cell area, not the contents. Excel does not turn values such as North and Region into North Region. Copy or combine text separately before merging if you need both values.
Merging without checking the second cell. A cell can contain a value even if it looks blank because of its formatting, a narrow column, or a formula that displays an empty result. Check the formula bar before merging. Excel normally warns when a non-empty cell would be discarded, but do not rely on a warning as your only check.
Selecting the wrong range. If you accidentally select a larger block, Excel merges that entire block into one cell. Undo immediately with Ctrl+Z on Windows or Command+Z on Mac, then select the intended pair. Verify the highlighted outline before choosing the command.
Using Merge & Center when you only want a merge. The main button merges and centers the content. If you want the text to stay left-aligned, use the menu arrow and choose Merge Cells, then set alignment separately if necessary.
Assuming Unmerge restores deleted data. Unmerge Cells separates the merged area back into individual cells, but it does not restore values that were removed during the merge. Undo is the best immediate way to reverse a merge and recover the original contents; after closing or saving other edits, restore missing information from a backup or source.
Merging cells in a data table. Excel does not allow merged cells inside a formatted Excel table. Merging can also make regular data ranges harder to sort, filter, select, or paste into. Reserve merges for presentation areas such as titles rather than rows of records.

Tips

Use a merge for a heading, not as a substitute for a data layout. A heading spanning several columns is a common, practical use. Avoid merging cells within a list where each row represents a record, because sorting and filtering work best when every row has the same independent columns.
Keep the original value outside the merge if it matters. Before merging, copy the second cell to an unused cell, another sheet, or a separate workbook. For a workbook that others will edit, leave a note or preserve a source copy so the reason for the layout is clear.
Try Center Across Selection for a centered heading. If you need a heading to look centered across columns but want to avoid creating a merged cell, select the range, open the Format Cells dialog, choose the Alignment tab, and set Horizontal to Center Across Selection. This keeps the cells separate, which can be more convenient for later sorting and editing. The heading text should be in the leftmost cell of the selected range.
Use alignment controls after merging. The menu choice affects alignment. Merge & Center centers text horizontally, while Merge Cells keeps the existing horizontal alignment. Use the vertical alignment buttons on the Home tab if the text sits too high or low in a taller merged area.
Make the merged area large enough for its content. Excel’s AutoFit behavior can be awkward with merged cells. If text is clipped, adjust the column widths or row height manually. For long text, consider turning on Wrap Text and checking the row height after the merge.
Remember the keyboard undo shortcut. If you merge the wrong range or lose a value, press Ctrl+Z on Windows or Command+Z on Mac as soon as possible. Undo can reverse the operation, but it is not a replacement for a backup if you have made further changes or closed the workbook.

Troubleshooting

The merge option is disabled. Check whether the selected cells are inside an Excel table. Table cells cannot be merged; select a cell in the table and use Table Design > Convert to Range only if you are sure you no longer need the table features. Also check whether the worksheet is protected. If you have permission, use Review > Unprotect Sheet, then try again. A workbook’s sharing or editing restrictions may also prevent changes.

Excel says only the upper-left value will be kept. This warning means another selected cell contains something Excel would remove. Choose Cancel, copy the value elsewhere, or combine the information in a separate cell before retrying. If you proceed, the contents of the other selected cell will not be preserved by the merge.

The text disappears after merging. Click the merged cell and inspect the formula bar. The value may be present but hidden because the font color matches the fill, the column is too narrow, the row is too short, or the alignment places it outside the visible area. Adjust the formatting or dimensions. If the formula bar is empty, use Undo if available or recover the value from a backup.

The cells do not merge as expected. Make sure the selection is a contiguous rectangle. Excel cannot merge separated cells such as A1 and C1 while leaving B1 out. Select adjacent cells, or merge separate ranges one at a time. If the result spans more cells than intended, undo and select the exact two-cell range again.

Sorting or filtering becomes difficult afterward. Merged cells may block operations when a range has inconsistent merged areas. If the merged cell is part of a data region, undo the merge or unmerge it and use a layout that keeps one value per cell. For a heading, move it above the sortable range so the records remain unmerged.

You are using Excel for Mac or the web. The command is still on the Home tab, but its position or menu appearance can vary with window size and ribbon layout. Expand the ribbon and look for the Merge & Center control. If you cannot find it, use the application’s command search where available and search for Merge Cells.

Frequently Asked Questions

Does merging two cells combine their text?
No. Excel keeps the value from the upper-left cell and removes the contents of the other selected cell. To preserve both values, copy them elsewhere or combine them separately before merging.

Can I merge two cells that are not next to each other?
No. A merge selection must be one continuous rectangular range. To create a single merged area, select adjacent cells; separated cells cannot be merged while skipping the cells between them.

How do I merge two cells without centering the text?
Open the arrow menu beside Home > Merge & Center and choose Merge Cells. That merges the selection without applying the button’s centering behavior. You can then choose the alignment you want.

How do I undo a cell merge?
Select the merged cell, open the Merge & Center menu, and choose Unmerge Cells. This restores the individual cell boundaries but does not restore content that was discarded. To reverse the merge and recover the original values, use Undo promptly.

Can I merge cells in an Excel table?
No. Excel does not support merged cells within a formatted table. Keep the table cells separate, or convert the table to a normal range if appropriate and then merge cells outside any structured data area.

Can I merge cells in Excel for Mac or Excel for the web?
Yes. Both provide a merge command on the Home tab. The ribbon may look different from Excel for Windows, but the essential steps are the same: select adjacent cells, open the merge options, choose the appropriate merge command, and check which value remains.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.