Merge Cells in Google Sheets Vertically: How It Works

To merge cells vertically in Google Sheets, select two or more adjacent cells in the same column, then choose Format > Merge cells > Merge vertically. Sheets combines the selected cells into one taller cell and keeps the content from the top cell; content in the other selected cells is removed.

What vertical merging does

Merging changes the shape of a range of cells: instead of several separate cells stacked in one column, you get one cell spanning their combined height. It is useful when a single label or heading should apply to several rows, such as a department name beside a list of employees or a date beside several related entries.

Google Sheets offers several merge choices. Merge vertically joins cells down each column in the selected range. Merge horizontally joins cells across each row. Merge all combines the entire selected range into one cell. The distinction matters when you select more than one column: a three-row-by-two-column selection merged vertically becomes two merged cells, one for each column, rather than one large cell.

Merging does not combine the underlying text from multiple cells, add values together, or create a new data record. It changes the cell layout. If you need to preserve every value, first move or combine the values elsewhere, or use a non-merged layout.

How to merge cells vertically

In the Google Sheets web app, use the following steps:

Select the cells that should become one tall cell. They must be next to one another vertically within a column.
Open Format in the menu bar.
Point to Merge cells.
Choose Merge vertically.

You can also use the merge control in the toolbar if it is visible. Select the range, open the small dropdown beside the merge-cells button, and choose Merge vertically. The menu path is a reliable option when the toolbar button is hidden or the window is narrow. The command is not the same as choosing “Merge all,” which would combine the full rectangular selection into a single cell.

For example, if A2, A3, and A4 contain a category label only in A2, selecting A2:A4 and merging vertically makes one cell covering those three rows. If you select A2:B4 instead, Sheets merges A2:A4 and B2:B4 separately. It does not merge all six cells into one unless you choose Merge all.

What happens to content and formatting

A merge can discard information, so check the selection before applying it. If only the top cell contains content, that text remains in the merged cell. If other cells in the selection also contain values, Sheets warns that merging will keep the upper-left value and discard the other cell contents. Cancel the operation if you need those values, then copy or move them to unselected cells first.

Formatting is separate from content. The merged cell can retain formatting such as fill color, borders, font, and alignment, but the result may not look as intended if the selected cells had different formatting. After merging, inspect the border edges and alignment, and adjust them using the toolbar. To position a label in the middle of the merged area, use the vertical-alignment control and select the middle alignment. Horizontal alignment controls whether the text sits at the left, center, or right of the cell.

A merged cell still has one address: the address of its upper-left cell. In the A2:A4 example, formulas and references use A2, not a new address for the entire merged area. The lower cells do not remain as independent cells that can hold separate values while the merge is in place.

Choosing the right range

Plan the selection around the meaning of the data, not just the appearance of the sheet. A vertically merged label works best when it genuinely describes a group of adjacent rows and is not itself a value needed on every row. For instance, a heading such as “North Region” can visually span several detail rows, while each row still contains an individual product or sales entry.

Check the boundaries: Include exactly the rows that belong to the label. Accidentally including a subtotal or the next category can make the layout misleading.
Look for existing values: Verify whether any cell below the top one contains data that must be kept.
Consider future rows: If new entries will be added often, a merged label may need to be unmerged and expanded later.
Use a consistent pattern: Apply similar merges to comparable groups so the sheet is easy to scan.

It is often clearer to put the category name in every row, even if that means repeating it, when the data will be filtered, sorted, or analyzed. Repetition may look less polished, but it makes each row self-contained.

Common problems and how to fix them

The merge option is unavailable or does not do what you expect. Recheck the selection and open the merge dropdown to confirm which command you are choosing. For vertical merging, select a range that extends down a column. If you selected several columns, remember that “Merge vertically” performs a separate vertical merge within each column.

Some text disappears. This usually means more than one selected cell held content. Use Undo immediately if the result is unexpected, or restore the discarded values from version history if necessary. Before trying again, move the values to another location or make a copy of the range.

The text seems missing after merging. It may be present but clipped because the row height is too small, the column is narrow, or text wrapping is off. Resize the row or column, or enable text wrapping from the toolbar. Also check the cell’s text color and alignment.

The merged area is larger than intended. Choose Format > Merge cells > Unmerge to separate the cells again. Unmerging restores the cell grid, but it does not bring back values that were discarded during the merge. Undo is more useful immediately after a mistaken merge; unmerge is for reversing the layout later.

Sorting, filtering, and data analysis

Merged cells can be awkward in a structured data table. Sorting expects records to occupy consistent rows and columns, while a merged cell spans multiple rows and therefore does not provide a separate category value for each record. A sort or filter may be unavailable, behave unexpectedly, or leave the visual grouping unclear when merged cells are involved. For a list that people will sort or filter, keep one record per row and repeat the category value in each relevant row.

Merges can also complicate copying a partial range, inserting rows, and selecting individual cells. This is not a reason to avoid merging everywhere; it is a reason to distinguish a presentation area from a data table. A title block or printed summary can use merges more safely than a source table used for analysis, charts, pivot tables, or exports.

If you already have a merged label and need to analyze the rows, consider unmerging it and filling the category name down into each row. That makes the table more dependable for filtering and later reuse. Keep a separate presentation sheet for visual grouping if the merged appearance is still useful.

Alternatives and how Excel differs

If the goal is to make a label look centered across several rows without changing the cell structure, consider centering its text within a single cell and adjusting row height, or use borders, fill color, and indentation to indicate a group. Another option is to repeat the label down the rows and use consistent formatting to make the group clear. These approaches preserve separate cells and are usually more convenient for sorting and data operations.

Google Sheets’ Merge vertically command is specifically useful for combining each column’s selected cells downwards. Excel for Microsoft 365 on Windows uses the Home > Merge & Center dropdown for merge commands, but its choices are not a direct one-click equivalent to Sheets’ “Merge vertically” behavior across multiple columns. Excel’s Merge Across merges cells across each selected row; Merge Cells combines the selected range into one cell. If you switch between programs, check the resulting structure rather than assuming the same menu choice produces the same arrangement.

Working safely with a shared sheet

In a collaborative spreadsheet, merging changes the layout for everyone who can access the sheet. Before changing a shared table, consider whether other people rely on its current cell-by-cell structure, filters, or formulas. If the merge is only for a report, a separate presentation tab can preserve the original data layout.

Use Undo if you have just made a change and want to reverse it. For an older change, Google Sheets’ version history can help you review or restore an earlier state, though restoring a version affects the sheet beyond just one merge. A duplicate sheet or a copy of the relevant range is a simple precaution before making broad layout changes.

Frequently Asked Questions

Can I merge cells vertically in Google Sheets?
Yes. Select a vertical range and choose Format > Merge cells > Merge vertically. The selected cells in each column are combined down the column.

Does vertical merging keep all the text?
No. The upper-left cell’s content is retained. If other selected cells contain values, Sheets warns that those values will be discarded when the cells are merged.

Can I merge vertically across multiple columns?
Yes. Select a rectangular range and choose Merge vertically. Sheets creates one merged cell per selected column, spanning the selected rows. Choose Merge all instead if you want the whole rectangle to become one cell.

How do I undo a vertical merge?
Use Undo immediately after merging, or choose Format > Merge cells > Unmerge to restore separate cells. Unmerge does not recover text discarded from other cells during the merge.

Why should I avoid merged cells in a data table?
A merged cell spans multiple rows but holds only one value, which can interfere with sorting, filtering, copying, and analysis. Repeating the category value in each row is generally more useful for a table that will be processed.

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.