To merge cells in Excel, select the adjacent cells, then choose Home > Merge & Center. Use the command’s dropdown to merge without centering, merge each row separately, or unmerge later; if more than one selected cell contains data, Excel keeps only the upper-left cell’s content.
What merging cells does
Merging combines a rectangular group of neighboring cells into one larger cell for layout. The merged area behaves as a single cell for entering and displaying content, and its address is the address of the group’s upper-left cell. For example, merging B2 through D2 creates one cell identified as B2. It does not combine the contents of B2, C2, and D2 into a sentence or add their values together.
The feature is mainly useful for presentation: a report heading can span several columns, or a label can occupy a wider area in a form. It changes the worksheet’s layout, not the underlying arrangement of the grid. The row and column boundaries still exist, but the merged area can make selecting, sorting, filtering, and editing a sheet more awkward.
Do not confuse merging with inserting cells. To create new cells or shift existing cells, use Home > Insert and choose an insertion option. Merge commands combine selected cells; they do not add new rows or columns.
How to merge cells in Excel for Microsoft 365
- Select a rectangular range of adjacent cells. For a heading across columns A through D, select A1:D1. You can drag across the cells or click the first cell, hold Shift, and click the last one.
- Open the Home tab on the ribbon.
- In the Alignment group, select Merge & Center to combine the selection and center its content.
- If you want a different result, open the dropdown next to Merge & Center and choose Merge Cells or Merge Across.
On Windows, the ribbon key sequence Alt, H, M, C activates Merge & Center in standard English-language Excel. Press the keys in sequence rather than all at once. Keyboard key tips can differ with language and version, so the ribbon is the dependable route. Excel for Mac has the same basic Home-tab command; use the ribbon dropdown if you do not have a shortcut assigned. Excel for the web also provides merge controls on the Home tab, though the ribbon’s appearance can vary with the window size.
Choose the right merge command
The dropdown options produce different layouts. Check which cells you have selected before choosing, especially when the selection covers more than one row.
- Merge & Center combines the entire selection into one cell and centers its content. Selecting A1:D3 produces one merged area spanning three rows and four columns.
- Merge Across merges cells horizontally within each selected row. Selecting A1:D3 creates three separate merged cells: A1:D1, A2:D2, and A3:D3. It does not create one large block.
- Merge Cells combines the entire selection but leaves the content’s horizontal alignment as it was. Choose this when you want a merged area without automatically centering its text.
- Unmerge Cells restores the individual cells in a selected merged area. It does not recover content that was removed when the cells were first merged.
These commands affect the selected range, not the whole worksheet. If the result is not what you wanted, use Ctrl+Z on Windows or Command+Z on Mac immediately to undo the merge. Undo is useful for correcting a recent action, but it is not a substitute for keeping important values in separate cells.
What happens to existing data
Excel can store only one cell’s content in a merged area. When you merge a range containing entries in multiple cells, Excel displays a warning that merging keeps only the upper-left value and discards the other contents. If you proceed, the top-left cell’s value, text, or formula remains; contents from the other selected cells are removed. The same rule applies if those other cells contain formulas, even when their displayed results look blank.
For example, if A1 contains Region, B1 contains Quarter, and C1 contains Sales, selecting A1:C1 and merging does not create Region Quarter Sales. Only Region remains in the merged cell. If you need all three pieces of text, combine or copy them into one cell before merging, or leave them in separate cells. For a heading, the safest approach is usually to put the heading in the upper-left cell and merge only cells that are otherwise empty.
Unmerging later restores the cell grid, but the discarded entries do not reappear. If you have already confirmed the warning and then made further edits, undo may no longer restore the original contents reliably. Keep a copy of important data before changing a complex worksheet layout.
Center and format the merged area
Merge & Center applies horizontal centering as part of the merge command. You can change alignment afterward from Home > Alignment, using the horizontal and vertical alignment buttons. To make a heading readable, you might also use bold text, a larger font, a fill color, or Wrap Text. Adjust row height or column width if the text is clipped; merging does not guarantee that every line will be visible.
To format the area, select the merged cell and use the usual font, fill, border, and number-format controls. A border applied to the merged area outlines the outside of the selected region; it does not create separate internal cell borders. If you need visible divisions between the original columns or rows, do not merge them. Apply formatting to the individual cells instead.
For finer alignment, select the cells and open the Format Cells dialog with Ctrl+1 on Windows or Command+1 on Mac. On the Alignment tab, the Horizontal setting includes Center Across Selection. This centers the first cell’s content across the selected cells without merging them, which preserves the individual grid cells. It is often a better choice for a report heading that should look centered but remain easy to sort and edit.
Common problems and how to fix them
- The merge option is unavailable: Check whether the selected cells are inside an Excel table. Excel tables do not support merged cells within the table body. Convert the table to a normal range if merging is essential, or keep the tabular data unmerged and format a heading outside the table.
- Excel says some content will be removed: The selection contains data in more than its upper-left cell. Cancel, review the entries, and move or combine anything you need to preserve before merging.
- Text appears off-center or cut off: Confirm that you chose Merge & Center rather than Merge Cells, then check horizontal and vertical alignment, Wrap Text, row height, and column width.
- Sorting or filtering becomes difficult: Merged cells can conflict with the consistent row-and-column structure these operations expect. Avoid merging cells in the body of a data list. Put decorative headings above the list, outside the filtered range.
- Copying or selecting a range behaves unexpectedly: A merged area spans several grid positions but is treated as one cell. Select the whole merged region, or unmerge it first if you need to work with its original cells separately.
A frequent misconception is that merging is a way to join text from neighboring cells. It is not a data-concatenation tool. Merging changes the layout and retains only the upper-left cell’s content; it does not preserve each entry in a combined cell or create a formula from them.
When to merge, and when to use an alternative
Merging is reasonable for a title or section label in a static presentation sheet, especially when the area contains no other values and is not part of a sortable data range. It is less suitable for working data, repeated records, or a worksheet people will filter, copy, or update regularly. Merged cells can also make keyboard navigation and screen-reader interpretation less predictable, so keeping data tables as ordinary cells supports clearer access and more reliable analysis.
Choose an alternative based on what you are trying to accomplish:
- Center a heading without changing the grid: Use Center Across Selection in Format Cells > Alignment.
- Display one label across columns: Put the label in the first cell and leave adjacent cells empty, then use Center Across Selection or adjust the column widths.
- Combine text values: Build the desired text in one cell using a formula or a suitable text-combining method, rather than merging cells. Keep the original entries if they are needed for later analysis.
- Create a structured record or report: Keep each field in its own cell and use cell formatting, column widths, and row heights to improve appearance.
For example, a worksheet with a title in A1:D1 and a sales table beginning on row 3 can use a merged title above the table. But merging A3:D3 inside the table to make a category label span several columns is likely to complicate filters, sorting, and later data entry. Keep the table rectangular and use formatting or a separate label row instead.
Frequently Asked Questions
How do I merge cells in Excel without centering the text? Select the range, then choose Home > Merge & Center dropdown > Merge Cells. This combines the range without applying horizontal centering as part of the command. You can set the alignment separately.
Can I merge cells and keep all their data? Not with Excel’s merge command. A merged area retains only the upper-left cell’s content. Move or combine the other contents before merging, or leave them in separate cells if each value must remain available.
How do I unmerge cells in Excel? Select the merged area, then choose Home > Merge & Center dropdown > Unmerge Cells. The individual cells return, but values removed during the original merge are not restored.
What is the difference between Merge Across and Merge & Center? Merge Across makes a separate horizontal merge in each row of a multirow selection. Merge & Center turns the full selected rectangle into one merged area and centers its content.
Why can’t I merge cells in an Excel table? Excel tables require a regular grid of individual cells for features such as structured data and filtering. Merged cells are not supported within the table body. Place a heading outside the table or use a non-merged formatting alternative.
Does merging cells combine their text? No. It is a layout command, not a text-joining operation. Only the upper-left cell’s content remains; use separate cells or combine the text before merging if you need multiple entries together.
Related
- Superscript in Excel: Make Numbers Small and Raised
- Excel Random Numbers Between a Range and Value
- Excel Spin Button: Setup, Linking, and Troubleshooting
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 Insert a Table of Contents in Microsoft WordTo insert an automatic table of contents in Microsoft Word for Microsoft 365 on Windows, apply built-in heading…
- How to Edit Page Breaks in Excel for Better PrintingTo edit a page break in Excel for Microsoft 365 on Windows, choose View > Page Break Preview,…
- Excel Find and Replace Hyperlink Paths?Excel Find and Replace can change a path when it appears as text in a cell or inside…
- ISBLANK in Excel: Examples and How It WorksIn Excel, ISBLANK checks whether a cell is genuinely empty: for example, enter =ISBLANK(A2) to return TRUE if…
- How to Archive Emails in Outlook 365To archive email in Outlook 365, select a message and choose Archive on the toolbar or ribbon. Outlook…
- Protect Sheet in Excel: Allow Editing in Certain CellsYes. In Excel for Microsoft 365, you can protect a worksheet while leaving particular cells editable: unlock those…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.