Merge Cells in Excel: How to Keep All Your Data

No: in Microsoft Excel, merging cells keeps only the value in the upper-left cell and discards the contents of the other cells. To keep every entry, combine the contents first, then merge; if you only want a centered heading, use Center Across Selection instead so the cells and their data remain separate.

What happens when you merge cells in Excel?

A merge turns a selected block into one larger cell. Excel retains the content of the block’s upper-left cell; any content in the other selected cells is removed. For example, if A1 contains “North,” B1 contains “Central,” and C1 contains “South,” merging A1:C1 leaves “North” and discards the other two entries. The same rule applies to text, numbers, dates, and formulas: only the upper-left cell’s content survives.

Excel normally warns you before completing a merge that it will keep only the upper-left value. That warning is important: Merge & Center is a layout command, not a command to combine text. It does not put the discarded values into a note, a comment, or the formula bar, and there is no setting that makes a standard merge automatically preserve every cell’s contents.

Merging is different from joining values. A merge changes the worksheet’s cell layout, while a formula such as TEXTJOIN creates a combined result in a cell. You can use both, but the safest order is to create and check the combined result before merging.

How to combine the contents before merging

For a short row of values, use a helper cell outside the cells you plan to merge. For example, with values in A2:C2, enter =TEXTJOIN(" - ",TRUE,A2:C2) in D2. If A2 contains North, B2 is blank, and C2 contains South, the result is “North – South.” The TRUE argument tells TEXTJOIN to ignore blank cells; the hyphen surrounded by spaces is the separator between nonblank entries.

TEXTJOIN is available in Microsoft 365 and Excel 2019 or later. Check the result before proceeding, especially if the source cells contain dates, numbers with special formatting, or formulas. A combined text result may not retain the original cell formatting or the separate formulas. For example, a date can appear as its underlying number rather than as a date if the result does not apply a suitable date format. If presentation matters, format the result deliberately or edit the combined text before replacing the original cells.

When the combined text is correct, make a backup or keep the original values in another area of the workbook. Then copy the helper cell, use Paste Special > Values to put the result in the upper-left cell of the intended merge, and merge the range. Pasting values turns the combined result into fixed text, so it will not change if the original source cells later change. Keep the original data if you need to update or audit the combined entry in the future.

Put the formula outside the range you intend to merge, so it does not overwrite one of its inputs.
Choose a separator that makes the combined entry readable, such as a comma, slash, dash, or line break.
Check for blanks, repeated separators, and values that might be misread when combined.
Retain a copy of the original cells if the individual entries may be needed later.

If each row needs combining, fill the formula down using the corresponding row ranges, check several results, and only then decide whether merging is appropriate. Avoid merging a large data range simply to make it look tidy: a single combined value is less useful for later sorting, filtering, counting, or analysis.

Merge the cells after preserving the values

In Excel for Microsoft 365 on Windows, select the cells to merge, then choose Home > Merge & Center. The main button merges the selection and centers its surviving content. To choose a different merge behavior, use the arrow beside Merge & Center and select Merge Cells, Merge Across, or another available option. Read the warning before confirming, because any remaining content outside the upper-left cell will be removed.

For a safer workflow, first combine or move the values you want to keep, then confirm that the upper-left cell contains the final text. Select only the intended range; accidentally including an adjacent cell can remove its content too. If you merge multiple rows or columns, check how Excel will divide the selection: Merge Across creates a separate merged cell for each row, whereas a standard merge makes the entire selection one cell.

Excel for Mac has the merge controls on the Home tab as well, although the ribbon layout can vary by release and window size. Excel for the web also provides merge options on its Home tab, but the available controls may differ. In any version, the key data rule is the same: merging does not combine the contents of the cells.

Use Center Across Selection for headings

If your goal is simply to center a heading over several columns, you usually do not need to merge. Center Across Selection makes text in the leftmost cell appear centered across the selected cells while leaving the cells separate. This avoids the data loss risk and many of the layout problems caused by merged cells.

