Merge Cells but Keep All Data in Excel: What Works

No—Excel’s Merge & Center command does not keep the contents of every selected cell: it retains the upper-left cell’s content and removes the contents of the others. To preserve the information, combine it into one cell first, or use Center Across Selection when you only want a centered appearance without merging.

What happens when you merge cells

In Microsoft Excel for Microsoft 365 on Windows, select a range and choose Home > Merge & Center to combine its cells into one larger cell. If more than one selected cell contains content, Excel warns that merging keeps only the upper-left value. If you confirm, the other contents are removed from the worksheet; they are not joined automatically.

For example, if A1 contains “West,” B1 contains “Region,” and C1 contains “2026,” merging A1:C1 leaves “West” in the merged cell. “Region” and “2026” do not become part of the result. Excel may show a warning before completing the action, but the warning is not a data-preserving option: cancel it if you need the other entries.

The same rule applies if the cells contain formulas. The content in the upper-left cell remains, while formulas or values in the other cells are cleared. A cell’s formatting and its content are different things, so do not assume that preserving a color, border, or number format means the underlying value was preserved too.

How to combine the contents before merging

If the goal is one cell containing all the information, create a combined result before merging. For a simple row of text, TEXTJOIN can join the entries and skip blanks. Suppose A2:C2 contain West, Region, and 2026. Put the formula in a helper cell outside the range you plan to merge, such as D2:

With West, Region, and 2026 in A2:C2, enter this in D2: =TEXTJOIN(" - ",TRUE,A2:C2). The result is West - Region - 2026.

Enter the formula in a helper cell that will not be part of the merged range.
Check the result and choose a separator that makes the combined text readable, such as a space, comma, or dash.
Copy the result cell. Select the upper-left cell of the range you intend to merge, then use Home > Paste > Paste Values. This replaces that cell’s formula with its displayed result.
Select the original range and choose Home > Merge & Center, or use the dropdown beside it to select Merge Cells if you do not want centered text.
Confirm the result and keep the original entries elsewhere if you may need them later.

Putting the helper formula outside the merge range matters. If the formula depends on cells that are about to be merged, those source contents can disappear during the merge. Pasting the combined result as a value into the upper-left cell first makes the intended text independent of the cells that will be cleared.

TEXTJOIN is available in Microsoft 365 and Excel 2019 or later. In older versions, a simple concatenation formula can work for a small number of cells. With West in A2 and Region in B2, enter =A2&" - "&B2 in a separate helper cell; it returns West - Region. Add more cell references and separators as needed.

Preserve dates, numbers, and formulas correctly

Joining values as text can change how dates and numbers look. Excel stores dates as serial numbers, and a formula that combines a date directly with text may show the serial value rather than the date format displayed in the original cell. Similarly, a number displayed with a currency symbol or leading zeros may not carry that appearance into the joined text.

For display-sensitive content, explicitly format the value as part of the formula. For example, if A2 contains a date and B2 contains a name, a formula can use TEXT to specify the date’s appearance:

With a date in A2 and a name in B2, enter this formula in a helper cell: =TEXT(A2,"mmm d, yyyy")&" - "&B2. If A2 is March 5, 2026, and B2 is North, the result is Mar 5, 2026 - North.

Choose a format code that suits the information, and check the output before merging. If the cells contain formulas, decide whether you need their current results or need to retain the formulas themselves. A joined text string generally captures a representation of results; it does not preserve each source formula as a separately editable calculation. Keep a copy of the original cells when later recalculation or auditing matters.

Center Across Selection: the safer visual alternative

Often the real request behind “merge cells” is simply to center a heading over several columns. In that case, use Center Across Selection. It centers the text across the selected cells visually while leaving the cells separate, so their individual values remain available for sorting, filtering, formulas, and data entry.

Select the cells across which the heading should appear.
Open Format Cells with Ctrl+1 on Windows.
On the Alignment tab, open the Horizontal list and choose Center Across Selection.
Select OK.

This option is especially useful for worksheets that will be sorted, filtered, copied into other systems, or used as a source for analysis. It does not combine the contents: put the heading in the leftmost cell of the selected range and keep the other cells’ data as needed. On Excel for Mac, the Format Cells dialog is available with Command+1; ribbon labels and dialog options can vary slightly by release.

Choosing the right merge command

The dropdown beside Home > Merge & Center offers several behaviors. The exact result depends on the option, so check the selection before applying it:

Merge & Center merges the selected cells and centers the remaining upper-left content.
Merge Cells merges the selection without centering its content.
Merge Across merges cells across each row of the selected range separately. It does not create one large merged area spanning all rows.
Unmerge Cells returns a merged area to separate cells. It does not restore contents that were removed when the merge happened.

These choices affect layout, not the rule about multiple contents: do not count on a merge option to combine text from every cell. If a selected range contains entries you need, combine or copy them first.

Common problems and ways to recover

The most serious problem is merging before making a copy. If you have just merged cells and the other entries have disappeared, use Ctrl+Z on Windows immediately to undo the operation. On Mac, use Command+Z. Undo may also reverse intervening actions, so check the sheet carefully. If the workbook was closed, saved, or changed significantly afterward, recovery is not guaranteed; check available version history or backups rather than assuming unmerge will bring the values back.

Unmerging restores the cell grid, not the former contents. Usually the retained value is placed in the upper-left cell and the other cells are blank. This is why “merge, then unmerge” is not a safe way to preserve data. If a warning appears and you are unsure, choose Cancel, save a copy, and combine or record the contents before trying again.

Merged cells can also make ordinary worksheet tasks harder. Sorting a range with merged cells of inconsistent sizes can produce errors or unexpected layouts; filtering and selecting ranges may be less convenient; and pasting a rectangular block into a differently shaped merged area can fail. Excel tables do not support merged cells within the table body. For these reasons, avoid merging cells inside structured lists or datasets.

When merging is appropriate

Merging can be reasonable for a report title, a decorative label, or a print-focused layout where the range is not being used as a sortable data table. It can make a heading appear to span columns, but it also changes the worksheet structure and may complicate later edits. For a reusable workbook, a separate title row or Center Across Selection is often easier to maintain.

Before merging, ask what the range is for and whether its cells contain information that should remain independently accessible. For a one-off presentation sheet, a merge may be acceptable after preserving the values. For an import sheet, contact list, inventory, or other structured data, keep one value per cell and use formatting rather than merging.

For a heading that only needs visual centering, use Center Across Selection.
For information that belongs together as one text entry, join it deliberately and retain a copy of the source values.
For data that must remain sortable or filterable, do not merge the data cells.

Frequently Asked Questions

Can Excel merge cells without deleting data?
No. A normal merge retains only the upper-left cell’s content and clears contents from the other cells in the selection. Combine the entries first or use a non-merging alignment option if you need to keep them separate.

Can I recover values after merging and saving?
Unmerge Cells will not restore the cleared values. If the merge was recent, try Undo. Otherwise, check version history, a backup, or another copy of the workbook; recovery depends on whether a suitable earlier version exists.

Does Merge Across keep data from every row?
No. Merge Across creates separate merged cells across each row, but each individual merge still retains only that row’s upper-left cell content. Combine or preserve the other contents in each row first.

How do I center text across columns without merging?
Select the cells, open Format Cells with Ctrl+1 on Windows, choose the Alignment tab, set Horizontal to Center Across Selection, and select OK. On Mac, open Format Cells with Command+1.

Can I merge cells in an Excel table?
Excel tables do not allow merged cells within the table body. Keep the table cells separate and place a heading above the table, or use formatting outside the table for a visual heading.

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.