How to Merge Cells in Excel: Steps and Safe Options

To merge cells in Excel for Microsoft 365 on Windows, select a rectangular range, then choose Home > Merge & Center and select the merge option you need. Check the range first: Excel keeps only the value in its upper-left cell and removes other cell contents when you merge. Merging is useful for a heading that spans several columns, but it is usually not a good choice for cells that contain data you need to sort, filter, or calculate.

People sometimes call these cells boxes, but Excel’s feature is named Merge & Center. The steps below explain the available choices, how to undo a merge, and what to do if the command is unavailable.

What You’ll Need

An Excel workbook open in Microsoft Excel for Microsoft 365 on Windows. The commands are similar in current desktop versions, although ribbon layout can vary slightly.
A contiguous rectangular range of cells to combine. For example, select A1:D1 to create one wide heading cell.
A saved copy or a checked version of any information in the cells. Merging can discard content, and unmerging will not bring discarded values back.

Step-by-Step

Open the worksheet and identify the range. Decide which cells should become one larger cell. A common example is a title above a report that has several columns. Select only the cells needed for that title, not the whole data table. The selected range must be one connected rectangle; Excel cannot merge separate, non-adjacent selections as one cell.
Check every cell in the range before merging. Look for text, numbers, dates, or formulas in all selected cells. The upper-left cell is the one that will remain. If other cells contain information, copy that information elsewhere or combine it into the upper-left cell before proceeding. For a heading, you might move the full heading text into A1 and leave B1:D1 empty before selecting A1:D1.
Select the cells. Click the first cell and drag to the last one, or click the first cell, hold Shift, and click the last cell. You can also enter a range such as A1:D1 in the Name Box to the left of the formula bar and press Enter. Confirm that the selection includes the intended rows and columns only.
Open the merge options. Go to the Home tab. In the Alignment group, select the arrow next to Merge & Center. If the ribbon is narrow, the Alignment commands may be compressed; widen the Excel window or expand the group to find the dropdown.
Choose the correct command. Select Merge & Center to combine the selected cells and center the remaining content. Choose Merge Cells to combine them without applying centering. Choose Merge Across when you want a separate merged cell across each selected row. For example, selecting A1:C3 and choosing Merge Across creates three merged cells, one per row, rather than one large cell covering all three rows.
Review Excel’s warning, if it appears. If more than one selected cell contains content, Excel warns that only the upper-left value will be kept. Read the warning before continuing. Choose the option to proceed only if losing the other contents is acceptable; otherwise cancel, preserve the values, and try again with a suitable range.
Check the result and adjust formatting. Confirm the text appears in the intended merged area. If you used Merge Cells and want centered text, select the merged cell and use the horizontal and vertical alignment controls in Home > Alignment. Change column widths, row height, font, or borders if the heading does not fit. Wrapping text can help with a long heading, but may increase the row height.
Undo or unmerge if needed. Immediately after merging, press Ctrl+Z on Windows to undo the action. To separate a merged cell later, select it and choose Home > Merge & Center > Unmerge Cells. Unmerging restores the individual cells, but it does not restore any values that were discarded during the original merge.

On Excel for Mac, use the Home tab and the Merge & Center dropdown in the Alignment group; wording and ribbon placement can vary by build. On Excel for the web, select the range and look for the same merge controls on the Home tab. If the ribbon is condensed, expand it or open the relevant formatting controls.

Common Mistakes

Merging cells that contain several values. Excel does not combine all the contents into one string. It retains the upper-left cell’s content and removes the other values after you confirm the warning. Copy the values out first, or use a separate formula or text cell to create a combined label if you need all the information preserved.
Merging cells inside a structured Excel table. Excel does not allow merged cells within a table. If the merge command is unavailable, check whether the range is part of a table. A safer layout is usually to leave the data table unmerged and put a heading in the worksheet rows above it. If you truly need to merge in that range, you can use Table Design > Convert to Range, but doing so removes table features such as structured references and automatic table expansion. Consider the consequences first.
Using merged cells in the body of a dataset. Merged cells can interfere with sorting, filtering, selecting ranges, and copying or pasting rows. Keep each data record in its own unmerged row and use one value per cell. Reserve merging for presentation areas such as report titles, rather than column headings or records that need analysis.
Choosing Merge Across when one large cell was intended. This command merges each row separately. If you selected several rows, the result will be several merged cells. Use Merge Cells or Merge & Center for a single merged area across the entire rectangular selection.
Expecting unmerge to restore lost content. Unmerge Cells only separates the area again. It cannot recover information that was removed when the cells were merged. Undo straight away if the merge was accidental; otherwise restore the values from a backup, version history, or another copy of the workbook.

