To merge cells vertically in Excel for Microsoft 365 on Windows, select a vertical range such as A2:A4, then choose Home > Merge & Center ▼ > Merge Cells. Excel combines the selection into one taller cell and keeps only the value in the top cell, so check the range before you merge.
How to merge cells vertically
Vertical merging combines two or more cells in the same column into one cell that spans several rows. For example, merging A2:A4 makes one cell covering those three rows. It does not combine the cells in columns B or C, and it does not create three separate merged cells automatically when you select a rectangular block.
- Select the cells in one column that you want to combine, such as A2:A4. The range should be continuous.
- On the ribbon, open Home, then click the arrow beside Merge & Center.
- Choose Merge Cells. If Excel warns that only the upper-left value will be kept, review the selection and confirm only if that is what you intend.
The result is a single cell extending vertically across the selected rows. The value from A2 remains; any contents in A3 and A4 are removed. If you want the remaining text centered, use the horizontal and vertical alignment controls on the Home tab after merging. Choosing Merge & Center instead combines the selected cells and centers the retained value horizontally.
On Mac, select the range and use the merge dropdown on the Home tab; the command names are similar, though ribbon layout and keyboard behavior can vary by Excel release and settings. In Excel for the web, use the Home tab’s merge control if it is available in the ribbon. On Windows, the ribbon KeyTips can be used by pressing Alt, then H, M, M in sequence to choose Merge Cells; this is a sequence, not a simultaneous shortcut. That exact key sequence is not a universal Mac shortcut.
What the merge commands actually do
Excel’s merge menu offers commands that sound alike but produce different layouts. The distinction matters when a selection covers more than one row or column:
- Merge & Center combines the selected cells into one cell and centers the surviving value horizontally.
- Merge Across merges cells across each row of the selection separately. For example, selecting A2:C4 and choosing this option creates one merged cell per row: A2:C2, A3:C3, and A4:C4. It does not merge downward.
- Merge Cells combines the entire selected range into one cell, without applying horizontal centering as part of the command.
- Unmerge Cells removes the merged-cell structure and returns the area to separate cells.
There is no separate built-in command called Merge Vertically or Merge Down in the standard ribbon menu. To merge a vertical range, select just that range in one column and use Merge Cells. If you select A2:C4 and choose Merge Cells, Excel makes one cell spanning all three columns and all three rows—not one vertical merge in each column. To merge A2:A4, B2:B4, and C2:C4 independently, merge each column’s range separately.
Example: grouping a label across several rows
Suppose a worksheet lists a department’s quarterly results, with a department name in A2 and three quarter rows beneath it. If the name should appear beside all three rows as one group label, select A2:A4 and merge the cells. The department name in A2 remains in the new tall cell, while the row structure in the other columns is unchanged. You can then set vertical alignment to center so the label sits halfway down the group.
This can make a report easier to scan, especially when the worksheet is designed for printing or presentation. It is less suitable when the rows are records that people will sort, filter, or update as a dataset. In a data list, each row generally works best as a complete, independent record. A merged label makes that column behave differently from the others and can obstruct common worksheet operations.
Check cell contents before merging
Excel stores the merged cell’s content in its upper-left cell. For a vertical selection, that means the top cell. Values in the other selected cells are discarded when the merge is confirmed; merging is not a way to join text from several cells. If you need to preserve every value, copy or move the contents elsewhere first, or use a layout that does not merge those cells.
For instance, if A2 contains North and A3 contains South, merging A2:A3 keeps North and removes South. The warning dialog is important: it is not just a notice that the cells will look different. If you merge by mistake, pressing Ctrl+Z immediately can undo the action, but after further edits it may be harder to recover the removed content. Keep a copy of important data before restructuring a workbook.
Unmerging later restores the individual cell boundaries, but it does not bring back values that were discarded during the merge. The retained value is placed in the upper-left cell; the other cells become blank. This is why unmerge should not be treated as a reliable recovery method for overwritten contents.
Alignment, borders, and appearance
Merging changes the cell structure, while alignment and borders control how the result looks. After merging, use the Home tab’s horizontal alignment buttons to position the text from left to right. Use Middle Align to center it vertically within a tall merged area. These are separate choices: a value can be horizontally centered but remain at the top vertically, depending on the existing alignment settings.
Text wrapping can help with a long label, but a merged cell may not behave as conveniently as ordinary cells when Excel calculates row height. If the text is clipped or the row height looks wrong, try adjusting the row height manually, widening the column, or using a non-merged layout. Apply borders after deciding on the final merge pattern, and check how the sheet looks in Print Preview if it is intended for paper or PDF.
Merging is mainly a presentation tool. It does not combine worksheets, join text, or make several values available through one cell. If the goal is to place a heading over several columns, a horizontal merge may be appropriate; if the goal is only to center a heading visually, an alignment alternative may be safer.
Common problems and limitations
A frequent issue is that sorting or filtering becomes difficult after cells have been merged. Excel expects a consistent grid for many list operations, and merged areas can prevent a selected range from sorting normally or cause a sort warning. Merged cells also cannot be used inside an Excel table. If you need table features such as structured data entry, filters, and consistent row-based records, keep the cells unmerged.
Other problems can arise when copying and pasting ranges with different merge patterns, selecting a partial merged area, or filling cells down. Excel may reject the action or report that the selected cells are not the same size. These problems often come from a merged cell spanning rows or columns that do not match the destination. Before copying a report layout, consider whether it is easier to copy the whole merged area or to unmerge and rebuild the destination.
- If Merge Cells is unavailable, check whether the worksheet is protected, whether the selection includes a cell inside a table, or whether the selection is a noncontiguous set of ranges.
- If a sort fails, inspect the affected columns for merged areas and unmerge them before sorting.
- If a paste operation reports a size mismatch, compare the source and destination merge patterns; use ordinary cells where possible.
- If a label disappears, check the upper-left cell of the merged range and undo promptly if the merge removed text you needed.
Unmerging can restore the grid, but it does not restore discarded values. For a workbook that is actively used as a dataset, avoiding merges from the start is often simpler than repairing them later.
Alternatives to vertical merging
If you want to center a heading across several columns without combining cells, select the horizontal range and open the Format Cells dialog. On Windows, press Ctrl+1, choose the Alignment tab, then set Horizontal to Center Across Selection. This displays the entry centered across the selected cells while leaving the cells separate. It is a horizontal alignment option, not a method for centering text vertically across several rows.
For a vertical group label in a data list, consider repeating the label in each row rather than merging it. Repeating a department or category name makes every record self-contained and is more compatible with sorting, filtering, and Excel tables. If repetition makes a printed report look busy, you can use borders, shading, indentation, or a separate heading row to show groups without merging the data cells.
Another option is to keep a blank, unmerged range and use alignment, borders, and row formatting to create the appearance of a grouped area. This does not create a single tall cell, but it preserves the worksheet’s regular grid. Choose a true merge when the layout is primarily for display and the loss of the other cell contents is understood; choose an unmerged design when the sheet must remain easy to analyze and maintain.
Frequently Asked Questions
Can Excel merge cells vertically?
Yes. Select a range in one column, such as A2:A4, then choose Home > Merge & Center ▼ > Merge Cells. Excel combines that range into one taller cell.
How do I merge multiple columns vertically at once?
Merge each column’s vertical range separately. Selecting a multi-column rectangle and choosing Merge Cells creates one large merged cell, while Merge Across combines cells horizontally in each row.
Will merging cells delete data?
It keeps only the value in the upper-left cell of the selected range and discards contents in the other cells. Copy anything you need to retain before confirming the merge.
Can I sort a worksheet with merged cells?
Sometimes a sort can work around merged areas, but merges commonly block sorting or produce warnings because the cells do not form a consistent grid. Unmerge the affected cells or use a regular row-based layout for sortable data.
Does unmerging restore the original values?
No. Unmerge restores the separate cell boundaries, but values discarded during the original merge remain gone. The retained value stays in the upper-left cell.
What is the difference between Merge Across and Merge Cells?
Merge Across creates separate horizontal merges for each row in the selection. Merge Cells combines the entire selection into one cell. For a vertical merge, select one column’s range and choose Merge Cells.
Related
- Excel Heat Mapping: How to Create Useful Color Scales
- Excel Heatmap Formatting: Color Scales and Tips
- Excel Heat Map Over a Map: Methods, Data, and Setup
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Workbook vs Excel Binary Workbook: Key DifferencesAn Excel workbook is the general name for a spreadsheet file; an Excel Binary Workbook is one specific…
- Data Validation Testing: Methods and ExamplesData validation testing checks whether data meets defined rules for format, completeness, consistency, and acceptable values before it…
- Current Date in Google Sheets: Formula, Settings & TipsTo show the current date in Google Sheets, enter =TODAY() in a cell. It displays today’s date according…
- Why Can’t I Add a Header in Word?You usually can’t add a header in Word because the document is not currently editable, editing is restricted,…
- How to Double Space in Word on Windows 11, Step by StepTo double-space text in Word on Windows 11, select the text, open Home > Line and Paragraph Spacing,…
- Excel SUM: How to Exclude Hidden Rows and Filtered RowsYes. To sum visible rows while excluding both filtered-out rows and rows hidden manually, use SUBTOTAL with function…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.