Ways to Merge Excel Cells Step by Step – 2025

Ways to Merge Excel Cells Step by Step

Microsoft Excel is a powerful spreadsheet application used for organizing, analyzing, and presenting data. One common formatting task that many users need is merging cells. Merging cells allows you to combine two or more adjacent cells into a single larger cell, which is especially useful for titles, headers, labels, and improving the visual layout of a worksheet.

Although merging cells seems simple, it can affect data structure, alignment, sorting, and formulas if not used correctly. This guide explains how to merge cells in Excel using different methods, the types of merge options available, best practices, and common problems you may encounter.

What Does Merging Cells Mean in Excel?

Merging cells means combining multiple adjacent cells into one single cell. When cells are merged:

• Only the data from the upper-left cell is kept

• Data in other cells is deleted

• The merged cell spans across rows or columns

This feature is mainly used for formatting and presentation rather than data processing.

Why Use Merge Cells in Excel?

There are several practical reasons for merging cells.

Create Clear Headers

Merged cells are commonly used to create titles across multiple columns, such as report headings.

Improve Visual Layout

Merging helps center text across columns and makes spreadsheets easier to read.

Organize Grouped Data

When several columns belong to the same category, merged headers make the structure clearer.

Despite these advantages, merging cells should be used carefully, especially in data-heavy worksheets.

How to Merge Cells Using the Ribbon

The most common way to merge cells is through the Excel Ribbon.

Steps to Merge Cells

1. Open your Excel worksheet

2. Select the cells you want to merge

3. Go to the Home tab

4. In the Alignment group, click Merge & Center

The selected cells will be merged into one, and the content will be centered automatically.

Important Note

If the selected cells contain data in more than one cell, Excel will warn you that only the data in the top-left cell will be kept.

Different Merge Options in Excel

Excel offers several merge options beyond “Merge & Center.” These can be accessed by clicking the arrow next to the Merge button.

Merge & Center

This option merges cells and centers the text both horizontally and vertically. It is ideal for titles and headings.

Merge Across

This option merges cells across each row separately rather than combining all selected cells into one.

When to Use Merge Across

• When merging headers across multiple columns

• When working with multiple rows of similar data

Merge Cells

This option merges cells without changing text alignment. The content remains aligned based on its original setting.

Unmerge Cells

This option separates merged cells back into individual cells. The data remains in the upper-left cell after unmerging.

How to Merge Cells Without Losing Data

A major limitation of Excel’s merge feature is that it removes data from all but one cell. To preserve all content, you can use formulas.

Use CONCAT or TEXTJOIN

1. Insert a new cell

2. Use a formula such as:

3. Copy the result

4. Paste it as values

5. Merge the original cells

This method ensures that no data is lost.

Merge Cells Using Keyboard Shortcuts

Excel allows you to merge cells using keyboard shortcuts for faster workflow.

Shortcut for Merge & Center

1. Select the cells

2. Press Alt + H

3. Press M

4. Press C

Shortcut for Unmerge Cells

1. Select the merged cell

2. Press Alt + H

3. Press M

4. Press U

These shortcuts save time when formatting large spreadsheets.

Merge Cells in Excel Online

Excel Online has limited functionality compared to the desktop version, but merging cells is still supported.

Steps in Excel Online

1. Select the cells

2. Click the Home tab

3. Choose Merge & Center

Some advanced merge options may not be available in the online version.

Problems Caused by Merged Cells

While merging cells improves appearance, it can cause issues in certain situations.

Sorting and Filtering Issues

Merged cells prevent proper sorting and filtering. Excel requires consistent cell structures to perform these actions.

Formulas and References

Merged cells can cause errors in formulas, especially when referencing ranges.

Data Entry Difficulties

Merged cells make it harder to select individual rows or columns for data input.

Because of these limitations, merging should be used mostly for headings and labels rather than data tables.

Alternative to Merging Cells: Center Across Selection

A better alternative for formatting headers is using Center Across Selection.

How to Use Center Across Selection

1. Select the cells

2. Press Ctrl + 1 to open Format Cells

3. Go to the Alignment tab

4. Under Horizontal, select Center Across Selection

5. Click OK

This visually centers text across multiple cells without merging them, avoiding most problems associated with merged cells.

How to Unmerge Cells in Excel

If you need to revert merged cells:

Steps to Unmerge

1. Select the merged cell

2. Go to the Home tab

3. Click Merge & Center again

The cell will be split back into individual cells.

Best Practices for Merging Cells

To avoid problems, follow these best practices:

Use Merging Only for Headings

Avoid merging cells in data tables.

Avoid Merging Cells You Plan to Sort

Sorting merged cells can cause errors.

Consider Alternatives

Use “Center Across Selection” when possible.

Check Before Sharing

Ensure merged cells don’t interfere with others using the file.

Common Issues and Solutions

Merge Button Is Grayed Out

This usually happens when the worksheet is protected. Unprotect the sheet first.

Data Disappears After Merging

Excel keeps only the top-left cell. Use formulas to combine data first.

Cannot Select Individual Cells

Unmerge the cells or redesign the layout.

Conclusion

Merging cells in Microsoft Excel is a simple yet powerful formatting feature that helps improve the appearance and structure of worksheets. Whether you’re creating headers, titles, or grouped labels, understanding how and when to merge cells is essential for maintaining a clean and functional spreadsheet.

By using the correct merge options, keyboard shortcuts, and best practices—and by considering alternatives like Center Across Selection—you can format your Excel sheets effectively without causing data or functionality issues.