Excel Merge Cells Per Row: The Right Way to Do It

Formulas & functions · Updated November 19, 2026

To merge cells separately across each row in Excel for Microsoft 365 on Windows, select the full range and choose Home > Merge & Center ▼ > Merge Across. For example, selecting A2:C5 merges A2:C2, A3:C3, A4:C4, and A5:C5—not the whole selection into one cell. Excel keeps the leftmost cell’s contents in each row, so check for data in the other cells before you merge.

What merging cells per row means

Row-by-row merging is useful when a worksheet has a heading or label that should span several columns in each individual row. The key is to use Merge Across, rather than the main Merge & Center button. The dropdown command applies a separate horizontal merge to every row in the selected range.

Suppose a report has one section heading on each row, with the text in column A and empty cells in columns B and C. Selecting A2:C5 and choosing Merge Across creates four merged cells, one for each row. The contents of A2, A3, A4, and A5 remain in their respective merged areas. This is different from selecting A2:C5 and choosing Merge & Center, which creates one large merged cell across all three columns and all four rows.

A merged cell is still a worksheet cell, but it occupies the space of several original cells. Only the upper-left cell of each merged area can hold a value. The other positions are no longer independent cells while the merge is in place.

How to merge a range across each row

  1. Review the cells first. Check every selected row for values in columns to the right of the first column. Copy anything you need to keep somewhere safe before merging.
  2. Select the range. For example, select A2:C5 to merge three columns across four rows. You can drag across the grid or enter the range in the Name Box to the left of the formula bar.
  3. Open the merge menu. On the Home tab, open the dropdown beside Merge & Center. Do not click the main button if you want separate merges for each row.
  4. Choose Merge Across. Excel merges the selected cells horizontally within each row. Check the result: each row should have its own merged area.
  5. Adjust alignment if needed. Use the alignment controls on the Home tab to position the text. Merge Across is the command that creates the row-wise merges; it is not the same instruction as Merge & Center.

The same ribbon command is used in Excel for Mac, though the layout can vary slightly by release. On Excel for the web, look for the merge dropdown on the Home tab; available controls and their placement can depend on the current interface. If the dropdown does not show Merge Across, use the desktop Excel app for this workflow.

What happens to existing data and formatting

Excel does not combine the contents of cells when it merges them. It keeps the value in the leftmost cell of each row and discards values in the other cells in that row. For example, if A2 contains North, B2 contains Region, and C2 contains 12, merging A2:C2 keeps North. Region and 12 are removed from the worksheet cells. Excel may warn you that only the upper-left value will be retained; treat that warning as a reason to stop and review, not as a prompt to proceed automatically.

Formatting also deserves a check. A merged area can make borders, fills, and alignment look different from the original grid, particularly when the cells had inconsistent formatting. Review the result at normal zoom and in any printed or exported version that matters to your work. Merging does not change the width of the columns or turn separate row heights into one shared height; it changes which cells are combined within each row.

If you discover a mistake immediately, use Undo: Ctrl+Z in Windows or Command+Z on Mac. Undo is most reliable before you perform other edits. If the workbook has been saved, closed, or edited further, restoring lost cell contents may require a backup or version history rather than simply unmerging.

Choosing between Merge Across and other merge commands

The merge dropdown includes commands that sound similar but produce different layouts. Choose based on the shape you need, not just the word merge:

  • Merge Across: creates one horizontal merged cell per row in the selected range. This is the right choice for merging per row.
  • Merge & Center: combines the entire selected area into one cell and centers its retained value. With a multirow selection, it does not create one merge for each row.
  • Merge Cells: combines the entire selection into one cell without the centering instruction. It is not a substitute for Merge Across when you need separate row groups.
  • Unmerge Cells: removes the merged layout and restores the underlying grid. It does not restore values that were discarded when the cells were merged.

For example, selecting B1:D3 and choosing Merge Across creates three separate merged areas: B1:D1, B2:D2, and B3:D3. Choosing Merge & Center instead creates one merged area covering B1:D3. That distinction is the most common source of confusion when someone wants to merge cells per row.

When merging is a poor fit

