How to Merge Cells in Excel Without Losing Your Data

To merge cells in Excel without losing their contents, first combine the values you need into the top-left cell or a separate helper cell, then merge the range. Excel keeps only the top-left cell’s content during a merge and discards the rest. If you only want a centered heading without combining cells, use Center Across Selection instead.

The steps below are for Excel for Microsoft 365 on Windows. A true merge changes the cell structure, so make a copy of important data first and check the combined text before continuing.

What You’ll Need

An Excel worksheet with the cells you want to combine.
A blank helper cell outside the range, if you need to join several values before merging.
A clear separator, such as a space, comma, or line break, if the values should remain distinct.
A saved copy of the workbook if the original data is important or difficult to recreate.

Step-by-Step

Check the range and choose what to preserve. Identify the cells you intend to merge, such as B2:D2. Excel can merge a rectangular range, but it cannot keep separate values in separate cells within a merged area. Decide whether you need every value, just the top-left value, or only the visual effect of a merged heading. If the other cells are blank, you may merge directly. If they contain anything you need, combine or move that content first.
Make a backup or duplicate the source values. Save the workbook with Ctrl+S, or use File > Save As to create a copy before making a change. If you want a quick temporary backup, copy the source cells to an unused area or another worksheet. On a Mac, use Command+S to save. This matters because a merge removes content from cells other than the top-left one; undo is useful immediately afterward, but it is not a substitute for a backup.
Join the values in a helper cell. For example, if the values are in B2:D2 and F2 is an empty helper cell outside the range, enter this formula in F2: =TEXTJOIN(" ",TRUE,B2:D2). It joins nonblank entries with a space. If B2 contains North, C2 contains Region, and D2 contains 4, the result is North Region 4. To use commas instead, replace the space between the quotation marks with a comma and a space. Check the result for missing details, unwanted extra spaces, or a separator that does not suit the data. TEXTJOIN is available in Excel for Microsoft 365 and Excel 2019 or later.
Check special values before copying the result. Joining cells creates text; it does not preserve separate formulas, number formats, or cell formatting as independent items. Dates can appear as serial numbers rather than in their familiar date style, and numbers may not retain custom display formats. If the joined result includes a date, inspect it and, if needed, format the date as text in the helper formula before joining. For example, you can use a TEXT expression for the date value and choose a format such as mmm d, yyyy. Confirm the displayed helper result is exactly what you want before replacing any original cell.
Put the combined result in the top-left cell. Select the helper cell and copy it with Ctrl+C. Select the top-left cell of the range, such as B2, then choose Home > Paste > Values. This puts the combined result into B2 as a fixed value, rather than leaving a formula that refers to cells you are about to merge. On a Mac, use Command+C to copy; the Paste Values command is also available from the Home tab. Verify that the combined text is now in the top-left cell.
Remove the helper formula if you no longer need it. Once the result has been pasted as a value, you can clear F2. Do not clear it before copying and pasting the result. If you are keeping the helper formula for audit purposes, leave it outside the merge area and label it so it is not mistaken for part of the final layout.
Select the cells to merge. Drag across B2:D2, or click B2 and hold Shift while selecting D2. Check that the range includes only the cells intended for the merged heading or label. Avoid selecting entire rows or columns by accident. If the range contains data in cells other than B2, Excel will warn that merging keeps only the upper-left value. Because you have already combined the needed content in B2, that warning is expected.
Choose the merge option. On the Home tab, in the Alignment group, open the Merge & Center dropdown and choose Merge & Center to merge the cells and center the result. Choose Merge Cells if you want the cells joined without centering the content. The menu may also offer Merge Across, which merges each row separately in a multirow selection. Do not choose Merge & Center if you need to preserve separate cell values; use Center Across Selection instead, as described below.
Review the merged cell and save. Confirm that the text is complete, legible, and aligned as intended. Adjust wrapping, row height, column width, or alignment if needed. Save the workbook with Ctrl+S on Windows or Command+S on Mac. If the result is wrong and you have not made other changes since the merge, use Ctrl+Z on Windows or Command+Z on Mac to undo it, then restore or recombine the source values before trying again.

Common Mistakes

