To enable Merge & Center in Excel, select a normal, contiguous range of at least two cells, exit cell-edit mode, and check that the sheet is not protected and the selection is not inside a table or PivotTable. Then choose Home > Merge & Center. Before merging, move any information you want to keep into the upper-left cell: Excel keeps that cell’s contents and removes contents from the others.
What You’ll Need
- Access to the workbook in Excel for Microsoft 365 on Windows, with permission to change the worksheet.
- A clear idea of which cells should become one. Merging changes the layout and can affect sorting, filtering, copying, and formulas that refer to the affected cells.
- A backup copy if the workbook contains important data or you are unsure what a merge will remove. Use File > Save As to make a separate copy before editing.
The steps below apply to Excel for Microsoft 365 on Windows. On Mac, the same checks and the Home tab’s Merge & Center control generally apply; use the ribbon rather than Windows Alt key sequences. Excel for the web also has merge controls on Home, though some workbook editing options depend on the file and your permissions.
Step-by-Step
- Check that Excel is not editing a cell. If you see a text cursor in the cell or formula bar, Excel is in edit mode and some ribbon commands may be unavailable. Press Enter to commit the edit, or Esc to cancel it. Click the cell once afterward so it is selected rather than being edited.
- Select a single rectangular range containing two or more adjacent cells. Click the first cell and drag to the last, or click the first cell, hold Shift, and click the last. You can also enter a range such as A1:C1 in the Name Box to the left of the formula bar and press Enter. A selection of one cell, separate nonadjacent cells, or multiple separate ranges is not a suitable merge selection. If you intend to merge across several rows and columns, select one continuous rectangle.
- Make sure the selection is on one worksheet only. Look at the sheet tabs. If several tabs appear selected, the worksheets are grouped, and some commands may be unavailable or apply across sheets. Right-click a selected tab and choose Ungroup Sheets, or click a single unselected worksheet tab. Check the workbook carefully before making changes because grouped-sheet edits can affect every selected sheet.
- Check whether the cells are part of an Excel table. Click one of the selected cells and look for a Table Design tab on the ribbon. Excel does not allow merged cells inside a formatted table. If you have permission and no longer need the table’s structured features, click in it and choose Table Design > Convert to Range, then confirm. The table formatting may remain, but features such as automatic expansion and structured references will no longer work as table features. If you need the table, leave it intact and put the heading in a normal cell above it instead.
- Check for a PivotTable or other restricted layout. If the range is inside a PivotTable, Excel controls its layout and does not let you merge its cells. Do not convert or rearrange the PivotTable just to enable a merge unless you understand the effect on its report. Place a heading in a normal cell outside the PivotTable, or use formatting that centers text without merging where available.
- Check worksheet protection. On the Review tab, look for Unprotect Sheet. If that command is available, select it and enter the password if prompted. If you do not know the password, ask the workbook owner or administrator to make the change; do not try to bypass protection. After authorized unprotection, select the cells again and check the merge control. Workbook structure protection and worksheet protection are different: the restriction on editing cells is usually worksheet protection.
- Open the merge menu and choose the right action. Go to Home > Merge & Center and open its dropdown. Choose Merge & Center to combine the selection and center the remaining content, Merge Cells to combine without centering, or Merge Across to merge each selected row separately. The main button may show the last-used option, so use the dropdown to confirm what you are choosing.
- Confirm the result and check the data. If Excel warns that only the upper-left value will be kept, stop if any other selected cell contains information you need. Cancel, copy those values elsewhere, or combine them into the upper-left cell before trying again. Once merged, verify the displayed text, alignment, row height, and column width. Use Home > Merge & Center > Unmerge Cells if you need to reverse the layout; unmerging does not restore values discarded during the original merge.
If the selection is valid and none of these restrictions applies, click another cell and reselect the range, then look again at Home > Merge & Center. A fresh selection can clear a temporary ribbon state. If the command is still grey, save the workbook, close and reopen it, and repeat the checks before changing the file format or removing features.
Common Mistakes
- Expecting every selected value to survive. A merge is not a way to combine cell contents. Only the upper-left cell’s contents are retained; values or formulas in the other cells are removed. Copy or join needed content before merging.
- Selecting cells that only look adjacent. The selected range must be one continuous rectangle. Selecting A1 and C1 with Ctrl, for example, creates separate selections rather than a mergeable range. Select A1:C1 if that is what you mean.
- Trying to merge inside a table. Table cells cannot be merged, even if the merge command seems appropriate for a heading. Keep the heading outside the table or convert the table to a normal range only if its table features are no longer needed.
- Confusing cell formatting with worksheet protection. Changing font, fill, or number format settings does not remove sheet protection. Use Unprotect Sheet only when you are authorized and have the password.
- Assuming unmerge restores the original cells. Unmerge returns the range to separate cells, but does not put deleted values back into them. Undo may reverse a recent merge immediately, but it is not a reliable recovery method after other edits or reopening the file.
Tips
For a heading above a list or table, consider leaving the cells separate and centering the heading across them. In desktop Excel, select the range, open Format Cells with Ctrl+1 on Windows, choose the Alignment tab, and set Horizontal to Center Across Selection. This gives a centered appearance without creating a merged cell, which is often easier to sort, filter, copy, or use in formulas. On Mac, open Format Cells from the menu or the Home tab’s alignment options; the exact dialog access can vary by ribbon layout. This option is not the same as Merge & Center, and may not be available in Excel for the web.
Use Merge Across when you want one merge per row rather than one large merged block. For example, selecting A1:C3 and choosing Merge Across combines A1:C1, A2:C2, and A3:C3 separately. It does not merge all nine cells into one. For a large or shared workbook, agree on the layout with other editors first. Merged cells can make it harder to select ranges consistently and can interfere with sorting or pasting.
If the text is clipped after a merge, try Home > Wrap Text and adjust the row height or column widths. Excel may not automatically size a row the way you expect when merged cells are involved. A merge also does not make text fit automatically; use a sensible column width and alignment, or choose a non-merged layout if readability suffers.
Troubleshooting
The command is still grey after selecting several cells. Confirm that the selection is one contiguous range on one worksheet, and that you are not editing a cell. Then check for a table, PivotTable, or protected sheet. These are more likely explanations than a problem with the ribbon itself. If the workbook is read-only or you have view-only access, request edit permission or save an editable copy if your organization allows it.
Unprotect Sheet is unavailable, or Excel asks for a password. The sheet may not be protected, or you may not have permission to change its protection. If the file is controlled by someone else, contact its owner. Do not remove protection from a workbook you are not authorized to edit. If the sheet is protected but the cells are otherwise editable, the owner may need to change the protection settings or perform the merge.
The cells are in a table and converting it is not an option. Keep the table as a table. Put the label in a regular worksheet row above or beside it, or use Center Across Selection in desktop Excel. If the table is part of a report, check that moving the heading will not break references or the report layout.
The merge works, but information appears to have disappeared. Stop editing and use Ctrl+Z on Windows immediately if the merge was the last action. On Mac, use Command+Z. If you have already made other changes, check Version History for a recoverable earlier version (availability depends on where the file is saved), or restore your backup. Unmerging alone will not recover cleared contents.
The option works in one workbook but not another. Compare the worksheet conditions rather than assuming Excel is broken. One file may contain a table, a protected sheet, grouped tabs, a PivotTable, or editing restrictions. If the workbook uses the older Shared Workbook feature, it can also restrict certain editing actions; coordinate with the owner before changing sharing settings. Modern coauthoring in Microsoft 365 is not the same as that older feature.
Frequently Asked Questions
Why is Merge & Center greyed out in Excel?
Common causes include selecting only one cell or a noncontiguous range, editing a cell, having multiple sheets grouped, selecting cells inside a table or PivotTable, or working on a protected sheet. Check those conditions in that order and make a fresh rectangular selection.
Can I merge cells without deleting the other values?
Not while keeping separate values in the merged cells. Excel retains the upper-left cell’s contents and removes the others. Copy the values somewhere safe or combine them into one cell before merging. If you only want centered text, use Center Across Selection in desktop Excel instead.
How do I merge cells in Excel for Mac?
Select adjacent cells, then use the Home tab’s Merge & Center dropdown and choose the desired merge option. Check for the same restrictions as on Windows: tables, PivotTables, protection, grouped sheets, and cell-edit mode. Windows Alt key sequences do not apply on Mac.
Can I merge cells in Excel for the web?
For a supported editable worksheet, select the range and use Home > Merge & Center. If the control is unavailable, check the selection, protection, and table or PivotTable restrictions. Some features and permissions differ from desktop Excel; open the workbook in the desktop app if the web version does not expose the needed control.
What is the difference between Merge Cells and Merge & Center?
Both combine the selected cells and keep only the upper-left content. Merge & Center also centers that content horizontally. Merge Cells combines the cells without applying that centering. Use the dropdown to choose the behavior you want.
Will unmerging bring back the removed cell contents?
No. Unmerge Cells separates the area again but does not restore values that were discarded when it was merged. Use Undo immediately after the merge or recover an earlier saved version or backup if the missing information matters.
Related
- Remove Duplicates in Excel by Entire Row: A Safe Guide
- Remove Duplicates in Excel: A Clear Step-by-Step Guide
- Clean Excel Rows: Remove Blanks, Duplicates, and Errors
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Microsoft Excel Group Rows: How It Works and When to Use ItTo group rows in Microsoft Excel for Microsoft 365 on Windows, select the row numbers you want to…
- How to Double Space in a Word Document in Microsoft WordTo double-space text in Microsoft Word, select the text, then choose Home > Line and Paragraph Spacing >…
- Excel: Copy Subtotal Rows Only Without Detail RowsYes. In Excel for Microsoft 365 on Windows, collapse the outline to level 2, select the range you…
- Date Formula in Google Sheets: Dates, Days, and UsesThe basic date formula in Google Sheets is =DATE(year, month, day). For example, with the year, month, and…
- How to Copy Format in Excel Without Copying Cell DataTo copy only the appearance of cells in Excel, select the formatted cell, choose Home > Format Painter,…
- Create a Yes/No Drop-Down in Excel: Setup, Tips & FixesTo create a Yes/No drop-down in Excel for Microsoft 365 on Windows, select the cells, choose Data >…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.