Merge Cells Quickly in Excel: Steps and Alternatives

In Excel for Microsoft 365 on Windows, select the cells you want to combine, then choose Home > Merge & Center. For the quickest keyboard route, press Alt, then H, M, C in sequence. Before merging, check that only the upper-left cell contains information you need: Excel keeps that cell’s contents and removes the contents of the others.

Quick steps to merge cells

To merge a group of adjacent cells into one larger cell, select the range and use the Merge & Center control on the Home tab. The command combines the selected cells and centers the remaining content in the new area. For example, select B1:D1 and choose Merge & Center to make a single heading cell spanning three columns.

Select the adjacent cells to merge. They can span columns, rows, or both, but must form one continuous rectangular selection.
On the Home tab, find the Alignment group and open the dropdown beside Merge & Center.
Choose Merge & Center, Merge Cells, or another option that matches the layout you want.

Merge & Center combines the cells and centers their displayed content. Merge Cells combines them without applying horizontal centering. If you want to combine each row separately across the selected columns, choose Merge Across. The selection’s top-left cell supplies the content for a single merged range; with Merge Across, each row’s leftmost cell supplies the content for that row’s merged area.

What the merge options do

The dropdown gives you more than one kind of merge, so it is worth choosing deliberately. Merge & Center is designed for a heading that should appear centered over several columns. Merge Cells creates a larger cell but does not center the content horizontally. You can adjust alignment separately using the alignment controls on the Home tab.

Merge & Center: Combines the selected range into one cell and centers its content.
Merge Across: Merges cells row by row, rather than turning the entire selection into one cell.
Merge Cells: Combines the entire selected range into one cell without automatically centering its content.
Unmerge Cells: Splits a merged cell back into separate cells.

For instance, selecting A1:C3 and choosing Merge Across creates three merged cells: A1:C1, A2:C2, and A3:C3. Choosing Merge & Center on the same selection instead creates one merged area covering all nine cells. That distinction matters when you are formatting several row labels or section headers at once.

Use the keyboard shortcut

In Excel for Microsoft 365 on Windows, Alt, H, M, C activates Merge & Center through the ribbon KeyTips. Press the keys in sequence rather than holding them all down together: Alt opens the KeyTips, H selects Home, M opens the merge commands, and C chooses Merge & Center. This is useful when your hands are already on the keyboard, but the sequence is easier to remember after a little practice.

The related KeyTip choices include Alt, H, M, A for Merge Across, Alt, H, M, M for Merge Cells, and Alt, H, M, U for Unmerge Cells. KeyTips can vary between versions or with ribbon changes, so if a letter does not match what you see, press Alt and follow the letters displayed on your screen. On Mac, use the Home tab’s Merge & Center dropdown; Windows Alt-based KeyTips should not be assumed to work the same way.

What happens to existing cell contents

Merging is a layout operation, not a way to join text or preserve all the values in a range. When several nonempty cells are selected, Excel warns that it will keep only the upper-left cell’s contents. If you confirm, the other selected contents are deleted. For example, merging A1:C1 when A1 contains North, B1 contains Central, and C1 contains South keeps North; it does not produce North Central South.

If you need to retain several values, combine or copy them before merging. You could, for example, create a separate heading containing the combined text, verify it, and then merge the display range. Keep a backup or undo immediately if you merged by mistake: Ctrl+Z on Windows reverses the action while it remains in the undo history. Merging and unmerging later does not bring deleted contents back.

After a merge, the value belongs to the upper-left cell of the merged range. The range may look like a single broad cell, but it is still important to know its address when writing formulas or building a report. Other cells in the range no longer hold independent values while it is merged.

When merging is useful

Merging can be appropriate for a static report or a printed worksheet where a title needs to span a set of columns. A heading such as Quarterly Sales could span B2:E2 above four quarter columns. It can also help create a visual section label in a worksheet that is mainly for reading rather than sorting, filtering, or ongoing data entry.

