How to Merge Cells in Excel: 4 Methods (Step-by-Step)

What Merging Cells Actually Does

Merging cells in Excel combines two or more adjacent cells into a single, larger cell. The result spans the space of the original cells—but here's the catch: Excel only keeps the content from the top-left cell. Everything else gets discarded.

That sounds alarming, and honestly, it should give you pause. But merging is genuinely useful in the right situations. You'll typically see it for:

• Report headers — a title like "Q1 Sales Summary" stretched across columns A through E
• Form layouts — label fields that need to span multiple columns
• Dashboard labels — section dividers that visually group data
• Presentation formatting — making a sheet look clean before printing

The key distinction is context. Merging works great on structural cells—titles, labels, decorative elements. It breaks badly on data cells you intend to sort, filter, or reference in formulas. We'll cover both angles below.

Before diving into methods, know that Excel offers four distinct ways to merge. Each behaves slightly differently, and picking the wrong one wastes time. Some center the content automatically, others don't. Some merge the full selection into one block, others work row by row. Knowing which tool fits which job saves you from going back and undoing an awkward merge. Let's walk through all four options so you can make that call confidently every time.

Method 1: Merge & Center (The Most Common Approach)

This is what most people reach for first—and for good reason. Merge & Center is a single click that merges your selected cells and centers the content horizontally. It's on the Home tab, right in the Alignment group.

Step-by-step

1. Select the cells you want to merge. Click the first cell, hold Shift, then click the last cell in the range.
2. Go to the Home tab on the ribbon.
3. In the Alignment group, click the Merge & Center button (it shows a small merge icon with a center-align symbol).
4. If any of your selected cells contain data beyond the top-left cell, Excel will warn you that merging will delete that data. Click OK to proceed—or Cancel if you want to back up first.
5. Done. Your cells are merged and the content is centered.

The merged cell behaves as one unit. You can resize it by dragging the column/row border, format it like any other cell, and reference it in formulas using its top-left address (e.g., =A1 if you merged A1:C1).

One thing to watch: Merge & Center always centers. If you want the text left-aligned after merging, just click the Left Align button on the Home tab after merging. The merge itself won't undo—alignment and merge are independent properties.

Toggling Merge & Center off

Clicking Merge & Center a second time on an already-merged cell will unmerge it. The content returns to the top-left cell. This is the fastest unmerge method if you're already in the Home tab.

Method 2: Merge Across (Row-by-Row Merging)

Merge Across is less well-known, but it's incredibly handy when you have multiple rows and want to merge each one independently. Instead of merging your entire selection into one giant cell, it merges each row separately—left to right—keeping the structure row-by-row.

When to use it

Imagine you have labels in column A spanning rows 1 through 5, and you want each label to extend across columns A to D without combining the rows. Merge & Center would smash all 20 cells into one. Merge Across merges A1:D1 into one cell, then A2:D2 into another, and so on—five merged rows, each independent. That's a very different result, and exactly what you need for side-by-side label layouts.

Step-by-step

1. Select the full range you want to merge—for example, A1:D5.
2. Go to Home → Alignment group.
3. Click the dropdown arrow on the right side of the Merge & Center button (the small downward-pointing triangle).
4. Select Merge Across from the dropdown menu.
5. Excel merges each row in your selection separately. You'll see the warning about data loss for any row where non-top-left cells have content.

The result: each row becomes a single merged cell spanning your selected columns, but the rows themselves remain distinct. You can still select and format them independently.

One common use: building a weekly schedule where each day's label spans a set of time-slot columns. Merge Across gives you a clean label row without collapsing all the time slots into one. It's worth experimenting with this method on a test sheet before using it in a real document—once you see how it behaves differently from Merge & Center, it clicks instantly.

Method 3: Merge Cells (No Centering)

Same as Merge & Center, but without the automatic centering. The content stays wherever it was—left-aligned, right-aligned, or whatever you had set before.

This is the right choice when you want the visual merge but don't want Excel overriding your alignment. Headers that you've already formatted left-aligned, for example, or cells with right-aligned numbers that also need to span multiple columns. Merge Cells gives you the span without touching your existing alignment settings.

Step-by-step

1. Select the cells to merge.
2. Click the dropdown arrow on the Merge & Center button (Home → Alignment group).
3. Choose Merge Cells.
4. Confirm the data loss warning if prompted.

You'll get a merged cell, but the text alignment stays exactly as it was. From here, you can manually set alignment however you like. This option is available only from the dropdown—there's no dedicated ribbon button for it, and there's no way to set it as a default. You always go through that dropdown arrow.

Method 4: The Format Cells Dialog (Ctrl+1)

This is the most precise method—and the most overlooked. The Format Cells dialog gives you full control over alignment, text wrapping, indentation, and merging all in one place. It's especially useful when you're already in the dialog for other formatting reasons.

Step-by-step

1. Select the cells you want to merge.
2. Press Ctrl+1 to open the Format Cells dialog. (You can also right-click → Format Cells.)
3. Click the Alignment tab.
4. Under the Text control section, check the box labeled Merge cells.
5. While you're here, set your Horizontal and Vertical alignment as needed—center, left, right, top, middle, bottom.
6. Click OK.

The advantage: you're combining the merge with other formatting changes in a single dialog visit. Less clicking around the ribbon, more control over the final result.

This method also doesn't default to centering—you set the alignment explicitly, which makes the outcome more predictable. Professionals who format complex reports often prefer this approach because it's deliberate. You can even apply text wrapping, shrink-to-fit, and indentation at the same time—all without visiting the ribbon multiple times.

