Merge Cells in Excel and Keep All Data

To merge cells in Excel without losing their contents, first combine the contents into one cell, then merge the range. Excel’s Merge & Center command keeps only the value in the upper-left cell and discards the contents of the other cells, so save a copy and combine the data before merging.

This guide is for Excel for Microsoft 365 on Windows. The same basic process works in Excel for Mac and Excel for the web, though ribbon layouts and keyboard shortcuts can differ. The important distinction is that a merged cell can display one combined value, but it cannot retain several separately editable cell values within the merged area.

What You’ll Need

An Excel workbook with the cells you want to combine.
A backup copy of the workbook, or a spare worksheet where you can preserve the original values.
An empty helper cell for a formula that joins the contents before merging.
A clear separator, such as a comma, a space, or a vertical bar, to make the combined text readable.

Step-by-Step

Check the range and make a safe copy. Identify the exact cells to merge and note their order. Excel places the merged cell’s content in the upper-left cell of the selected range. Save a copy of the workbook with File > Save As, or duplicate the worksheet by right-clicking its sheet tab and choosing Move or Copy. This gives you a way to recover individual values if you need them later.
Choose how the combined text should read. Decide whether the values need a space, comma, label, or other separator between them. For example, joining a city and a region with a comma is clearer than running the two words together. If the cells contain numbers, dates, or codes, consider whether the displayed text is what you want to preserve; a formula that joins values produces text, not a sum or other calculation.
Enter a joining formula in an empty helper cell. With North in A1, West in B1, and Online in C1, enter this in D1: =A1&" | "&B1&" | "&C1. In this example, the formula returns North | West | Online. The ampersand joins the cell contents, and the quoted text supplies the separators. Use a helper cell outside the range you plan to merge so the formula is not overwritten.
Adapt the formula to your own cells. Replace A1, B1, and C1 with the addresses of the cells you are combining, keeping them in the order you want. For two cells, remove the reference and separator for the third. For a longer range, add each cell reference with an ampersand and the separator between references. If you need to combine many values regularly, consider using a dedicated combined-data column and leaving the original cells separate.
Copy the formula result as a value. Select the helper cell, such as D1, and choose Home > Copy. Select the upper-left cell of the range to merge, such as A1, and choose Home > Paste > Values. This puts the combined text into A1 as a fixed value rather than a formula that refers back to cells about to be merged. If the Values button is not immediately visible, open the Paste drop-down on the Home tab and choose the values-only option.
Confirm the combined text before merging. Click the upper-left cell and read its contents in the formula bar or in the cell itself. Check that the wording, order, and separators are correct. If anything is missing, correct the formula in the helper cell, copy its result, and paste values into the upper-left cell again. Do not continue until the combined value is right.
Select only the intended cells. Drag across the range, or click the first cell and Shift-click the last one. For the example, select A1:C1. Check that the upper-left cell contains the complete combined value. If your selection spans several rows and columns, pause and confirm that you really want one large merged block; merging an entire rectangular range is not the same as merging each row separately.
Merge the selected range. On the Windows ribbon, choose Home > Merge & Center drop-down > Merge Cells. Use Merge Cells when you want the range combined without automatically centering the text. Merge & Center also joins the cells but centers the surviving content. The other options, such as Merge Across, work differently, so choose the one that matches the shape you intend.
Check the result and remove the helper if appropriate. The merged cell should show the full combined value. You can now clear D1 if you no longer need it, but keep your backup if the original separate values may be useful. If the merged cell is too small to show the text, widen the column, increase the row height, or enable Home > Wrap Text. Adjust alignment only after confirming the content is intact.

In Excel for Mac, use the Home tab’s Merge & Center menu; the labels may be arranged differently depending on the window size. There is no single Mac shortcut that behaves consistently across all Excel versions and keyboard layouts, so use the ribbon if you are unsure. Excel for the web also has merge options on the Home tab, although its controls may be simplified. In any version, combine and verify the data first: merging alone does not preserve values from every selected cell.

Common Mistakes

Merging before combining the contents. This is the main cause of lost data. Excel warns that merging keeps only the upper-left value, but proceeding still removes the other cell contents from the merged range. Cancel the warning, create a combined value, and try again.
Assuming Merge & Center combines text. The command combines the cell areas, not their contents. It does not append words, add numbers, or keep a list of the original values.
Putting the helper formula inside the selected range. A formula placed in a cell that will be merged may be overwritten or lost. Put it in a spare cell outside the selection, and paste its result as a value into the upper-left cell before merging.
Using a separator that makes the result hard to read. Joining 123 and 456 without a divider produces 123456, which can look like one number or code. Decide whether a space, comma, hyphen, or label is needed. For identifiers, make sure the combined display cannot be mistaken for a different identifier.
Merging a large block by accident. Selecting multiple rows and columns and choosing Merge Cells creates one merged cell for the entire selection, not one merged cell per row. Check the highlighted range first. For row-by-row grouping, Merge Across may be appropriate, but still combine each row’s contents before using it.
Merging cells that need to remain sortable or filterable. Merged cells can interfere with sorting, filtering, filling, and selecting data consistently. Avoid merging cells inside a structured Excel table; tables do not support merged cells in their data area. Use a visual alignment alternative where possible.

