Merge Cells in Excel – Merge & Center, Merge Across, and Unmerge -

Have you ever created a report in Excel and wanted to add a professional-looking heading at the top?

You type Monthly Sales Report in the first cell, but it only appears inside that single cell. It doesn’t look like a proper title.

So, how do you make the heading stretch across multiple columns and appear neatly in the center?

That’s exactly what the Merge Cells feature is designed for.

With just a few clicks, you can combine two or more cells into one larger cell, making your worksheet look cleaner and more professional.

But there’s one important thing you should know. Excel doesn’t have just one merge option. It offers Merge & Center, Merge Cells, Merge Across, and Unmerge Cells, and each one works differently.

In this guide, you’ll learn what each option does, when to use it, and how to avoid common mistakes while merging cells.

What is Merge Cells?

Have you ever noticed that many Excel reports have large headings stretching across several columns?

That’s usually done using the Merge Cells feature.

Merge Cells allows you to combine two or more adjacent cells into a single larger cell. It’s mainly used for creating report titles, table headings, section names, and other formatting where you want the text to stand out.

For example, instead of displaying Monthly Sales Report only in cell A1, you can merge cells A1:D1 so the heading appears across the entire table.

Although merging cells is simple, it’s important to understand how each merge option works before using it.

How to Merge Cells in Excel?

Once you’ve decided where your heading should appear, merging the cells takes only a few seconds.

Let’s start with the easiest method.

Using Ribbon:

Select the cells you want to merge.

Go to the Home tab on the Ribbon.

In the Alignment group, click the Merge & Center drop-down button.

Choose the merge option you want.

Merge & Center: This merges the selected cells and aligns the text right in the center. Perfect for titles and headers.
Merge Across: Merges cells across rows but keeps the columns separate. Handy when you want row-wise merging.
Merge Cells: Combines the selected cells into one, but keeps the text left-aligned..
Unmerge Cells: Quickly separates merged cells back into individual ones.

Your selected cells will merge into one, and the text will be centered.

Using Keyboard Shortcut:

If you frequently use Merge Cells, keyboard shortcuts can save you time.

Alt + H + M + C → Merge & Center

Alt + H + M + M → Merge Cells

Alt + H + M + A → Merge Across

Alt + H + M + U → Unmerge Cells

Tip: You don’t need to press all the keys together.

Press Alt, release it, then press H, M, and the final letter one after another.

Understanding the Merge Options:

Excel provides four different merge options. Although they look similar, each one works differently.

Let’s understand them one by one.

1. Merge & Center:

This is the most commonly used merge option.

It combines the selected cells into one larger cell and automatically places the text in the center.

This option is perfect for:

Report titles
Table headings
Dashboard headings

Example:

Suppose you’ve created a Students list and want the title to appear across columns A to D.

Select A1:D1 and click Merge & Center.

Select cells AND Click Merge & Center to Merge Cells.

Excel merges all four cells into one large cell and centers the heading automatically.

2. Merge Cells:

The Merge Cells option also combines multiple cells into one larger cell.

The difference is that it doesn’t center the text.

The text remains in its current alignment.

This is useful when your text is already aligned the way you want and you don’t want Excel to center it automatically.

3. Merge Across:

Merge Across works a little differently.

Instead of creating one large merged cell, Excel merges each row separately.

This is useful when you’re formatting multiple rows at the same time.

For example, if you select A2:D5, Excel merges A2:D2, A3:D3, A4:D4, and A5:D5 separately.

It does not merge all the rows into one large cell. Instead, each row is merged independently.

4. Unmerge Cells:

Changed your mind?

No problem.

The Unmerge Cells option separates a merged cell back into individual cells.

After unmerging, only the value from the upper-left cell remains.

The other cells become empty.

Things to Remember:

Before You Merge Cells…

There’s one important thing every Excel user should know.

If the selected cells already contain data, Excel keeps only the value in the upper-left cell.

All the other values will be removed after you confirm the warning message.

Before merging cells, always check that you won’t lose any important information.

Merging cells can sometimes make sorting and filtering data tricky. Use it mainly for formatting and headings, not for raw data management.

Excel even displays a warning message before deleting the extra data.

Why Use Merge Cells?

Although Merge Cells is a simple formatting feature, it can make a big difference in how your worksheet looks.

You can use it to:

Create report titles
Design table headings
Organize dashboards
Highlight important sections
Improve the overall presentation of your worksheet

Did You Know?

Many experienced Excel users avoid merging cells inside large data tables.

That’s because merged cells can make sorting, filtering, copying, and using formulas more difficult.

For reports and headings, Merge Cells is a great choice. But for large datasets, it’s usually better to keep the cells separate.

Tips for Using Merge Cells:

Here are a few simple tips that can help you avoid common mistakes:

Use Merge Cells mainly for headings and titles.
Avoid merging cells inside data tables.
Check your data before merging because Excel removes everything except the upper-left value.
Use keyboard shortcuts to work faster.
If you accidentally merge the wrong cells, use Ctrl+Z immediately.

When Should You Avoid Merging Cells?

Merge Cells is great for creating titles and headings, but it isn’t always the best choice.

If you’re working with large datasets, tables, or information that needs to be sorted, filtered, or analyzed, it’s usually better to avoid merging cells.

Here’s why:

Sorting may not work properly if merged cells are included in the selected range.
Filtering data becomes difficult because merged cells can interfere with Excel’s filtering feature.
Copying and pasting data may not give the expected results.
Some formulas and Excel features don’t work well with merged cells.
Merged cells can make it harder for others to edit or analyze your worksheet.

If you’re creating reports, dashboards, or simple headings, Merge Cells works perfectly. But if you’re managing data that you’ll sort, filter, or use for calculations, keeping the cells separate is usually the better option.

Frequently Asked Questions (FAQs):

1. What is Merge Cells in Excel?

Merge Cells is a feature that combines two or more adjacent cells into a single larger cell.

2. What is the difference between Merge & Center and Merge Cells?

Merge & Center combines the cells and centers the text.
Merge Cells combines the cells but keeps the existing text alignment.

3. What does Merge Across do?

Merge Across merges each row separately instead of creating one large merged cell.

4. Can I unmerge cells later?

Yes. Use the Unmerge Cells option to separate the merged cell back into individual cells.

5. Will Excel delete my data when I merge cells?

Yes, if multiple cells contain data. Excel keeps only the value in the upper-left cell and removes the remaining values after showing a warning message.

The Merge Cells feature may seem like a small formatting tool, but it can make your worksheets look much cleaner and easier to read. Whether you’re creating a simple table, a professional report, or a dashboard, using the right merge option helps present your data more effectively.

Now that you understand the difference between Merge & Center, Merge Cells, Merge Across, and Unmerge Cells, you’ll know exactly which option to use for every situation.

Continue learning Excel Basics:

Discover more from

Subscribe to get the latest posts sent to your email.

Merge Cells in Excel – Merge & Center, Merge Across, and Unmerge

What is Merge Cells?