To use it in Excel for Microsoft 365 on Windows, select the cells across which the heading should appear, open Format Cells with Ctrl+1, and choose the Alignment tab. In the Horizontal list, select Center Across Selection, then choose OK. On a Mac, open Format Cells with Command+1; the dialog may be arranged differently, but look for the same horizontal alignment option. Enter the heading in the leftmost selected cell, not in every cell across the selection.

This option changes alignment, not the underlying data. The other cells remain available for formulas, sorting, and editing. It is therefore often a better choice for report titles and section labels. It is not a way to combine multiple cell entries: if the cells already contain different values, those values remain separate rather than becoming one centered phrase.

Why merged cells can cause problems

Even after you have preserved the text, merged cells can make a workbook harder to work with. Sorting and filtering generally expect a consistent grid in which each row has the same cell structure. Merged cells can interfere with those operations, particularly when a merged range crosses rows or columns. Some features may reject the operation or produce awkward results, so test the workbook’s intended workflow before merging.

Merged cells can also complicate selecting ranges, copying and pasting, filling formulas, and adjusting row heights or column widths. A formula that refers to cells in a merged range may not behave as a reader expects, because the merged area has only one actual value cell: its upper-left cell. Other cells in that area are not independent storage locations for the merged content.

These limitations matter most in data-entry sheets, lists, and workbooks that feed charts, PivotTables, or other analysis. A formatted title on a static report may be fine; merged cells throughout a table of records are usually a poor fit. Keep data in a regular grid, with one record per row and one field per column, and apply visual formatting separately.

Common mistakes and how to recover

The most common mistake is clicking Merge & Center before combining the other values. If you notice immediately, press Ctrl+Z on Windows to undo the merge; on Mac, use Command+Z. Undo may restore the prior cell contents if the merge is still in the undo history. If you have performed many later actions, closed the workbook, or saved over the file, recovery is less certain. Check version history if the workbook is stored in OneDrive or SharePoint, or restore a separate backup if one exists.

Another mistake is assuming that the warning means the other text will be added to the cell. It will not. Cancel the warning, combine the values in a helper cell, and retry only after checking the result. Also remember that copying a merged cell does not turn it back into the original separate values; once those values have been discarded, copying the merged result only copies what remains.

A workbook may also prevent merging in some contexts. For example, Excel does not allow merged cells inside an Excel table, so the merge command may be unavailable while a cell in the table is selected. If the goal is a table heading, put the title above the table and use Center Across Selection or ordinary formatting instead of converting the data table’s cells into a merged range.

When merging is appropriate

Merging can be reasonable for a simple presentation layout when one label should occupy a larger visual area and no separate values are needed in the selected cells. A report title above a static summary is a typical example. Before merging, consider whether someone will need to sort, filter, copy, or extend the range later. If the answer is yes, a non-merged layout is usually more maintainable.

Use a practical rule: preserve source data in separate cells, combine it only for display when needed, and merge only when the layout benefit is worth the restrictions. For a heading, try Center Across Selection first. For a single combined text string, use a helper formula or a dedicated output column rather than relying on a merge to do a data-combination task.

Frequently Asked Questions

Does Excel have a merge option that keeps all cell values?
No. Standard merge options retain the upper-left cell’s content and remove the other selected contents. Combine the values first with a formula or copy them elsewhere before merging.

Can I recover data after merging cells?
If the merge was recent, try Undo (Ctrl+Z on Windows or Command+Z on Mac). If it is no longer undoable, check a workbook backup or version history where available. Excel does not keep the discarded values inside the merged cell.

How do I combine text from several cells into one?
Use TEXTJOIN with a separator and the range, such as =TEXTJOIN(", ",TRUE,A2:C2) when the entries are in A2:C2. Check the result, then copy and paste values if you need a fixed text result.

What is the difference between Merge Cells and Center Across Selection?
Merge Cells creates one larger cell and discards content from all but its upper-left cell. Center Across Selection changes the appearance of the leftmost cell’s content across a selected range while keeping the cells separate.

Can I sort a range that contains merged cells?
Merged cells can prevent sorting or make a range behave unexpectedly, especially if merges span multiple rows. For sortable data, unmerge the cells and keep one value per cell; use formatting or Center Across Selection for headings.

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.