Tips

Use Center Across Selection for a heading when possible. This centers text across a selected range without actually merging cells, which avoids many sorting and selection problems. Select the range, open the Format Cells dialog with Ctrl+1, choose the Alignment tab, and set Horizontal to Center Across Selection. On Mac, use Command+1 to open Format Cells. This setting changes alignment; it does not combine the cells.
Keep headings separate from the data. Place a merged title in a row above the table rather than merging cells within the table itself. That gives you the visual effect of a broad heading while keeping the data range easier to sort and filter.
Make the label fit before changing the layout. Try adjusting the column widths, reducing unnecessary spaces, or turning on Wrap Text before merging. A merged cell can display a long title, but its height may not adjust as expected in every layout, so inspect the printed or exported result too.
Use a clear selection and verify it visually. Check the highlighted range and the Name Box before choosing a merge option. This is especially helpful when working with hidden rows, narrow columns, or a large worksheet where the selection is easy to misread.
Save before a large formatting change. A saved copy gives you a way back if the merge affects a report layout or removes content. This matters most when changing many cells or working in a workbook that other people rely on.

Troubleshooting

The Merge & Center command is greyed out. First check that you selected a range of ordinary worksheet cells rather than a single cell, a non-contiguous selection, or cells inside an Excel table. Click a cell in the range and inspect whether the Table Design tab appears. Also check whether the worksheet is protected; a protected sheet may prevent formatting changes. If permitted, use Review > Unprotect Sheet, make the change, and protect it again as needed. You may need the sheet password.

Excel warns that content will be deleted. Cancel if you need any of the values other than the one in the upper-left cell. Copy the other values to a safe location, or move or combine the required text before merging. Do not assume Excel will join the contents automatically; it will not.

The text is not centered after merging. The Merge Cells option merges without centering. Select the merged cell and apply horizontal centering from Home > Alignment. If it still looks off, check vertical alignment, indentation, and the width of the merged area. With Merge Across, each row has its own merged cell, so format each resulting area as required.

The result is split into several merged cells. This is the expected result of Merge Across when the selection spans multiple rows. Undo, select the intended full rectangle again, and choose Merge Cells or Merge & Center if you want a single merged area. Review the selection border before repeating the command.

You cannot sort or filter the worksheet properly afterward. Merged cells in a data range can make records uneven and disrupt Excel’s normal table operations. Unmerge the affected cells, restore any missing values from a safe copy, and keep each record on a single unmerged row. Move decorative headings outside the sortable range.

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. The cells merge, but Excel does not apply the centering associated with Merge & Center. You can set alignment separately afterward.

Can I merge cells without losing data?
Not by using Excel’s merge command when multiple cells contain values: Excel keeps the upper-left value and removes the others. Preserve the contents elsewhere first, or use Center Across Selection if your goal is only to make a heading look centered across columns.

What is the difference between Merge Cells and Merge Across?
Merge Cells combines the entire selected rectangle into one cell. Merge Across combines cells horizontally row by row, so a selection covering three rows produces three merged cells. Both options retain only the upper-left value for each merged area.

How do I unmerge cells in Excel?
Select the merged cell and choose Home > Merge & Center dropdown > Unmerge Cells. The original cell grid returns, but any content discarded during merging does not. Use Undo immediately if you need to reverse a recent merge and recover its prior state.

Why can’t I merge cells in my Excel table?
Excel does not support merged cells inside a structured table. Keep the table unmerged and put the heading above it, or consider converting the table to a normal range through Table Design > Convert to Range if the table features are no longer needed.

Can I merge cells in Excel for Mac or the web?
Yes. Current Excel for Mac and Excel for the web include merge commands from the Home tab, though the dropdown’s placement can differ. Follow the same content warning: only the upper-left value is retained when a merged area contains multiple values.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.