Merge Cell Rows in Excel: Steps, Limits, and Alternatives

How-to basics · Updated November 21, 2026

To merge cells across rows in Excel for Microsoft 365 on Windows, select the cells, then choose Home > Merge & Center and select the merge option you need. Excel keeps only the value in the upper-left cell of the selection, so check for other content first; if you want to combine the contents of several rows, use a formula or another method instead.

What merging cells across rows means

In Excel, merging turns two or more adjacent cells into one larger cell. When people ask how to merge cell rows, they may mean merging vertically down a column, merging cells across each row, or joining the text from multiple rows. Those are different operations, and choosing the right one matters because a merge changes the worksheet structure.

For example, selecting A1:A3 and choosing Merge Cells creates one cell spanning those three rows. Selecting A1:C1 and merging creates one wide cell across three columns. The Merge Across command behaves differently: when you select a block such as A1:C3, it merges the cells across each individual row, creating one merged cell for row 1, another for row 2, and another for row 3.

A merged cell is still part of the worksheet grid, but it occupies the space of several cells. It is commonly used for a report title or a section heading, not for combining records in a data list. Merging does not add, concatenate, or preserve all the selected cell values.

Check the selection before merging

Before using a merge command, make sure the selected range contains what you expect and that its non-upper-left cells are empty or safe to discard. If more than one selected cell contains data, Excel warns that merging keeps only the upper-left value and deletes the other values. The warning is important: unmerging later does not bring deleted contents back.

Also consider whether the worksheet will need to be sorted, filtered, or used as a source for a PivotTable or other analysis. Merged cells can make these tasks awkward because the merged area no longer behaves like a regular row-and-column range. A heading that looks like it spans several columns may be useful for presentation, but a rectangular, unmerged data range is usually easier to maintain.

  • Keep a copy of important values elsewhere before merging.
  • Use a single merged heading for presentation rather than merging cells throughout a data table.
  • Check whether other people or a process will need to sort, filter, copy, or import the range.

How to merge cells across rows

To combine a vertical range into one cell in Excel for Microsoft 365 on Windows, select the cells in the same column and use the Home tab. If you select A2:A4, for instance, the resulting merged cell spans those three rows and retains the value in A2, if there is one.

  1. Select the adjacent cells you want to merge. The selection can be vertical, horizontal, or a rectangular block.
  2. Open Home > Merge & Center. Select the arrow beside the button to see the available commands.
  3. Choose Merge Cells if you want one larger cell without centering its contents, or Merge & Center if you want one cell with centered content.
  4. Read any warning about removing other cell contents, then confirm only if that is acceptable.
  5. Adjust alignment, borders, or row height if the new cell does not display as intended.

The main button may display Merge & Center, but the dropdown gives you more control. Depending on the current selection and Excel build, the available choices include Merge & Center, Merge Across, Merge Cells, and Unmerge Cells. Merging is not the same as centering: the merge command changes the cell layout, while alignment controls where its contents appear.

Choose the right merge option

Use the command that matches the shape of the selection and the result you want:

  • Merge & Center: Combines the selected cells into one and centers the retained content. This is a common choice for a report title over several columns.
  • Merge Cells: Combines the selection into one cell but does not apply centering. The current alignment settings may still affect where the content appears.
  • Merge Across: Merges cells across each row of a selected multirow range, rather than making one large merged cell for the entire range. It keeps the leftmost value in each row.
  • Unmerge Cells: Separates a merged area back into its original grid positions. It does not restore values that were removed during the merge.

For instance, if you select B2:D4 and choose Merge Across, Excel makes three merged cells: B2:D2, B3:D3, and B4:D4. It does not combine all nine cells into one. If you instead choose Merge Cells, the whole selection becomes one merged area, and only the value from B2 is retained.

What happens to data and formatting

Excel retains the contents from the upper-left cell of the entire selected range when creating one merged cell. With Merge Across, the upper-left cell of each row’s selected portion supplies that row’s retained content. Values in other cells are removed, even if they are formulas, dates, or text. A formula kept from the upper-left cell continues to refer to its original cell references, subject to normal Excel behavior.

Merging also changes how the selected range is arranged, which can affect borders and alignment. The resulting cell may inherit formatting from the range, but do not assume every border or style will look exactly as intended. Review the result, especially when merging cells with different fills, number formats, or borders. Use Undo immediately if the result is not right; after other edits or after closing the workbook, recovery may be less straightforward.