Tips

Keep a record of the original values. A merged cell stores one value, so the combined text cannot be split back into the original cells automatically in every case. Keep the source columns on another sheet or save a separate copy when those values matter.
Consider Center Across Selection instead. If the goal is to make a heading look centered over several columns while keeping the cells separate, select the cells, open Format Cells, choose the Alignment tab, and set Horizontal to Center Across Selection. The values remain in their own cells, which is safer for later sorting and editing. This option is available in desktop Excel; the web version may not expose every Format Cells setting.
Use wrap text for a long combined value. After merging, choose Home > Wrap Text so text can appear on multiple lines. A merged cell may not automatically adjust its row height as expected, so increase the row height manually if part of the text is hidden.
Choose the merge option deliberately. Merge Cells combines the selected range without centering. Merge & Center also centers the content. Merge Across makes separate horizontal merges for each row in the selection. Check the result carefully if you use Merge Across on a multi-row range.
Do not treat merged numbers as a calculation. Joining 10 and 20 with a separator creates text such as 10 | 20; it does not calculate 30. If your goal is a total, use a sum in a separate cell instead of merging the numeric cells.
Keep merged cells out of data-entry layouts. Merged headers may be convenient for presentation, but they can make keyboard navigation and selecting a precise range less predictable. A clear header above an unmerged data table is usually easier to maintain.

Troubleshooting

A warning says only the upper-left value will be kept. Choose Cancel. Combine the values first, paste the finished text into the upper-left cell, then merge. If you already continued, press Ctrl+Z on Windows or Command+Z on Mac immediately to undo the merge, provided you have not made other changes you need to keep.
The merged cell shows only one of the original entries. Excel probably discarded the other values during merging. Undo at once if possible. If undo is no longer available, restore the backup or recover the original values from the source data; Excel cannot reconstruct deleted contents from the merged cell alone.
The formula displays an error or the wrong text. Check that every cell reference points to the intended source cell and that the formula uses an ampersand between each part. Confirm that you did not include the helper cell in the range being merged. Inspect the formula result before pasting it as a value.
The combined text is correct but disappears after merging. The cell may be clipped by its row height or column width. Widen the column, increase row height, or turn on Wrap Text. Also check font color and cell formatting if the cell appears blank despite showing a value in the formula bar.
The merge command is unavailable. Check whether the worksheet is protected, whether the selected range is inside an Excel table, or whether you are editing a cell. Exit edit mode with Enter or Esc, unprotect the sheet if you have permission, or convert a table to a range using Table Design > Convert to Range. Consider whether merging is necessary before changing a table’s structure.
Excel says the selected cells have different sizes or an existing merge is involved. Unmerge existing merged cells first using Home > Merge & Center > Unmerge Cells, then select a consistent range. Review the contents after unmerging, because unmerge does not restore values that were discarded earlier.

Frequently Asked Questions

Can Excel merge cells and keep each value separately?
No. A merged cell can hold one value only. To preserve the information, combine the values into one text string and keep a backup of the separate entries, or use Center Across Selection to change the appearance without merging.

Does Merge & Center combine text automatically?
No. It centers the upper-left cell’s content across the merged area and discards the contents of the other selected cells. Join the values first, then merge.

Can I merge cells that contain numbers?
Yes, but merging does not add them. If you join numbers into a text value, they are displayed together with whatever separator you choose. If you need their total, calculate the total in a separate cell instead.

Can I undo a merge?
Choose Home > Merge & Center > Unmerge Cells, or use Ctrl+Z on Windows or Command+Z on Mac soon after the action. Unmerging restores the cell layout, but it does not bring back values Excel discarded when the cells were merged. Use undo immediately or restore a backup.

Why can’t I merge cells in my Excel table?
Excel does not allow merged cells in a structured table’s data area. Keep the table unmerged, or convert it to a normal range if merging is essential. For a centered heading, place it outside the table and use Center Across Selection where available.

What is the safest way to make a heading span several columns?
If the heading is only for appearance, use Center Across Selection so the underlying cells remain separate. If you need an actual merged cell, save a backup and merge only after confirming the upper-left cell contains all the text you want to keep.

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.