To merge cells in Excel, select the adjacent cells, then choose Home > Merge & Center. Use the arrow beside that button to select a different merge option. Merging makes several cells act as one larger cell, which is useful for headings and labels, but Excel keeps only the value in the upper-left cell of the selection. Check the contents first so you do not lose data.
What You’ll Need
- A workbook open in Microsoft Excel for Microsoft 365 on Windows.
- A rectangular group of adjacent cells to merge. The cells can be empty or contain content, but only the upper-left cell’s content will remain after merging.
- Permission to edit the worksheet. If the sheet is protected, you may need the password or help from the workbook owner before you can change its layout.
The steps below cover Excel for Microsoft 365 on Windows. Excel for Mac has the same basic merge choices on the Home tab, though the ribbon layout can look a little different. Excel for the web also offers merge controls on the Home tab, but some dialogs and layout details differ from the desktop app.
Step-by-Step
- Decide what should remain in the merged cell. Review every cell in the area you want to combine. Excel retains the contents of the upper-left cell and removes contents from the other cells in the selection. If several cells have information you need, copy or combine that information elsewhere before proceeding. For example, if A1 contains a report title and B1 is empty, merging A1:B1 is straightforward. If both cells have text, save the second value before merging.
- Select the cells. Click the upper-left cell and drag to the lower-right cell to select a rectangular range, such as A1:D1. You can also click the first cell, hold Shift, and click the last cell in the range. For a heading that should span several columns, select the cells in that heading row only. Do not include adjacent rows unless you intend to combine them into the same large cell.
- Open the merge choices. On the ribbon, select Home. In the Alignment group, find Merge & Center. Click the main button to merge the selection and center its remaining content. To choose a different behavior, click the small arrow next to the button to open its menu. If the ribbon is collapsed, expand it or use the Home tab to locate the command.
- Choose the option that fits your layout. Select Merge & Center to create one cell and center the remaining content. Choose Merge Across to merge cells in each row of the selection separately; for example, selecting A1:C2 creates one merged cell across A1:C1 and another across A2:C2. Choose Merge Cells to create one merged cell without applying centered alignment. The currently selected text alignment may remain. These options do not combine the contents of all selected cells.
- Confirm any warning. If more than one selected cell contains data, Excel displays a warning that merging keeps only the upper-left value and discards the other contents. Cancel if you still need those values, then copy them elsewhere or combine them in a separate cell first. If you are sure the other contents are no longer needed, confirm the merge. If the selected cells are empty apart from the upper-left cell, Excel may merge them without showing the warning.
- Check the result and alignment. Look at the new merged area and confirm that the correct text or value is visible. If you used Merge & Center, the content should be centered horizontally. You can still adjust alignment, wrapping, font, fill, borders, and number format from the Home tab. A long heading may need Wrap Text or a taller row so the full wording can be read.
- Save the workbook. Save after checking the layout, especially if the workbook is shared or contains important information. If the result is wrong and you have not made later changes you want to keep, press Ctrl+Z on Windows to undo the merge. On Mac, press Command+Z. Undo is useful immediately after merging, but it is not a substitute for keeping a copy of valuable data before a change.
- Unmerge later if needed. Select the merged cell, return to Home > Merge & Center and open the dropdown, then choose Unmerge Cells. The original cells become separate again, but Excel does not restore the values that were discarded during the merge. The retained value is placed in the upper-left cell; other cells will generally be blank unless you fill them again.
On Excel for Mac, select the cells and use Home > Merge & Center or the adjacent dropdown, if shown. On Excel for the web, select the range and look for the merge control on the Home tab. If you cannot see the command, check whether the ribbon is collapsed, the worksheet is protected, or the selection includes an unsupported range. The exact placement can vary with window size and ribbon configuration.
Common Mistakes
Assuming a merge combines text. It does not join the contents of every selected cell. Only the upper-left cell is retained. If you need to keep multiple labels, put them in separate cells or combine them in another cell before merging. For example, you could copy each value into a temporary notes area, merge the heading cells, and then decide whether the values should be displayed together or remain in separate columns.
Merging a large block by accident. Dragging too far can select extra rows or columns. A selection such as A1:D4 merged with Merge & Center becomes one large cell, not four separate row headings. Check the highlighted range before choosing a command. If you intended one merged heading per row, use Merge Across and confirm the selection covers only the appropriate rows and columns.
Using merged cells in a data table. Merged cells can interfere with sorting, filtering, filling formulas, and selecting consistent ranges. They are usually better for presentation areas than for the rows and columns that store records. Excel does not allow merging cells inside a formatted Excel table. Keep the data area unmerged, and put a decorative heading above it instead.
Expecting unmerge to restore deleted information. Unmerge Cells separates the cells but cannot bring back values removed at merge time. Undo can restore the earlier state if you use it before other actions replace the undo history. If you have already saved or continued editing, check a backup or version history rather than assuming unmerge will recover the lost text.
Thinking the selection disappeared. After a merge, Excel treats the range as one cell for many actions. The merged area still spans the original rows and columns, but clicking within it selects the merged cell as a whole. This is normal behavior, not a sign that the other cells have been deleted from the worksheet.
Tips
Use Center Across Selection when you only need a centered heading. This alignment option makes text appear centered over several columns without actually joining the cells. Select the cells, press Ctrl+1 on Windows to open Format Cells, choose the Alignment tab, select Center Across Selection in the Horizontal list, and choose OK. On Mac, Command+1 opens Format Cells in many Excel configurations. The cells remain separate, so this approach is often friendlier to sorting and selecting data. It does not center the text vertically across multiple rows.
Reserve merging for labels and layouts. A title above a report, a section label, or a form heading can benefit from a merged area. For a row of actual records, keep one value per cell and use formatting such as bold text, fill color, borders, or centered alignment instead. Clear structure makes it easier to filter, sort, copy, and analyze the worksheet later.
Keep the selection simple. Merge works on a rectangular selection of adjacent cells. If you need separate merged headings for multiple groups, select and merge each group deliberately, or use Merge Across when every selected row should be merged independently. Inspect the result after using Merge Across because it applies the operation row by row, not as one large merge.
Adjust the row height after merging. A merged heading may not display all its text if the row is too short. Turn on Wrap Text, increase the row height, or shorten the heading. AutoFit can behave unexpectedly with merged cells, so manually adjusting the row height may be more reliable when a long title wraps.
Make a backup before restructuring a shared workbook. If other people rely on the sheet, check that a merge will not break their filters, formulas, or data-entry process. Save a copy or use the workbook’s version history before changing a complicated layout. Consider telling collaborators about merged headings that affect where they can paste or sort information.
Troubleshooting
The merge command is unavailable or disabled: Confirm that you selected cells on a single worksheet and that the sheet is not protected against formatting changes. If the workbook is in a restricted editing mode, ask for permission or save an editable copy if you are authorized. Also check that you have selected a normal rectangular range rather than a selection that includes incompatible areas. In Excel for the web, try expanding the ribbon or opening the workbook in the desktop app if the command is not visible.
Excel says it will keep only the upper-left value: That is expected whenever other selected cells contain content. Choose Cancel, copy the needed values to another location, and then merge. If your goal is to show two text entries together, join or arrange them before merging; the merge command itself will not concatenate them.
The text is not centered: The Merge Cells option does not necessarily apply centered alignment, and a previous alignment setting can affect how content appears. Open the Home tab and use the horizontal and vertical alignment controls. If the text is clipped, widen the merged area, turn on Wrap Text, or increase the row height.
Sorting or filtering stops working as expected: Check for merged cells within the data range. Unmerge them and return to a consistent layout with one record per row and one field per column. If you need a title, place it above the list rather than inside the table. If the cells are part of an Excel table, leave them unmerged; use table headers and cell formatting for structure.
Unmerge did not bring back all the original contents: Unmerging restores the separate cell positions, not values discarded when you merged. Immediately press Ctrl+Z on Windows or Command+Z on Mac if the merge is still the last action you want to reverse. Otherwise, look for a saved backup or a previous workbook version. Do not keep editing the affected area if you may need to recover an earlier version.
Frequently Asked Questions
Does merging cells delete data in Excel?
It can. Excel keeps the value in the upper-left cell of the selected range and removes contents from other cells in that range. Copy or preserve those values before confirming a merge if you need them.
Can I merge cells without centering the text?
Yes. Open the dropdown beside Home > Merge & Center and choose Merge Cells. This merges the selection without applying the centering associated with Merge & Center. You can also adjust alignment afterward.
Can I merge cells across several rows?
Yes, but choose the option that matches the result you want. Merge & Center or Merge Cells can turn the whole selected rectangle into one cell. Merge Across instead creates a separate merged cell for each row in the selection.
How do I merge cells without losing the other values?
Excel’s merge command cannot preserve multiple cell contents in separate positions inside one merged cell. Copy the values elsewhere first, or use Center Across Selection if you only need a heading to look centered across several cells while keeping those cells separate.
Why can’t I merge cells in an Excel table?
Excel tables require a consistent grid for sorting, filtering, and structured data, so cells inside a table cannot be merged. Keep table cells separate and place any merged title outside the table, or use formatting to distinguish the table’s heading.
Can I undo a merge after saving?
Unmerge Cells can separate the area, but it will not recover values that were discarded. If you still have the merge in the undo history, use Ctrl+Z on Windows or Command+Z on Mac. Otherwise, check workbook version history or a backup for the earlier contents.
Related
- Highlight in Excel Without a Mouse: Keyboard Steps
- Highlight in Excel Using Ctrl+F: Find and Mark Cells
- How to Highlight in Excel and Keep Gridlines Visible
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- How to Mail Merge in Word: Step-by-Step GuideTo mail merge in Word, prepare a recipient list in Excel, open Word and choose Mailings > Start…
- How to Make a Block Schedule in Google Sheets Step by StepTo make a block schedule in Google Sheets, set up a grid with days across the top and…
- Google Sheets VLOOKUP: Formula, Examples, and FixesIn Google Sheets, VLOOKUP searches for a value in the first column of a range and returns a…
- Excel Accounting Format: How It Works and When to Use It ProperlyExcel’s Accounting number format displays monetary values with currency symbols and decimal points aligned in a column; apply…
- How to Freeze Rows in Google Sheets: A Quick GuideTo freeze rows in Google Sheets in a web browser, open View > Freeze and choose 1 row…
- Create QR Codes in Word Mail MergeTo create a QR code for each recipient in a Word mail merge, insert a DISPLAYBARCODE field that…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.