Unmerging restores separate grid cells, but generally leaves the retained value in the upper-left cell and leaves the other cells blank. It cannot reconstruct discarded contents. If data was important, recover it from a saved copy, version history, or an existing backup rather than expecting Unmerge Cells to reverse the data loss.

Common problems with merged cells

Merged cells can be inconvenient in worksheets built for ongoing data entry or analysis. Sorting a range that includes merged cells may be blocked or produce an unexpected layout, because the merged areas do not match the uniform cell structure Excel expects. Filtering and selecting individual records can also be confusing when labels span multiple rows. For best results, keep each record in its own row and use a value in every row where the value is needed.

Other common issues include:

  • Only one value remains: This is expected behavior, not a bug. Excel preserves the upper-left value (or the leftmost value in each row when using Merge Across) and discards other selected contents.
  • Text appears cut off: Increase the column width or row height, turn on Wrap Text, or adjust alignment. A merged cell can make automatic sizing less predictable.
  • Copying or pasting behaves oddly: A selection that cuts through only part of a merged area can cause selection and paste problems. Copy or select the whole merged area, or unmerge it first.
  • A worksheet table rejects merging: Excel tables are designed around consistent cells in each row, so merged cells are not supported inside a table. Convert or redesign the range only if you understand the effect on table features.

These limitations are why merged cells are best kept to titles, labels, or other presentation areas outside the main data body.

Alternatives that keep the worksheet easier to use

If the goal is simply to make a heading look centered above several columns, use Center Across Selection rather than merging. Select the cells, open Format Cells (Ctrl+1 on Windows), choose the Alignment tab, and set Horizontal to Center Across Selection. The cells remain separate, so the layout is generally friendlier to sorting and selecting than a merged range. On Mac, open Format Cells from the Format menu or use Command+1 where supported, then choose the same alignment setting.

For a heading that should appear beside multiple data rows, consider repeating the label in each row, or use cell borders and fill colors to visually group rows without changing the grid. Repeating a category such as North in each record is often more useful for filtering and PivotTables than a single vertically merged label.

If you mean joining the contents rather than combining cell shapes, use a formula in a separate output cell. With North, Region, and 3 in A2, A3, and A4 respectively, enter =TEXTJOIN(" ",TRUE,A2:A4) in B2; the result is North Region 3. This combines the text with spaces and ignores blank cells. TEXTJOIN is available in Microsoft 365 and supported newer Excel versions; if your version does not have it, you can join a small number of cells with the ampersand operator, for example =A2&" "&A3. The formula creates combined text in a cell; it does not merge the underlying cells.

Excel for Mac and Excel for the web

In Excel for Mac, select the cells and look for Merge & Center on the Home tab, then choose the desired option from its dropdown. The labels and ribbon arrangement can vary slightly by version, but the same core distinction applies: merging keeps only the appropriate upper-left or leftmost value. Mac keyboard shortcuts can differ from Windows shortcuts, so use the visible ribbon command if you are unsure rather than relying on a Windows key sequence.

Excel for the web also provides merge commands on the Home tab for supported workbook editing. If you do not see the expected option, check that the workbook is not in a restricted editing state and that the selection is a normal cell range. Across desktop and web versions, avoid merging inside structured data simply to improve appearance; use cell formatting or a separate title row instead.

Frequently Asked Questions

Can I merge cells without losing data?
Not with Excel’s standard merge commands when multiple selected cells contain values: only the upper-left value is retained, or the leftmost value in each row with Merge Across. Copy or combine the contents elsewhere before merging if you need to keep them.

How do I merge cells vertically in one column?
Select the adjacent cells in that column, such as A2:A4, then choose Home > Merge & Center > Merge Cells or Merge & Center. Excel creates one cell spanning the selected rows and keeps the value from A2.

Does Unmerge Cells restore the original values?
No. Unmerge Cells separates the area into normal cells but does not restore values discarded during merging. The retained value remains in the upper-left cell, and the other cells are typically blank.

What is the difference between Merge Cells and Merge Across?
Merge Cells turns the entire selected range into one cell. Merge Across instead creates a separate merged cell for each row of the selection, keeping the leftmost value in each row.

How can I center a heading without merging cells?
Use Center Across Selection in Format Cells > Alignment. It centers the content across the selected cells while keeping those cells separate, which is often a better choice for worksheets that need sorting or editing.

Related

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.