Assuming Merge & Center combines every value. It does not. Excel retains only the upper-left cell’s content and removes the contents of the other cells in the selection. A warning is a reminder of this behavior, not a prompt to combine the values automatically.
Leaving the helper formula inside the merge range. If the formula refers to cells that are being merged, the result can change or become unusable. Put the formula outside the selected range, then paste its result as a value into the top-left cell before merging.
Using the wrong separator. Joining names or labels with no delimiter can make them run together. Choose a space for words, a comma and space for list items, or another separator that makes the result easy to read. Inspect the output before merging.
Merging cells that are part of a data table. Merged cells can interfere with sorting, filtering, copying, and some formulas or table features. Avoid merging cells in the middle of a structured list; keep the data in separate cells and use a heading above the table instead.
Confusing visual centering with a true merge. A merged cell is one larger cell. Center Across Selection changes the appearance while leaving the original cells separate, which is usually safer for worksheet data.

Tips

Use Center Across Selection for headings when possible. Select the horizontal range, open Format Cells from the Home tab’s Alignment group, choose the Alignment tab, and set Horizontal to Center Across Selection. The value remains in the first cell, and the selected cells remain separate. This works well for titles above tables and is easier to sort around than a true merge.
Keep source data in its own columns. If you are preparing a report, combine values only in a presentation area. Keeping names, dates, categories, and amounts separate in the underlying data makes it easier to filter, sort, and analyze the worksheet later.
Use line breaks for stacked text. If several pieces of information should appear on separate lines in one merged cell, join them with a line break rather than a space. In a formula, the line-break character is CHAR(10); turn on Wrap Text so the lines display. Check row height because Excel may not automatically show every line.
Format after merging. Set alignment, Wrap Text, font, borders, and fill after you have confirmed the merged content. Applying formatting to the finished range helps avoid surprises and makes it easier to identify the actual top-left cell that stores the value.
Remember that merged cells can complicate later edits. A merged range behaves differently from a normal grid of cells. If you expect to sort, filter, or paste data into the area later, use Center Across Selection or keep the cells unmerged and style the heading another way.

Troubleshooting

Excel says it will keep only the upper-left value. That is normal when other selected cells contain content. Cancel if you have not already combined or backed up those values. Use a helper cell to join them, paste the result into the top-left cell, and then merge. If you intended to keep just the top-left value, confirm that the remaining contents are not needed before proceeding.

The merged result is missing text. Undo immediately with Ctrl+Z on Windows or Command+Z on Mac if the merge was your last action. If undo is no longer available, restore the workbook copy or retrieve the original values from your backup. Rebuild the helper result, check it carefully, and repeat the merge only after confirming all required content is included.

The values appear as numbers or dates in an unexpected format. TEXTJOIN combines values as text and may not carry over the way the source cells were formatted for display. Check the helper result before pasting it. If a date needs a readable style, convert it to text using a date format in the helper formula; if the output is already merged, undo or unmerge it, correct the value, and merge again.

The merge command is unavailable or disabled. Check that you selected a suitable range on a worksheet that is not protected, and that you are not editing a cell. Press Enter or Esc to leave edit mode, then select the range again. Some operations are restricted in shared or protected workbooks; if necessary, ask the workbook owner to allow the change or work on an authorized copy.

The cells merge but the result is hard to read. Turn on Wrap Text, widen the column, increase the row height, or change the alignment. If the result still does not fit, shorten the separator or use Center Across Selection with a wider range. On Excel for the web, the merge commands are on the Home tab, though available controls can differ from the Windows desktop app; use desktop Excel for Center Across Selection if that option is not available in your web interface.

Frequently Asked Questions

Can I merge cells in Excel without losing any data?
Yes, if you combine all the content you need into the top-left cell before merging. Excel cannot keep separate values in each cell of a merged range. Use a helper formula or copy the values elsewhere first.

Does Merge & Center combine text from multiple cells?
No. It keeps the top-left cell’s content and discards the contents of other selected cells. To combine text, use a helper formula such as TEXTJOIN, check its result, and paste that result as a value into the top-left cell.

What is the safest way to center a heading without merging?
Select the cells across which the heading should appear, then use Format Cells > Alignment > Horizontal > Center Across Selection. This centers the first cell’s content across the selection while keeping the cells separate.

Can I merge cells that contain formulas?
You can, but only the formula in the top-left cell remains. Formulas in other selected cells are removed. If you need their results, combine or copy those results before merging; a joined result will be text, not a set of independently working formulas.

Will merging cells affect sorting or filtering?
It can. Merged cells within a data range may prevent sorting or filtering from working as expected. Keep the underlying records unmerged and use a separate heading area or Center Across Selection for visual layout.

Can I undo a merge later?
Use Ctrl+Z on Windows or Command+Z on Mac immediately after the merge. You can also select the merged cell and choose Home > Merge & Center > Unmerge Cells, but unmerging does not restore content that Excel discarded. Keep a backup if you may need those original 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.