Keyboard Shortcuts for Merging Cells

There's no single built-in shortcut that merges cells directly, but Excel's ribbon shortcuts get you there fast. Here's the sequence:

Alt → H → M → M

Press and release each key in sequence (not simultaneously):

• Alt — activates the ribbon key tips
• H — selects the Home tab
• M — opens the Merge & Center dropdown
• M — selects "Merge Cells" (no centering)

For Merge & Center specifically: Alt → H → M → C

For Merge Across: Alt → H → M → A

For Unmerge Cells: Alt → H → M → U

These are access key sequences, not chords—you tap them one at a time. Once you've done it a few times, it becomes muscle memory. Much faster than reaching for the mouse, especially if you're keyboard-heavy in your workflow.

You can also record a macro and assign it to a custom shortcut like Ctrl+Shift+M if you merge cells constantly. That's overkill for occasional use, but worth knowing if it's a daily task. The macro approach also lets you combine merge with specific formatting in one keystroke—useful for templated reports where you always merge with the same font and fill color. Recording the macro takes about two minutes: Developer tab → Record Macro → perform the merge → Stop Recording → assign shortcut.

How to Unmerge Cells

Unmerging is just as straightforward as merging—once you know where to look. When you unmerge, Excel splits the merged cell back into individual cells. The content goes to the top-left cell only. The other cells come back empty.

Three ways to unmerge

1. Merge & Center toggle: Select the merged cell, click Merge & Center again. It unmerges immediately.
2. Dropdown menu: Select the merged cell → Home → Merge & Center dropdown → Unmerge Cells.
3. Keyboard: Select the merged cell → Alt → H → M → U.

If you need to unmerge an entire sheet's worth of merged cells at once, here's a quick way: press Ctrl+A to select all cells, then click Merge & Center dropdown → Unmerge Cells. That strips all merges from the sheet in one shot—handy when inheriting a badly formatted file from a colleague who loved merging everything in sight.

After unmerging, you'll often have empty cells where the merged span used to be. If you need to fill those gaps—say, for use in a PivotTable—select the column, press F5 → Special → Blanks → OK, then type = and press the Up arrow, then Ctrl+Enter. That fills all blank cells with the value from the cell above. A proper data cleanup trick worth keeping in your toolkit.

Finding All Merged Cells in a Workbook

Before you can fix or unmerge cells, you need to find them—especially in large files you didn't create yourself. Excel doesn't highlight merged cells by default, but there's a quick method using the Find feature.

Press Ctrl+F to open Find, then click Options to expand the dialog. Click the Format button next to the "Find what" field. In the Format Cells dialog that opens, go to the Alignment tab and check Merge cells. Click OK, then click Find All. Excel will list every merged cell in the active sheet in the results pane—you can click any result to jump to it, or select all of them and unmerge in one action.

If you're comfortable with VBA, a macro can loop through all cells and log merged ranges to a new sheet. But the Find method is fast enough for most cases and doesn't require any coding.

Why Merged Cells Break Sorting and Filtering

This is where a lot of people run into trouble. Merged cells and Excel's data tools don't play nicely together—and it's not a minor inconvenience. It can completely block operations you rely on.

Sorting

Try to sort a column that contains merged cells and Excel throws an error: "To do this, all the merged cells need to be the same size." Even if they are the same size, sorting reorders rows in ways that split your merged cell across different positions—which Excel won't allow. The sort fails entirely, not just for the merged rows.

Filtering

AutoFilter on a column with merged cells only shows the first row of each merged block. The other rows get hidden, even if they're not matched by the filter. Your data effectively disappears, and there's no clean way to recover the view without removing filters and fixing the merges. This is one reason Excel MVPs almost universally advise keeping raw data tables completely free of merged cells.

Formulas and references

Formulas that reference merged cells use the top-left cell address. That's usually fine. But if you're dragging a formula down a column and some cells in the reference range are merged, the fill behavior gets unpredictable—you might get repeated values, blank references, or outright errors. Dynamic array formulas like XLOOKUP and FILTER are particularly sensitive to this.

PivotTables and Power Query

Both tools expect flat, unmerged data. Merged cells in source data cause import errors or silently wrong aggregations. Always unmerge before feeding data into a PivotTable or Power Query.

The Center Across Selection alternative

If you want text to look centered across multiple columns without actually merging, use Center Across Selection. It's in the Format Cells dialog (Ctrl+1 → Alignment tab → Horizontal dropdown → Center Across Selection). This gives the visual effect of a centered header spanning multiple columns—without any merging. Sorting, filtering, and formulas all work normally. It's the professional's choice for data tables that need to stay sortable.

Practical Use Cases and Excel Skill Building

Merging cells is one of those Excel skills you'll use constantly once you understand it—and equally, you'll know when not to use it, which is just as valuable. Report headers, invoice layouts, form templates, and dashboard section labels are all legitimate candidates. Data tables, sortable lists, and anything feeding a PivotTable are not.

Mastering cell formatting—merging, alignment, conditional formatting—is a core part of any Excel practice test or certification exam. Microsoft Office Specialist (MOS) exams test exactly this kind of formatting knowledge. If you're preparing for certification, you'll want to practice both the technique and understanding why certain approaches are preferred over others.

Our Excel certification practice test covers formatting, formulas, data management, and more—worth bookmarking alongside your study notes.

If you've been using Excel primarily for formatting and want to expand into data analysis—digging into vlookup excel functions, XLOOKUP, and dynamic arrays—that's a worthwhile next step. For those just getting started, our guide on how to download Microsoft Excel covers all the official options, including free web versions.