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:
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
Best for: Single-cell span headers, dashboard titles, and report labels where center alignment is desirable.
Centering: Yes — automatic, always applied.
Access: Home tab → Alignment group → Merge & Center button (the main button, not the dropdown arrow).
Keyboard: Alt → H → M → C
Caution: Discards all content except top-left cell. Shows a warning before deleting.
Best for: Multi-row label layouts where you want each row to merge independently across the same columns.
Centering: No — keeps your existing alignment.
Access: Home → Alignment → Merge & Center dropdown → Merge Across. Only accessible from the dropdown arrow.
Keyboard: Alt → H → M → A
Caution: Each row merges separately. Great for invoice or form row-label designs.
Best for: Merging when you don't want Excel to override your existing text alignment settings.
Centering: No — preserves whatever alignment was already set.
Access: Home → Alignment → Merge & Center dropdown → Merge Cells. Dropdown only, no ribbon button.
Keyboard: Alt → H → M → M
Caution: Same data loss rules apply as Merge & Center.
Best for: Combining merge with other formatting (text wrap, indentation, precise alignment) in one dialog visit.
Centering: Your choice — you set horizontal and vertical alignment explicitly before clicking OK.
Access: Ctrl+1 → Alignment tab → check Merge cells checkbox. Also via right-click → Format Cells.
Keyboard: Ctrl+1, navigate to Alignment tab, check Merge cells.
Advantage: Most control; ideal for formatted report templates.
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):
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.
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.
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.
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.
These use cases work well with merged cells because the data isn't sorted, filtered, or used in analytical formulas.
Merging here will break Excel features or create maintenance headaches down the line.
This formatting trick gives the visual appearance of a merge without the functional drawbacks.
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.
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.
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 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.
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.
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.
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.