How to Merge Cells in Excel Without Losing Data

Quick answer. Select adjacent cells and choose
Home → Merge & Center. Before merging, copy any
values you need from the selected range. In a left-to-right worksheet,
Excel keeps the upper-left cell’s content when the range is merged.

Merge cells for a report
heading

1. Type your title in the first cell of the range. For example, type
   Monthly Sales in A1.
2. Verify that B1 through D1 are empty or that you have saved any
   values they contain.
3. Select A1:D1 and choose Home → Merge &
   Center.
4. Check that the title spans the columns and that the table below
   remains unchanged.

Use the dropdown next to Merge & Center for
related options. Merge Cells joins the selected range
without applying the centering action. Merge Across
merges each selected row separately, which is useful when several rows
each need their own wide label. Microsoft’s
merge and unmerge guide

Combine the contents
of two cells instead

If A2 contains Nadia and B2 contains
Khan, merging A2 and B2 can discard
Khan. To keep both values, enter this formula in a
separate cell:

=A2&" "&B2

The result is Nadia Khan. Keep the original columns
if you still need to sort, filter, or update first and last names
separately. If you only need the result text, copy the formula output
and paste it as values before removing the source columns.

Unmerge cells and check the
result

Click the merged cell and choose Home → Merge & Center →
Unmerge Cells. The merged value stays in one cell. Unmerging
does not restore text that was discarded during the merge. If you just
made the change, try Undo before continuing.

Fix a disabled Merge &
Center option

Exit cell editing mode, then check whether the selected range is part
of a formatted Excel table. Merging may be unavailable inside the table.
Place the merged heading above the table if it is only decorative. Keep
one value per cell inside data you regularly sort or filter.

If the real problem is that columns are in the wrong order, use the
ThinkQuarry
guide to moving Excel columns before changing the heading
layout.

For a report that needs the same formatting every week, see how to record
an Excel macro.

Frequently asked questions

Can I
merge two cells in Excel without losing their text?

Combine the values with a formula in a separate cell first. A normal
merge preserves only one cell’s content.

What does Merge Across do?

It creates a separate merge for each selected row across the chosen
columns.

Why is Merge & Center
greyed out?

Check whether you are editing a cell or whether the selection is
inside an Excel table.

Does unmerging restore
deleted values?

No. Try Undo immediately after a mistaken merge or retrieve an
earlier copy of the file.

Should I
merge cells inside data I sort or filter?

Keep the data in individual cells and use a merged title above the
data if needed.