Yes—Excel can merge cells, but the command may be unavailable if the selection is in a table, the sheet is protected, or the selected cells are not one continuous rectangle. In Microsoft 365 for Windows, select the cells, open Home > Merge & Center, and choose the merge option you want; first check that any information outside the top-left cell is safe, because merging can remove it.
Start with the right merge command
Select a rectangular block of adjacent cells, such as B2:D2, then go to Home > Alignment > Merge & Center. Use the dropdown beside the button to choose an action:
- Merge & Center combines the selected cells and centers the remaining content.
- Merge Across merges cells across each row of a selection. Selecting B2:D3 creates one merged cell in row 2 and another in row 3.
- Merge Cells combines the selection without applying centered alignment.
- Unmerge Cells separates a previously merged cell back into individual cells.
If the button is visible but greyed out, don’t keep clicking it: check the causes below. If the command is missing from a compact ribbon, widen the Excel window or look in the Alignment group’s dropdown. Excel for Mac has the merge commands on the Home tab as well, though the ribbon layout can differ.
Why Merge Cells may be unavailable
Most cases have a specific selection or worksheet restriction. Check these before changing the workbook’s layout:
- The selection is not a single rectangular range. Excel cannot merge two separate selections at once. Click one cell and drag across one continuous rectangle, or select the range by entering its address in the Name Box.
- You are editing a cell. If the cursor is inside a cell or the formula bar, press Enter to finish editing or Esc to cancel, then select the range again.
- The cells are inside an Excel table. Tables do not support merged cells within their table area. This is a frequent reason the command is disabled.
- Sheet protection prevents formatting changes. A protected worksheet may block merging if formatting cells is not allowed.
- You selected cells on different worksheets or used a multi-area selection. Merge a range on one sheet at a time.
Also confirm that you are selecting cells rather than a chart, shape, or other object. If the worksheet is read-only, you may be able to inspect the ribbon but not save changes; make an editable copy or ask the workbook owner for access.
Cells inside a table cannot be merged
Excel tables are designed to keep a consistent grid for sorting, filtering, and working with rows of records. A merged cell breaks that grid, so Excel does not allow you to merge cells inside a table. If the selected cells are part of a table, the merge command may be disabled even when the selection looks like ordinary worksheet cells.
To check, select a cell in the area. If a Table Design tab appears on the ribbon, it is part of a table. If you truly need merged cells, select a table cell and choose Table Design > Convert to Range, then confirm the prompt. The data remains on the sheet, but the range no longer has table features such as automatic filter controls and table-style behavior. Consider whether that trade-off is worthwhile: sorting and filtering work more reliably when each record remains a normal, unmerged row.
For a title above a table, put the title in a row outside the table and merge cells there if needed. Avoid inserting a merged title row into the table’s data area.
Check worksheet protection
Protection settings can limit what users may change. On Windows, go to Review > Unprotect Sheet. If the sheet has a password, Excel will ask for it; you need the password or help from the workbook owner to remove protection. Sheet protection is intended to restrict edits, not to serve as a secure way to encrypt workbook contents.
If you manage the sheet and want users to merge cells while keeping other protections, review the protection options and whether formatting cells is allowed. The exact permissions depend on how the sheet was protected. Do not remove protection on a shared work file without checking with its owner, since it may be there to preserve formulas or a carefully designed layout.
Make sure the selection is valid
A merge must operate on adjacent cells in one rectangular range on the same worksheet. A selection such as A1:B2 is valid; selecting A1:B2 and D1:E2 together is not. To clear an accidental multi-range selection, click a single cell and select the intended block again.
If you are unsure what is selected, look at the Name Box to the left of the formula bar. You can type a range such as A1:C1 there and press Enter to select it. If the intended cells are on separate rows, choose Merge Across only when you want a distinct merge on every row. Ordinary Merge Cells would combine the entire rectangular selection into one cell, which may not be the intended result.
Finish any in-progress entry before selecting the range. A blinking text cursor in a cell means Excel is editing its contents, not simply selecting it. Press Enter to keep the edit or Esc to discard it, then try the merge again.
Know what happens to the cell contents
When you merge cells that contain multiple entries, Excel keeps the content from the upper-left cell and discards the contents of the other cells in the merged range. For example, if A1 contains “North” and B1 contains “Region,” merging A1:B1 keeps “North”; “Region” is not automatically appended. Excel may display a warning before proceeding, but it is safer to prepare the information yourself.
If you need to combine text before merging, first put the combined result in a spare cell. With North in A1, Region in B1, and the range A1:B1 as the intended merge, enter =TEXTJOIN(" ",TRUE,A1:B1) in C1. The result is North Region. Copy the result and paste it as a value where you need it, then merge only after confirming the other contents can be removed. Keeping an unmerged backup or making a copy of the sheet is prudent when the workbook contains important data.
Unmerging later restores the separate cells, but it does not bring back values that were discarded when they were merged. Unmerge is a layout change, not a recovery feature.
When not to merge: better layout alternatives
Merged cells can make a report heading look neat, but they often cause trouble in data ranges. Sorting, filtering, selecting whole rows, copying and pasting, and using formulas can become less predictable when only part of a grid is merged. They can also make a worksheet harder to navigate with a keyboard or screen reader.
For a heading that should look centered over several columns without joining the cells, use Center Across Selection. Select the range, open Format Cells (Ctrl+1 on Windows; Command+1 on Mac), choose the Alignment tab, and set Horizontal to Center Across Selection. The cells remain separate, so this is generally a better choice for a heading above data that needs sorting or filtering. On Mac, the Format Cells dialog’s shortcut is Command+1.
Other practical alternatives include:
- Place the title in the first cell and widen the column or wrap the text.
- Use alignment, borders, and fill color to make a heading span visually without merging cells.
- For a form, use a dedicated label column instead of merging cells across the entry area.
- Keep table data unmerged and place decorative headings in rows outside the table.
Choose merging mainly for presentation areas where the cells do not need to behave as a sortable data grid.
Excel for the web and Mac differences
The core restriction is the same across Excel versions: table cells cannot be merged, and merging a range with several populated cells risks losing the non-top-left contents. In Excel for the web, look for the merge control on the Home tab; the ribbon may show fewer controls at once, so widening the browser window or opening a ribbon dropdown can help locate it. If a workbook’s protection or editing rights prevent changes, use the desktop app only if you have permission to edit the file.
On Mac, the Home tab contains the merge options, but the arrangement may not match Windows exactly. The useful shortcut difference for the alternative above is Ctrl+1 on Windows versus Command+1 on Mac to open Format Cells. Shortcuts and ribbon display can also vary with keyboard settings and app versions, so use the menus if a shortcut does not open the expected dialog.
Frequently Asked Questions
Why is Merge & Center greyed out in Excel?
Check whether the selection is in a table, the sheet is protected, you are editing a cell, or you selected multiple separate ranges. Select one continuous rectangular range on an unprotected worksheet and try again.
Can I merge cells in an Excel table?
No. Excel tables do not allow merged cells inside the table area. Convert the table to a normal range with Table Design > Convert to Range only if losing the table’s sorting, filtering, and other table features is acceptable.
Will merging cells delete data?
It can. Excel retains the content from the upper-left cell and discards content in the other cells. Combine or copy any information you need before merging.
How do I undo a merge?
Select the merged cell and choose Home > Merge & Center > Unmerge Cells. This restores separate cells, but it does not restore contents that were discarded during the original merge.
What can I use instead of merging cells?
For a centered heading across columns, use Center Across Selection in the Format Cells dialog. For data tables, keep cells unmerged and use alignment, borders, or a separate title row to get the layout you want.
Related
- Excel SUBTOTAL: Does It Ignore Hidden Rows?
- Excel: Select Only Subtotal Rows, Not the Detail Rows
- How to Group Rows in Excel With the Plus Sign
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Text on a New Line in the Same Cell: A GuideYes. In Excel for Microsoft 365 on Windows, edit the cell, place the cursor where the next line…
- Merge Cells in Excel Without Merging: Center AcrossTo make a heading look centered across several Excel columns without combining the cells, select the range, open…
- How to Export a CSV File in Excel Without Losing DataTo export a CSV from Excel for Microsoft 365 on Windows, open the workbook, select the worksheet you…
- Excel Dependent Dropdown List: Group Choices by CategoryYes. In Excel for Microsoft 365, make a group dropdown and a second dropdown that changes to show…
- Excel Import CSV Without Formatting: Keep Data RawTo import a CSV into Excel without unwanted formatting, use Data > From Text/CSV, choose Transform Data, set…
- Block a Sender in Outlook Mail: Steps, Limits and TipsTo block a sender in Outlook, select a message from that person, open the message actions or Junk…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.