Merged cells are most appropriate for presentation elements, such as a report title spanning columns or a short section label in a formatted summary. They are often inconvenient in the body of a data table. Sorting, filtering, selecting individual cells, filling formulas, and pasting rectangular blocks all work more predictably when each record stays in its own unmerged cells.

Imagine a sales list where every row is one transaction and columns hold date, customer, product, and amount. Merging the customer cell across several columns may make the sheet look spacious, but it alters the table’s rectangular structure. Sorting or filtering can become awkward, and a merged range can interfere with selecting or pasting into just one of its component positions. Keep records in separate cells if people will analyze, sort, filter, or import the data.

A useful rule is to keep the source data plain and unmerged, then apply visual formatting to a report or presentation copy. If an existing worksheet already uses merges, check them before applying a sort, a filter, or a bulk paste; do not assume every visible grid position is an independent cell.

Safer alternative: Center Across Selection

If the goal is to center a heading over several columns without actually combining cells, use Center Across Selection. This formatting option leaves the cells separate, which can make later editing and table operations easier. It is particularly useful for a title in A1 that should appear centered over A1:C1 while B1 and C1 remain empty.

To use it in Windows Excel, select the cells for the heading area, press Ctrl+1 to open Format Cells, choose the Alignment tab, set Horizontal to Center Across Selection, and select OK. On Mac, Command+1 opens the Format Cells dialog in supported versions; the menu names are similar. Enter the heading in the leftmost cell of the selected area and leave the cells to its right empty.

This option changes how content is displayed; it does not merge cells or distribute a value across several cells. If cells to the right contain content, the centered display may not behave as expected. For a worksheet that needs true row-by-row merges, use Merge Across; for a data table or a title where cell structure should remain intact, Center Across Selection is often the safer choice.

Common problems and how to fix them

  • The whole block became one cell. Undo the action, reopen the merge dropdown, and choose Merge Across. The main Merge & Center command applies to the entire selection.
  • Some text disappeared. The merge retained the leftmost value in each row. Undo if possible, or restore the missing contents from a saved copy or version history. Unmerge alone will not bring deleted values back.
  • The text is not centered. Set horizontal alignment after merging, or use Merge & Center when a single merged area is genuinely what you want. For multiple separate row merges, apply alignment to the result as needed.
  • Sorting or pasting is difficult. Unmerge the affected cells if the layout permits, or keep the source data in a separate, unmerged table. A merged range cannot behave like a set of fully independent cells.
  • The merge command is unavailable. Check whether you are editing a protected worksheet or working in an interface that does not expose the same merge options. In desktop Excel, review sheet protection and try the Home-tab dropdown.

To unmerge a selected area, use Home > Merge & Center ▼ > Unmerge Cells. This restores the individual cell grid, but only the retained values remain. If you are unsure whether a merge contains important information, make a copy of the worksheet before changing it.

Frequently Asked Questions

Can I merge cells per row for several rows at once?
Yes. Select the full rectangular range and choose Home > Merge & Center ▼ > Merge Across. Excel creates a separate horizontal merge in each row of the selection.

Does Merge Across keep data from every cell?
No. It keeps the leftmost cell’s contents in each row and removes contents from the other cells in that row. Move or combine values elsewhere before merging if you need to preserve them.

What is the difference between Merge Across and Merge & Center?
Merge Across makes a separate merge for every row in the selected range. Merge & Center makes one merged area from the full selection and centers the retained value.

Can I undo a merge without losing data?
Undo can restore the earlier state if you use it before other changes. Unmerge Cells restores the grid, but does not recover values that were discarded during the merge.

Can I center a heading across columns without merging cells?
Yes. Use Center Across Selection in Format Cells > Alignment. It keeps the cells separate, and the heading should be in the leftmost cell with the neighboring cells empty.

Is merging cells recommended in an Excel data table?
Usually not for the records themselves. Keep each field in its own cell so sorting, filtering, formulas, and data transfer remain straightforward. Reserve merges mainly for headings or report layouts.

Related

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Formulas & functions

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

Spotted an error in this guide? Let us know.