Excel Merge Blank Cells Below: Steps and Alternatives

How-to basics · Updated November 19, 2026

To merge blank cells below a value in Excel for Microsoft 365 on Windows, select the cell containing the value and the blank cells beneath it, then choose Home > Merge & Center arrow > Merge Cells. Excel makes the selection one tall cell and keeps the value from the upper-left cell; it does not fill the lower cells with copies of that value.

What merging cells actually does

Merging combines a rectangular selection of cells into one larger cell. When you select a vertical range such as B2:B5, the result is one cell spanning those four rows. The value or formula in B2 remains in the merged cell, while the other cells in the selection cease to exist as separate cells until you unmerge the range.

This is a layout and presentation feature, not a way to join data or repeat a label. If B2 contains North and B3:B5 are empty, merging B2:B5 displays North in the larger area. The cells underneath are not independently populated with North, and formulas or references that need a separate value in each row will not get one.

Excel preserves only the content in the upper-left cell of a merged selection. If any other selected cell contains data, Excel warns that the other contents will be removed. Merging does not combine text, add values, or choose the most useful entry automatically.

Steps to merge a cell with blank cells below

  1. Check that the top cell contains the value you want to keep and that every cell below it in the intended range is empty.
  2. Select the whole range. For example, to merge B2 with the three blank cells below it, select B2:B5 by dragging down the cells or by entering B2:B5 in the Name Box to the left of the formula bar.
  3. On the ribbon, open Home, click the arrow beside Merge & Center in the Alignment group, and choose Merge Cells.
  4. Check the result. The value should appear in one cell covering the selected rows. Adjust alignment or row heights if the display needs refinement.

Choose Merge Cells rather than the main Merge & Center button if you do not want Excel to center the content horizontally. The main button merges and centers; the dropdown offers separate choices. If the command is unavailable, check whether the selection includes part of an Excel table, whether the sheet is protected, or whether the selected range has an incompatible existing merge.

Choosing the right merge option

The dropdown matters because its options do different things. Merge Cells combines the selected rectangle without applying horizontal centering. Merge & Center combines it and centers the content horizontally. Merge Across makes separate merges across each row of a multirow selection; it does not merge a column vertically. Unmerge Cells restores separate cells in a merged area.

For a vertical label in B2:B5, use Merge Cells or Merge & Center. For a heading above several columns, select a horizontal range such as B1:E1 and use a suitable merge option. Be aware that merging a heading across columns can also make later sorting or editing more awkward, so it is usually best reserved for presentation areas rather than the data itself.

A concrete example

Suppose a worksheet has a section label, Quarterly totals, in A2, and A3:A5 are blank. Selecting A2:A5 and choosing Merge Cells creates a single tall cell with Quarterly totals at its upper-left position by default, subject to the existing alignment settings. The label is visible across the merged area, but A3, A4, and A5 no longer act as individual cells. A formula referring to A4 will not find a separate blank cell there while the merge is in place.

If instead you need the text Quarterly totals available in all four rows—for example, so each transaction row has a category—do not merge. Fill the value down into A2:A5. On Windows, select the range with the value in its top cell and press Ctrl+D to fill down. On Mac, the equivalent shortcut is generally Control+D. You can also copy the top cell and paste into the selected cells. Filling down creates a separate value in each row, which is useful for filtering, formulas, and analysis.

Common problems and how to avoid them

  • A lower cell is not really blank: It may contain a formula returning an empty string, a space, or an unnoticed value. Excel may warn that content will be discarded. Inspect the range before merging, and cancel if you need to preserve anything below the top cell.
  • The value appears off-center: Merge Cells does not necessarily center content. Use the alignment controls on Home, or choose Merge & Center if horizontal centering is what you want. Vertical alignment is a separate setting in the Alignment group.
  • The option is disabled: Excel tables do not allow merged cells within their table area. Convert the table to a normal range only if that is appropriate for the workbook, or place a presentation label outside the table. Sheet protection can also prevent formatting changes.
  • Excel says it cannot merge the selection: A selection that intersects other merged areas may be incompatible. Unmerge the existing areas first, then select a clean rectangular range. Avoid selecting disjoint cells; a merge must be a single contiguous rectangle.
  • Text is hidden or clipped: A merged cell can make AutoFit row-height behavior less useful, especially when text wraps. Set a suitable row height manually, widen the column if possible, or use a text box or ordinary cell layout instead.

