Excel Merge Across vs. Merge Cells: Key Differences

Merge Across makes a separate merged cell for each row in your selection, while Merge Cells combines the entire selection into one cell. In Excel for Microsoft 365 on Windows, select the cells, then choose Home > Merge & Center ▼ > Merge Across or Merge Cells, depending on the layout you need.

What Merge Across and Merge Cells do

These commands are in the same Home tab menu, but they produce different cell structures. Suppose you select B2:D4, a range three columns wide and three rows tall. Merge Across merges B2:D2, B3:D3, and B4:D4 separately. You end up with three merged cells, one on each row. Merge Cells instead combines all nine selected cells into a single merged cell covering B2:D4.

The difference is about the shape of the result, not the text being joined. Neither command combines the contents of multiple cells into a sentence. A merged cell has one usable value location: the upper-left cell of the merged range. The other cells become part of the merged area rather than remaining separate places to store data.

It also helps to distinguish both commands from Merge & Center. That command combines the selection into one cell and centers its content. Merge Cells combines the selection without applying that centering behavior. Merge Across merges each row separately and does not, by itself, mean “combine the words from these cells.”

How to use each command

In Excel for Microsoft 365 on Windows, select the range, open the drop-down arrow beside Merge & Center on the Home tab, and choose the command. The main Merge & Center button is not the same as the drop-down choices: clicking the main button applies Merge & Center, whereas the arrow exposes options such as Merge Across and Merge Cells.

For separate row headings: select the range spanning the columns and rows you want to format, then choose Home > Merge & Center ▼ > Merge Across.
For one heading over a rectangular area: select the whole area and choose Home > Merge & Center ▼ > Merge Cells.
To undo a merge later: select the merged cell or range and choose Home > Merge & Center ▼ > Unmerge Cells.

On Excel for Mac, the merge controls are also on the Home tab, though their placement can vary with the ribbon layout. Open the Merge & Center menu to find the merge options. The Format Cells dialog opens with Command+1 on Mac; on Windows, use Ctrl+1. Excel for the web also offers merge controls on Home, although screen layout and available options can differ from the desktop app.

What happens to existing data

Merging is a formatting and layout operation, not a data-concatenation operation. If several cells in the selection contain values, Excel keeps the value in the upper-left cell of the relevant merged area and discards the contents of the other cells. Excel may display a warning before it proceeds. For Merge Across, this applies row by row: the leftmost value in each row’s selected span is kept, while other values in that row’s span are removed.

For example, if B2 contains “North,” C2 contains “Region,” and you merge B2:C2, “North” remains and “Region” is lost from the worksheet. If you need both pieces of information, combine or move them before merging. You could copy the data elsewhere, or use a formula in a separate cell, such as =TEXTJOIN(" ",TRUE,B2,C2). With “North” in B2 and “Region” in C2, that formula returns “North Region.” TEXTJOIN is available in Microsoft 365 and newer Excel versions; for broad compatibility, use a simple concatenation formula such as =B2&" "&C2.

Do not rely on Unmerge to restore discarded values. It restores the individual cells’ structure, but it cannot bring back content that was removed during the merge. If you notice an unwanted merge immediately, use Undo; otherwise, recover the data from a saved copy, version history, or another source if available.

When Merge Across is the better choice

Choose Merge Across when each row needs its own heading spanning several columns. For instance, a worksheet might show quarterly sections in rows 2, 8, and 14, with each heading centered across columns B through E. Selecting B2:E14 as a single block and applying Merge Across merges the cells across each row in the selection. It does not selectively identify only the rows with headings, so avoid including detail rows that should remain unmerged.

Merge Across is also useful for a repeated label layout in a presentation-oriented sheet, such as a schedule where each row has one category name spanning adjacent columns. It preserves separate merged areas by row, which is the key distinction from turning the whole selection into one large cell. Check the selection carefully: every row intersecting the selected range is affected.

