Yes, you can merge cells in Excel for Microsoft 365 on Windows: select the cells, then choose Home > Merge & Center. Excel combines the selected cells into one larger cell, but keeps only the content in the upper-left cell, so check the selection before merging.
What merging cells does
When you merge a range, Excel treats that range as one cell for many purposes. The merged area takes up the same rows and columns as the original cells, but only the upper-left cell remains the cell that holds the value or formula. For example, merging A1:C1 creates a single cell visually spanning three columns. It does not combine three separate values into one string.
Merging is mainly a layout and presentation feature. It can make a heading appear centered over several columns or create a larger label area in a report. It does not join data the way a text-concatenation formula would, and it does not make the selected cells into a new kind of data field. The distinction matters if you later sort, filter, copy, or calculate using the worksheet.
How to merge cells in Excel for Windows
In Excel for Microsoft 365 on Windows, use the ribbon to merge a range:
- Select the adjacent cells you want to combine. The selection can cover multiple columns, rows, or both.
- Open the Home tab and look in the Alignment group.
- Select Merge & Center to merge the selection and center its remaining content.
If the button shows a different merge option, select its drop-down arrow to see the available commands. Excel may display a warning if more than one selected cell contains content. Read it before proceeding: accepting the merge discards the contents of cells other than the upper-left one.
There is also a keyboard route on Windows: press Alt, then H, then M, then C to invoke the ribbon command for Merge & Center. These are sequential KeyTips, not keys to hold down together. KeyTips can vary if the ribbon or Excel version differs, so the on-screen ribbon labels are the reliable reference.
What the merge options mean
The drop-down beside Home > Merge & Center offers related commands. They do not all arrange the selection in the same way:
- Merge & Center combines the selected cells into one and centers the remaining content horizontally.
- Merge Across merges cells across each row of the selected range separately. Selecting A1:C3 creates three merged cells, one for each row, rather than one large A1:C3 cell.
- Merge Cells combines the selection into one cell without applying the centering behavior of Merge & Center.
- Unmerge Cells removes the merged layout and restores the individual cells in the range.
These differences are useful when formatting a report. For instance, Merge Across can create a row-wide label for each section of a multi-row layout. By contrast, if you select A1:C3 and choose Merge & Center, Excel creates one merged area spanning all three rows and columns. Consider the shape you need before choosing the command.
What happens to existing data
Excel does not preserve every value inside a merged range. It keeps the value or formula from the upper-left cell and removes content from the other cells in the selection. If A1 contains “Quarterly Sales,” B1 contains a date, and you merge A1:B1, only the content from A1 remains. The date is discarded from the worksheet range when the merge is accepted.
This is not the same as combining text. If you need to preserve information from multiple cells, first put the desired combined result in a separate cell or use a suitable formula, then decide how to format the result. Merging should not be used as a way to join records, labels, or numbers. It can also make it harder to select and reference individual cells later.
If the warning appears unexpectedly, choose Cancel and inspect the selected cells. Check for values, formulas, or data that may not be obvious because of column width, number formatting, or hidden rows. A blank-looking cell can still contain a formula or a value; the formula bar can help you verify the active cell’s contents.
When merging is useful—and when it is not
A merge can be reasonable for a presentation-focused worksheet where the merged range is a heading or label and the cells beneath it are not intended to be independently sorted or analyzed. For example, a title such as “Regional Revenue” might span the columns for several months in a print-ready summary. A short label spanning a designed form area is another possible use.
It is usually a poor choice for the main body of a data table. Excel’s sorting and filtering work best when each row is a consistent record and each column has its own header. A merged heading inside the data region can interrupt that structure. Merged cells are also not allowed inside an Excel table: if you convert a range to a table, you may need to unmerge cells first.
Before merging, ask what the worksheet is for. If it is primarily a report for people to read, a merge may be an acceptable visual choice. If it is a list that people will sort, filter, extend, import, or analyze, keep the cells separate and use formatting that does not change the grid structure.
Common problems with merged cells
Several everyday Excel operations become less predictable when a worksheet contains merged ranges. Sorting a range that includes merged cells can produce an error or require you to change the selection. Filtering and structured table layouts also rely on consistent rows and columns, which merged cells can disrupt. A merged cell may cover several columns, yet it still has only one underlying value in its upper-left position.
Copying and pasting can be troublesome when the source and destination ranges have different merged-cell shapes. Excel may reject the paste or apply formatting in a way that is not what you intended. Selecting a single column or row through a merged area can also feel awkward because the merged range crosses the boundaries of individual cells.
These issues are not proof that merging is broken; they follow from the fact that the worksheet grid is no longer a simple one-cell-per-position layout in that area. If a workbook is shared with colleagues, used as a data source, or fed into another process, avoiding merges in the working data can prevent later cleanup.
Alternatives that keep cells separate
If your goal is visual alignment rather than creating a single cell, try Center Across Selection. Select the cells, open the Home tab, and use the dialog launcher in the Alignment group to open Format Cells. On the Alignment tab, choose Center Across Selection in the Horizontal list. The cells remain separate, so this can be friendlier to sorting and data handling than merging. It is most useful for a heading centered across a range; check the result in the worksheet because the displayed text depends on the neighboring cells and their contents.
Other options may fit better depending on the layout:
- Use Center alignment on a single cell if the label does not need to span several columns.
- Use Wrap Text to display a longer heading on multiple lines within one column, adjusting the row height if needed.
- Widen a column or adjust row height when the issue is simply that a label does not fit.
- Keep a heading in one cell and apply borders, fill color, or font formatting across nearby cells to create a visual section without merging them.
These alternatives preserve the normal cell grid, but they do not all produce exactly the same appearance as a merge. Choose based on whether the priority is appearance, editing convenience, or reliable data operations.
How to unmerge cells
To undo a merge, select the merged cell or range and choose Home > Merge & Center > Unmerge Cells. Excel restores the original cell boundaries. However, it does not bring back content that was removed from the non-upper-left cells when the merge was first made. Unmerging changes the layout; it is not a recovery tool for discarded values.
If you just merged the cells and have not made other changes, Ctrl+Z on Windows can undo the action and restore the prior state. On a Mac, the usual undo shortcut is Command+Z. If you have already continued editing or saved and closed the workbook, undo may no longer be available. For important data, make a copy or confirm the cell contents before merging.
Excel on Mac and Excel for the web
In Excel for Microsoft 365 on Mac, the merge commands are also available from the Home tab, in the alignment controls. The exact ribbon arrangement can differ from Windows, so look for the Merge & Center button and its menu. The Windows Alt-based KeyTips described above do not apply as a Mac shortcut; use the ribbon command or the shortcut guidance shown by your Mac version.
Excel for the web also provides cell-merging controls on the Home tab, although the interface and available options can change as Microsoft updates the web app. The same practical caution applies: merging is a layout operation, and you should verify which content will remain before accepting it. If a command is missing or behaves differently in a particular workbook, check whether the sheet is protected or whether the selected range is part of a table.
Frequently Asked Questions
Can I merge cells without losing data?
Not if multiple selected cells contain content and you accept the merge: Excel keeps only the upper-left cell’s content. Move or combine information elsewhere first if you need to retain it.
Can I merge cells in an Excel table?
No. Excel tables do not support merged cells within the table range. Unmerge the cells or redesign the layout outside the table before converting the range to a table.
What is the difference between Merge Cells and Merge & Center?
Both combine the selected cells and retain only the upper-left content. Merge & Center also centers that content horizontally; Merge Cells does not apply that centering action.
Can I sort data that contains merged cells?
Sorting may be blocked or behave inconveniently when the selected range includes merged cells. For sortable data, keep the records in an unmerged, consistent grid and use formatting for headings separately.
Does unmerging restore the deleted values?
No. Unmerge Cells restores the individual cell boundaries, but values removed from the other cells are not recovered. Undo immediately after merging, if available, or restore the information from a saved copy.
Related
- How to Group Rows in Excel With the Plus Sign
- Group Rows in Excel for Sorting Without Splitting Data
- How to Group Rows in Excel Online: A Step-by-Step Guide
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Track Changes in Word for the Web: A Step-by-Step GuideTo track edits in Word for the web, open the document, select Review > Track Changes, and choose…
- How to Track Finances in Google Sheets Step by StepTo track finances in Google Sheets, create a transaction log, record each income or expense on its own…
- Excel Remove Duplicates but Keep One Copy in a ListTo remove duplicates in Excel but leave one copy, select your data and choose Data > Remove Duplicates;…
- How to Undo Archive Emails in OutlookTo undo archiving in Outlook, find the message in the Archive folder, select it, and move it to…
- How to Keep Track of Your Budget in Excel: Step by StepTo keep track of a budget in Excel, record each transaction in a dated log, assign it a…
- Excel: Highlight the Bottom 10 Values in RedTo highlight the 10 lowest values in red in Excel, select the cells containing your numbers, then choose…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.