Why merged cells can cause data headaches

Merged cells are convenient for visual headings, but they complicate the grid structure that Excel uses for tables, sorting, filtering, copying, and filling. In a vertically merged range, only the top row has the cell value. The rows underneath do not each carry that label, so a filter or formula that expects one record per row cannot treat the merged display as repeated data.

Sorting a range that contains merged cells can be restricted or produce an error if the merge patterns do not match across the range. Copying and pasting across differently sized merged areas can also fail. These problems are especially likely in a worksheet that mixes merged cells with ordinary row-by-row records. Keep the underlying data in a regular grid, with one value per record, and apply merges only in a separate report or print layout when the appearance is important.

A merged range also changes how navigation and selection work: the merged area is treated as one cell, so selecting or editing a lower part of it does not access a distinct underlying cell. That is expected behavior, not evidence that Excel lost a set of blank cells. Unmerging restores the grid positions, but it cannot restore lower-cell contents that were discarded during merging.

Alternatives when you only want a visual effect

If the goal is simply to make a label look centered or prominent, merging is not always necessary. These alternatives preserve ordinary cells and can make a workbook easier to edit:

  • Center Across Selection: For a heading across columns, select the cells and open the Format Cells dialog with Ctrl+1 on Windows or Command+1 on Mac. On the Alignment tab, set Horizontal to Center Across Selection. This centers text across the selected columns without merging them. It is a horizontal formatting option, not a way to join cells vertically.
  • Fill the label down: Use this when every row needs the same category or group name. Each cell remains independently sortable and filterable.
  • Use borders, shading, or alignment: Formatting can distinguish a section without changing the worksheet’s cell structure. For example, apply a bottom border to a heading row or use a fill color for a group label.
  • Use a text box for a report heading: A text box can be positioned over a report area without merging the cells beneath it. It is a visual object, so it should not be mistaken for data stored in the grid.

For vertical centering across a group, you can often set the cell’s vertical alignment and adjust the row heights while keeping the cells separate. That approach is more flexible when the worksheet may later be sorted, filtered, or extended.

How to undo or unmerge

If you have just merged the wrong range, press Ctrl+Z on Windows to undo the action. On Mac, press Command+Z. Undo is the best option immediately after a mistaken merge because it reverses the operation and may restore content removed by that action, provided the undo history is still available.

To separate a merged cell later, select it and choose Home > Merge & Center arrow > Unmerge Cells. Excel restores the individual cell positions, but the original value remains only in the upper-left cell; the other cells are blank. Unmerging does not recreate values that were discarded when the cells were first merged. If those values matter, undo promptly or restore them from a saved copy or another source.

Excel for Mac and Excel for the web

In Excel for Mac, the ribbon command is also on the Home tab under Merge & Center; select its dropdown and choose Merge Cells. The interface may look slightly different depending on the ribbon layout, but the core behavior is the same. Use Command+Z to undo on Mac. Keyboard shortcuts can vary with macOS settings and keyboard layout, so the ribbon is the dependable route if a shortcut differs.

Excel for the web also provides merge controls on the Home ribbon, though the available controls and layout can differ from the desktop app. If you cannot find the specific merge option, use the ribbon search or open the workbook in the desktop version. Across these versions, the important rule remains the same: a merge keeps the upper-left content and does not populate the rest of the range.

Frequently Asked Questions

Can I merge a cell with blank cells below without losing its value?
Yes. Select the top cell and the blank cells beneath it, then choose Home > Merge & Center arrow > Merge Cells. The value in the upper-left cell is retained.

Does merging copy the top value into the blank cells?
No. It creates one larger cell rather than filling each row. Use Fill Down or copy and paste if each cell needs its own copy of the value.

What happens if one of the cells below is not blank?
Excel warns that merging keeps only the upper-left value and discards content from the other selected cells. Cancel the merge if you need to preserve that content, or move or combine the data first.

Why is Merge Cells greyed out in Excel?
Common causes include selecting cells inside an Excel table, a protected worksheet, or a selection that conflicts with existing merged ranges. Check those conditions and select one contiguous rectangular range.

Can I merge cells vertically and still sort the rows normally?
Usually, merged cells make sorting and filtering less reliable because the label exists in only the top cell, not every row. Keep data in unmerged rows and use formatting or a separate report layout for visual grouping.

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.