It is generally not a good choice for a data table used for analysis. A row-by-row merge still creates merged cells, and merged cells can interfere with operations that expect a regular grid. If the sheet will be sorted, filtered, imported, or used as a source for PivotTables, keep the cells unmerged and use alignment or formatting instead.

When Merge Cells is the better choice

Use Merge Cells when one cell-like area should span a whole rectangular selection, such as a single title above a report. If a title belongs over columns A through F, select A1:F1 and merge that one-row range. Merge Cells leaves the title’s alignment as configured; use the alignment controls separately if you want it centered. Merge & Center is the direct option when you specifically want one merged area with centered content.

A merged title can make a sheet easier to read when someone views or prints it, but it does not create a heading that repeats automatically on every printed page. It also does not make the underlying range into a database-style field. Treat the merged area as a visual container for one value, not as a way to group several data fields.

For a large rectangular selection with multiple populated rows, Merge Cells is rarely appropriate unless you intend to keep only the upper-left value. If you meant to create one title per row, choose Merge Across instead. If you meant to preserve every value, use neither merge command.

Center Across Selection: a safer alternative

If the goal is simply to make a heading appear centered over several columns, Center Across Selection often gives the appearance of a merge without combining cells. The heading remains in the leftmost cell, while the adjacent cells stay separate. This avoids many problems with sorting, selecting, and editing that arise from merged ranges.

To apply it in Windows Excel, select the cells, press Ctrl+1 to open Format Cells, choose the Alignment tab, open the Horizontal list, select Center Across Selection, and click OK. On Mac, select the cells and open Format Cells with Command+1; the dialog’s tabs and labels may vary slightly by version. This setting aligns the content across the selected cells when the neighboring cells are available for the display. It does not combine cell values or turn the range into one cell.

Center Across Selection is a formatting choice, so it may be preferable for report headings above sortable data. It is not identical to merging: the value remains in its original cell, and the other cells remain independent. If an existing merged heading is causing trouble, unmerge it first, then apply the alignment setting.

Common problems and limitations

Merged cells can make a worksheet less predictable because many spreadsheet operations assume each row and column has a consistent structure. A sort may fail or require merged cells to have matching dimensions. Copying and pasting a range that includes merges can also produce unexpected selection or paste behavior. Filtering, filling formulas down, and selecting individual cells may be harder to manage when part of the range is merged.

Data disappeared: a merge kept the upper-left value and removed other selected values. Undo immediately if possible; otherwise restore the data from another source.
Sort or paste is blocked: unmerge the affected cells or redesign the layout with Center Across Selection.
Text looks off-center: check the horizontal and vertical alignment settings. Merge Cells does not automatically center text; Merge & Center does.
Merge options are unavailable: the selected cells may be inside an Excel table, or the worksheet may be protected. Tables do not support merged cells within the table, and protection settings can restrict formatting.

For a worksheet that is mainly a clean data source, a useful rule is to keep one record per row and one field per column, without merged cells in the data area. Put decorative titles above that area if needed, and keep headings in individual cells. This structure is easier for Excel features and other programs to interpret.

Frequently Asked Questions

Does Merge Across combine text from adjacent cells?
No. It merges the cells separately across each selected row. Only the leftmost cell’s content in each row’s merged span is retained. To combine text, use a formula or join the values before merging.

Which command centers text?
Merge & Center merges the selection into one cell and centers its content. Merge Cells does not automatically center it. Merge Across creates separate merged cells by row; adjust alignment separately if needed.

Can I merge cells without losing data?
Not by merging cells that contain multiple values: Excel retains the upper-left value and discards the others. Combine or copy the values first, or use Center Across Selection if you only need a centered appearance.

Can I sort a range that contains merged cells?
Sorting may be blocked or behave awkwardly when merged cells do not have matching dimensions. Unmerge the cells before sorting, or use separate cells with alignment formatting instead.

How do I reverse Merge Across or Merge Cells?
Select the merged area and choose Home > Merge & Center ▼ > Unmerge Cells. Unmerging restores separate cells, but it does not restore values discarded during the original merge.

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.