How to Merge Cells in Excel Without Losing Data

To merge cells in Excel without losing data, don’t use Merge & Center — it only keeps the top-left cell’s value and discards everything else. Instead, combine the values into one cell with a formula such as =A1&" "&B1, CONCAT, or TEXTJOIN, or use Center Across Selection to get the merged look without deleting any data.

As an expert in Microsoft Excel, I understand the challenges people face while working with this software. Merging cells in Excel without losing data can be tricky, especially when you are not aware of the right steps to follow. Thankfully, there are techniques to resolve this problem and achieve your desired outcome. In this article, I’ll explain how to merge cells in Excel without losing data, so you can save time and effort in your analysis and reporting.

Before You Merge Cells

Before we dive in, there are a few things you need to know. First, if you’re merging cells that are already populated, you should back up your file before attempting anything. This will serve as a safety net, allowing you to easily undo any merge errors or omissions without losing any data.

Secondly, it’s important to understand that merging cells will only affect the formatting of your spreadsheet, not your actual data. So if you’re worried about losing information during the merging process, rest assured that you won’t.

How to Merge Cells in Excel Without Losing Data

Step 1: Select the Cells You Want to Merge

To merge two or more cells in Excel, you’ll first need to select the cells you want to merge. To do this, click and drag your cursor over the cells you want to combine. Alternatively, you can hold down the “Shift” key while selecting cells to merge them into a single block.

Step 2: Locate the Merge Cells Button

To merge your selected cells without losing any data, you’ll need to find the “Merge & Center” button in Excel. This can be found on the “Home” tab in the “Alignment” group.

Step 3: Merge the Cells

Once you’ve located the “Merge & Center” button, click on it to merge your selected cells. Doing so will combine your cells into a single cell. Important: when more than one selected cell contains data, Merge & Center keeps only the value from the upper-left cell and discards the rest — Excel even warns you of this before merging. If you need to keep every value, use the formula-based methods described below to combine cells in Excel instead.

Avoid Common Pitfalls

While merging cells in Excel is a simple and straightforward task, there are some common pitfalls to watch out for.

Watch Out When Cells Already Contain Data

Merge & Center doesn’t care whether your cells hold text, numbers, or a mix — it will merge them regardless. The real catch is that when two or more selected cells contain data, it keeps only the upper-left value and discards the rest. Back up your sheet first, and use a formula to combine the cells if you need to keep every value.

Don’t Merge Hidden Cells

If any of the cells you want to merge are hidden, you’ll need to unhide them before attempting to merge them. Otherwise, Excel will not merge the cells and you’ll get an error.

Don’t Merge Cells That You Can’t See

If any of the cells you want to merge go beyond the visible range of your spreadsheet, you’ll need to scroll to view them before attempting to merge them. If you try to merge cells that are off-screen, you’ll run into an error.

Merging cells in Excel is a handy way to improve the formatting of your spreadsheet. By following the steps outlined above, you can merge cells without losing any data and avoid common pitfalls that can arise during the merging process. With practice, you’ll be able to merge cells with ease and optimize your Excel work.

Alternative Method: Using the “&” Character

Another method for merging cells in Excel without losing data is to use the “&” character to concatenate the cells’ values. Simply enter “=A1&B1” into a third cell, assuming A1 contains the first cell’s value and B1 contains the second cell’s value. This will merge the two cells into a single cell. To add a space between the values, use =A1&" "&B1. You can also use the CONCAT function (or the older CONCATENATE) for the same result, and the TEXTJOIN function when you want to join many cells at once with a chosen delimiter while ignoring blanks.

This method preserves every value because it reads the original cells rather than overwriting them, which is exactly what Merge & Center cannot do. Keep in mind that it won’t merge the cells’ formatting, so if you need to retain the original size, font, or color, you’ll still apply that separately.

Alternative Method: Center Across Selection

If your only reason for merging is to center a heading across several columns, you don’t need to merge at all. Select the cells, press Ctrl + 1 to open Format Cells, go to the Alignment tab, and set Horizontal to “Center Across Selection.” This visually centers your text across the range without combining the cells, so every cell keeps its own value and your spreadsheet stays easy to sort, filter, and reference. It’s often a better choice than Merge & Center for report titles. If your goal is simply to fit long text inside a cell, consider wrapping text or centering text instead.

Advanced Techniques: Using Macros to Merge Cells

If you find yourself merging cells frequently, you can consider using a macro to automate the process. With macros, you can create custom programs that carry out repetitive tasks in Excel, such as merging cells.

To create a merge cells macro, open your Excel spreadsheet and navigate to the “Developer” tab in the ribbon. From there, select “Record Macro” and follow the on-screen prompts to create your macro.

Once you’ve created your macro, you can run it whenever you need to merge cells without having to go through the manual “Merge & Center” process every time.

The Bottom Line

Merging cells in Excel is a simple and useful function when organizing your data. With the “Merge & Center” button and the “&” character method, you can easily combine values in cells, without erasing any precious information. Remembering to avoid common pitfalls such as merging cells with hidden or off-screen content, or different data types, you can confidently format your spreadsheets efficiently and accurately.

Frequently Asked Questions

Here are some common questions people ask about merging cells in Excel without losing data.

Can I merge cells without losing data?

Not with Merge & Center alone — when more than one cell contains data, it keeps only the upper-left value and discards the rest. To keep every value, combine the cells with a formula such as =A1&" "&B1, the CONCAT or CONCATENATE function, or TEXTJOIN, or use Center Across Selection so the cells only look merged. See our full guide on how to combine cells in Excel.

Does Merge & Center delete data?

Yes, when the selection contains more than one value. Merge & Center keeps the top-left cell’s contents and removes the others, which is why Excel shows a warning before it merges. If you only need the visual effect, use Center Across Selection (Format Cells > Alignment) instead, which leaves all values intact.

How do I combine two cells into one without losing either value?

Use a formula in a separate cell so the originals are read rather than overwritten. For example, =A1&" "&B1 joins two values with a space, and TEXTJOIN lets you join a whole range with a chosen delimiter while skipping blanks. Once you’re happy with the result you can copy it and Paste Special as values.

Can I merge cells with different data types?

Yes. Merge & Center works whether the cells contain text, numbers, dates, or a mix — Excel doesn’t require the data types to match. The only limitation is that it keeps just the upper-left value, so the data-type mix isn’t the problem; data loss is.

What is Center Across Selection and why use it instead of merging?

Center Across Selection centers text across several columns without actually merging the cells, so each cell keeps its own value and you avoid the sorting, filtering, and copy-paste headaches that merged cells cause. Find it under Format Cells (Ctrl + 1) > Alignment > Horizontal. It’s ideal for report titles and is a common alternative to merging when you also want to center text.

How do I undo or unmerge cells?

Select the merged cell and click Merge & Center again to toggle it off, or use the dropdown arrow next to the button and choose “Unmerge Cells.” Note that unmerging restores the cell structure but does not bring back values Merge & Center already deleted, so recover those from a backup. See how to unmerge cells in Excel for the full walkthrough.

Can I merge cells using a macro?

Yes, you can merge cells using a macro in Excel. Macros can help you automate repetitive tasks such as merging cells. To create a merge cells macro, navigate to the “Developer” tab in the ribbon, select “Record Macro” and follow the on-screen prompts to create your macro.