Merge Cells Within Regions in Excel: Steps and Limits

Yes. In Excel for Microsoft 365 on Windows, you can merge cells within a region by selecting a single rectangular range and choosing Home > Merge & Center. To merge several separate regions, handle each range separately; Excel does not merge multiple non-adjacent selections in one operation, and merging can discard values outside the range’s upper-left cell.

What “regions” means in Excel

Excel does not have a special command called merge cell zones within regions. People often use region to mean a block of cells, such as a report heading, a table section, or a group of rows that share a label. The instructions depend on whether the cells form one continuous rectangle or several separate blocks.

A rectangular selection such as B2:D2 is one range. A selection containing B2:D2 and B5:D5 is a non-adjacent selection, because the ranges are separated. A common task is to merge each row of a block horizontally, or to combine a heading across several columns. Those are different operations, so decide what the finished layout should look like before merging.

Merging is a formatting and layout feature, not a way to combine a data table’s records. It changes the cell structure: several cells become one larger cell. It does not concatenate their contents. If the goal is to join text or values, use a formula or another data-combining method instead.

How Excel’s merge options work

In Excel for Microsoft 365 on Windows, the merge commands are on the Home tab in the Alignment group, under the Merge & Center menu. The available choices have distinct effects:

Merge & Center combines the selected cells into one cell and centers the retained content.
Merge Across merges cells horizontally within each row of the selected range. For example, selecting B2:D4 and choosing this option creates one merged cell in each of rows 2, 3, and 4.
Merge Cells combines the selection without applying the centering behavior of Merge & Center.
Unmerge Cells reverses the merged layout and restores the individual cells, though it cannot restore values that were discarded when merging.

These commands do not add together or join the contents of all selected cells. When a selection contains multiple non-empty cells, Excel keeps the value in the upper-left cell of the selected range and removes the other values from the merged result. Excel normally displays a warning before discarding those values. Read it carefully, especially in a workbook you did not create.

Steps to merge a single region

For a title or label that needs to span a contiguous block, use these steps in Excel for Microsoft 365 on Windows:

Select the rectangular range to merge, such as B2:D2. Check that the range does not include values you need to keep separately.
Open the Home tab. In the Alignment group, open the Merge & Center drop-down.
Choose Merge & Center, Merge Cells, or another option that matches the intended layout.
If Excel warns that the selection contains multiple values, stop and review the cells. Cancel if the removed values are important; otherwise, confirm only when you intend to keep the upper-left value.
Check the result, including the text alignment and row height. Adjust alignment or column widths if necessary.

For a heading across several columns in one row, select only the cells on that row. For a label that should occupy one merged cell per row, select the full rectangular block and use Merge Across. Using Merge & Center on a multi-row block instead creates one large merged area, not one merge per row, which is a frequent source of unexpected layouts.

On Excel for Mac, the merge controls are also on the Home tab, in the Alignment area, although the ribbon layout can vary with the window size and Excel version. The same warning about retained content applies. If a command is not visible, expand the ribbon or look for the merge options in the Home tab rather than assuming that selecting cells has merged them automatically.

Merging several separate regions

If you have multiple zones in different parts of a worksheet, select and merge each rectangular range separately. For example, to merge B2:D2 and B8:D8, first select B2:D2 and apply the chosen merge command, then repeat for B8:D8. This is predictable and lets you check each heading before changing the next one.

Excel’s merge commands are designed for a single contiguous selection. If you select non-adjacent ranges—for example, by holding Ctrl while selecting separate areas on Windows—the merge command may be unavailable or Excel may reject the operation. Do not assume that a multi-selection will apply the merge independently to every area.

For a long worksheet with many repeated layout blocks, consider whether the merges are necessary. Repeating a command manually can be appropriate for a small report, but applying merges across many sections by hand is easy to get wrong. A consistent unmerged layout, with alignment or borders providing the visual grouping, is often easier to maintain.

Risks for data, sorting, and formulas

The most important risk is losing cell contents. If B2 contains a heading and C2 contains a date, merging B2:C2 retains the value from B2; the date in C2 is not appended to it. Copy or move any information that must be preserved before merging. Undo can reverse a recent merge, but once you continue editing or save and close the workbook, recovery may not be straightforward.