Use it sparingly in the body of a data table. A well-structured list usually has one value per cell, one record per row, and consistent column headings. Merged cells interrupt that regular grid, which can make routine operations harder. A useful rule is to keep merge formatting in decorative title or section areas, and leave the actual dataset unmerged.

A safer alternative: Center Across Selection

If your goal is only to center a heading over several columns, Center Across Selection often gives the same appearance without combining cells. Select the cells, open Format Cells, choose the Alignment tab, and set the Horizontal option to Center Across Selection. On Windows, Ctrl+1 opens Format Cells; on Mac, Command+1 is the usual shortcut. The cells stay separate, so each can still be selected and used independently.

This can be a better choice when a worksheet may later be sorted, edited, or used as a source for other analysis. The visual heading can span the selected columns while the underlying grid remains intact. It does not join any contents, either: the text to center should be in the leftmost cell of the selected range. If the Center Across Selection setting is not suitable for the layout, use ordinary alignment or a text box instead of merging data cells.

Common problems and limitations

A merge command may be unavailable or behave differently than expected for a few common reasons. First, Excel tables do not support merged cells within the table. If the selected range is part of a formatted table, convert the table to a normal range or keep the cells unmerged; preserving the table is generally more useful for structured data. The table’s features include consistent columns and tools such as filtering, which are a poor fit for irregular merged cells.

Second, sorting a range containing merged cells can be blocked or produce an error when the merged areas do not line up consistently. Filtering and selecting rows can also become confusing because a merged area visually spans multiple cells or rows. If you need to sort or filter the information, unmerge the data area and use a normal table-like structure instead.

Third, a merged heading can appear clipped if the row is too short or the text is too long. Adjust the column widths or row height, or use text wrapping if appropriate. AutoFit may not size merged cells as expected, so changing the dimensions manually can be more reliable. Also check horizontal and vertical alignment: merging does not automatically place content exactly where you want in every direction.

How to unmerge cells

Select a merged cell and choose Home > Merge & Center dropdown > Unmerge Cells. You can also use the Windows KeyTip sequence Alt, H, M, U. Unmerging restores the individual cells in the range, but it does not restore values that were discarded when the range was first merged. The surviving value remains in the upper-left cell; the newly separate cells are otherwise blank unless they already had formatting or content preserved by the operation.

If you have a large worksheet, use Find to locate merged cells before changing the layout. Press Ctrl+F on Windows, open Options, and use the Format search criteria to search for the relevant cell format when needed. Finding every merge can be less straightforward than locating ordinary values, so review the affected sheet and keep an original copy before a broad cleanup.

Good habits for readable worksheets

Before merging, ask whether the cells are part of a dataset or just a presentation heading. Confirm that the upper-left value is the one you want to keep, and decide whether Merge Across or a simple alignment option is a better fit. After the change, check how the sheet looks at normal zoom and in print preview, especially if the heading is long or spans several columns.

For reusable workbooks, consistent formatting is usually more helpful than many different merged areas. If people will enter new records, filter lists, or sort columns, preserve the standard grid. If the worksheet is a fixed summary intended for display, a few carefully chosen merges can make its hierarchy easier to scan.

Frequently Asked Questions

What is the fastest way to merge cells in Excel?
Select the range and choose Home > Merge & Center. On Windows, Alt, H, M, C is the keyboard KeyTip sequence for the same command.

Does merging cells combine their text?
No. Excel keeps the content from the upper-left cell and warns that the contents of other selected cells will be removed. Combine needed text separately before merging.

Can I merge cells without centering the text?
Yes. Choose Merge Cells from the dropdown, then set the alignment you want. For a centered heading that keeps cells separate, use Center Across Selection in Format Cells instead.

Why is Merge & Center unavailable?
A frequent cause is that the selected cells are inside an Excel table, where merged cells are not supported. Check whether the selection is part of a table, or select a range outside it.

Can I sort or filter merged cells?
Merged cells can interfere with sorting and make filtering less predictable, particularly when merged areas differ in size or span rows. For sortable or filterable data, unmerge the range and keep one value in each cell.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.