# How to Merge Cells in Excel Without Losing Data

Canonical URL: https://thinkquarry.com/how-to-merge-cells-in-excel/
Last modified: 2026-11-10T05:15:34+00:00

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

- Type your title in the first cell of the range. For example, type

Monthly Sales in A1.

- Verify that B1 through D1 are empty or that you have saved any

values they contain.

- Select A1:D1 and choose Home → Merge &

Center.

- 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.