Merged cells can also make routine spreadsheet operations less convenient. A rectangular data table should generally have one value per cell, with consistent rows and columns. Merged cells inside the table can interfere with sorting, filtering, copying, pasting, selecting ranges, and filling formulas. Excel may refuse some operations when merged and unmerged cells do not have matching shapes.

For example, a report may have a merged heading above a table, which is usually less troublesome than merging cells inside the table’s records. Keep the actual data area unmerged when possible. If a label appears to cover several rows, repeat the label in each row, use a separate label column, or use formatting to make the grouping clear without changing the cell structure.

Alternatives that preserve the cells

If the purpose is only to make text look centered across several columns, try Center Across Selection. It keeps the cells separate, unlike merging, and can avoid some problems with later editing. Select the cells, open the Format Cells dialog, go to the Alignment tab, and choose Center Across Selection in the Horizontal alignment list. In Excel for Windows, you can open Format Cells with Ctrl+1; on a Mac, the shortcut is typically Command+1.

Center Across Selection is useful for a title that should appear visually centered over a row of columns while leaving the underlying cells intact. It does not create one larger cell, and the text must be in the leftmost cell of the selected range. Because the cells remain separate, it is generally a more flexible choice for worksheets that may later be sorted, copied, or expanded.

Other options depend on the goal:

To combine text from several cells, use a concatenation formula or edit the text into one cell; merging alone does not join values.
To show a group label beside records, use a dedicated column and repeat or otherwise structure the label consistently.
To distinguish sections, use borders, fill colors, font weight, or spacing instead of merging cells inside a data table.
To center a label within a single cell, use the horizontal alignment controls rather than merging neighboring cells.

Choosing the right method

Use merging when the worksheet is primarily a presentation or print layout, the selected cells form one rectangle, and only the upper-left cell needs to contain content. A report title spanning several columns is a typical example. Use Merge Across when each row in a selected block should become its own horizontal merged area.

Prefer separate cells or Center Across Selection when the region contains records that users may sort, filter, edit, or reuse. Ask what someone will need to do with the sheet later: a visually polished heading may be worth merging, but a merged cell in the middle of a sortable list can create avoidable friction. It is also useful to distinguish a worksheet’s decorative region from its underlying data range; the two do not need the same formatting.

Before making a large set of layout changes, save a copy of the workbook or make a small trial in a duplicate sheet. This is especially helpful if the workbook contains formulas, shared templates, or data that other people rely on. Check the result in the normal worksheet view and, if the sheet is intended for printing, in Print Preview as well.

Common problems and fixes

The merge option is disabled. Check whether the selection includes multiple separate areas, whether the sheet is protected, or whether Excel is currently editing a cell. Select one contiguous rectangular range, finish editing, and check the sheet protection settings if the command remains unavailable.

Excel kept the wrong value. Merging preserves the upper-left cell’s content, not whichever cell you clicked last. If the merge is still the most recent action, use Undo. Otherwise, unmerge the cells and restore the needed values from a copy, version history, or another source if available.

The text looks off-center or is cut off. Merge & Center applies centering, while Merge Cells does not necessarily do so. Set alignment separately, and check the row height, column width, text wrapping, and neighboring cells. A merged area can still display text poorly if its dimensions are too small.

Sorting or filtering stops working smoothly. Look for merged cells within the data range. Unmerge them and restructure the table so each record uses the same columns. Decorative merges above the table are less likely to cause issues than merges among the records themselves.

Frequently Asked Questions

Can I merge multiple separate regions at once in Excel?
Not reliably with Excel’s standard merge command. The command is intended for one contiguous range. Select and merge each region individually, or avoid merging if the same appearance can be achieved with alignment or formatting.

Does Merge Across merge each row separately?
Yes. When applied to a rectangular selection, Merge Across creates a horizontal merge in each row of that selection. It does not create one large merged cell across all the rows.

Will Excel combine the text in every cell I merge?
No. Excel keeps the content from the selection’s upper-left cell and removes other cell contents from the merged result. Copy or combine those values first if you need to retain them.

Is Center Across Selection the same as merging?
No. It centers text visually across the selected cells while leaving the cells separate. That can make later editing and data operations easier, but it does not turn the range into one cell.

Can merged cells cause problems when sorting a table?
They can. Merged cells inside a data range can prevent or complicate sorting, filtering, pasting, and other operations. Keep the table itself unmerged when it needs to behave like structured data.

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.