Google Sheets Merge Cells Command and How to Use It

To merge cells in Google Sheets, select the cells, then choose Format > Merge cells > Merge all. You can also use the merge-cells button on the toolbar; its dropdown provides the same options. In Google Sheets in a web browser, there is no standard, dedicated keyboard shortcut for merging.

What the merge command does

Merging turns two or more neighboring cells into one larger cell. The rows and columns remain part of the sheet, but the selected cells become a single area for displaying and formatting content. The command is often used to make a heading span several columns, such as a report title centered over a table.

A merged cell is not the same as a wider column or taller row. It is a group of cells treated as one for purposes such as entering a value and aligning text. For example, merging A1 through D1 creates one cell area across those four columns. The column boundaries still exist in the sheet, and cells below the merged area remain separate.

Use the command when the visual layout benefits from one label spanning multiple cells. It is usually less suitable for the ordinary data rows of a table, where each cell should represent one value and sorting or filtering should work consistently.

How to merge cells step by step

Select a contiguous rectangular range by dragging across it, or click the first cell and Shift-click the last cell. To select a full range with the keyboard, click its first cell, hold Shift, and use the arrow keys.
Open Format in the menu bar and point to Merge cells.
Choose Merge all, Merge horizontally, or Merge vertically, depending on the layout you want.
Check the result and adjust alignment, wrapping, or row height if the text does not display as intended.

The toolbar provides a quicker route: select the range and click the merge-cells control. If the control shows a dropdown arrow, open it to choose the merge type. Depending on the available toolbar space, the control may appear as an icon rather than a labeled button. The Format menu is the clearest route when you need to confirm which operation you are choosing.

To undo a merge immediately, use Edit > Undo or the browser-supported undo shortcut, Ctrl+Z on Windows or Command+Z on Mac. Undo is most useful right after the operation; it should not be treated as a way to recover other cell contents that were cleared by merging.

What the three merge options mean

Merge all: Combines the entire selected rectangular range into one cell area. Selecting B2:E3 and choosing this option produces one merged area covering both rows and all four columns.
Merge horizontally: Merges cells across each row of the selection, rather than joining all selected rows into one area. For B2:E3, the result is one merged area across B2:E2 and another across B3:E3.
Merge vertically: Merges cells down each column of the selection. For B2:C4, the result is a vertical merged area in column B and a separate one in column C.

These options are useful for different kinds of headings. A single report title spanning several columns usually calls for Merge all on one row. A set of row labels spanning adjacent columns may call for Merge horizontally. A category label that spans several rows in one column may call for Merge vertically. Look at the shape of the selected range and the number of merged areas you want before choosing.

If a merge option is unavailable or the result is not what you expected, verify that you selected the intended cells and that the selection is a suitable rectangular range. A selection containing separate, nonadjacent cells is not a normal range to merge as one block. Clear the selection and select the continuous area you actually want to combine.

What happens to data in the selected cells

Merging is a layout operation, not a command for combining text. If several selected cells contain values, Google Sheets keeps the content of the upper-left cell of each resulting merged area and removes the contents of the other cells in that area. For example, if A1 contains “Quarterly report” and B1 contains “2026,” merging A1:B1 keeps the value in A1; it does not join the two phrases into “Quarterly report 2026.”

Before merging, check every cell in the selection. If any nonempty cell has information you need, copy or move that information somewhere safe first. For Merge horizontally or Merge vertically, consider the selection as a set of smaller merged areas: the value at the upper-left of each resulting area is the one to retain. If you are unsure, make a copy of the sheet or test the operation on a temporary range.

Unmerging later separates the area back into individual cells, but it does not recreate values that were discarded during the merge. This is why merging cells that contain a dataset is risky even if you expect to undo or reverse the layout later. Keep source data intact and make visual headings in separate rows or columns when possible.

Format the merged cell so it reads well

After merging, you may want to change how the surviving value is displayed. Use the horizontal and vertical alignment controls on the toolbar to position it within the larger area. Center alignment is common for a title across columns, while left alignment may be easier to read for a long section heading. Alignment changes appearance; they do not alter the underlying value.

Long text may extend across empty cells when cells are unmerged, but a merged area has its own display space. If the text is clipped, try text wrapping from the toolbar or increase the relevant row height. You can also adjust column widths, although doing so affects the entire column, not just the merged cell. A short heading such as “Regional sales” is a better candidate for merging than a lengthy explanatory sentence.

Formatting such as font, fill color, borders, and text style can help distinguish a merged heading from the data beneath it. Apply formatting after selecting the merged area. Remember that a border around the merged area is one visual outline; it does not restore internal cell boundaries as separate working cells.

When merging is a poor choice

Merged cells can make a sheet harder to maintain when they appear inside a structured table. Sorting and filtering expect records to follow a consistent row-and-column layout. A merged cell that spans several rows or columns can interfere with selecting, sorting, filtering, copying, or pasting a rectangular data range. Even when a particular operation is possible, the visual result may not match the way the data is organized.

For example, imagine a sales table with one row per transaction and columns for date, region, product, and amount. Merging the region cell across several transaction rows may look tidy, but the region is no longer repeated on every record. That makes it harder to filter the table by region or use the rows in a chart or pivot table. Keep one value per cell and repeat the region in each applicable row instead.

Merge cells mainly in presentation areas, such as a title above a report, a section label outside the main dataset, or a form designed for people to fill in. If the goal is simply to make a heading appear centered over several columns without changing the cell structure, consider leaving the cells separate and using alignment or other formatting. This preserves the underlying grid for later editing.

How to unmerge cells

Click the merged area, then choose Format > Merge cells > Unmerge. You can also use the toolbar merge control if it offers an unmerge choice for the selected area. The cells become separate again, and the retained value remains in its original upper-left cell; the other cells are blank unless you enter data in them.

Unmerging is useful when you need to restore a table-like layout or correct an accidental merge. It does not automatically fill the newly separated cells with copies of the original value. If you need the same label in several rows after unmerging, enter or copy it into those cells deliberately. Check formatting as well, because alignment and borders may need adjustment once the area is split.

If you are trying to unmerge several areas, select the range that contains them and use the same menu command. Review the range afterward: a selection may include both merged and ordinary cells, and the result can affect every merged area within it. For a complicated sheet, making a duplicate tab before changing its layout can provide a practical fallback.

Google Sheets and Excel: a brief comparison

The basic idea is familiar in both programs, but the menu paths differ. In Google Sheets in a browser, use Format > Merge cells. In Excel for Microsoft 365 on Windows, the comparable controls are on Home, in the Alignment group, under the Merge & Center dropdown. The exact options and behavior should be checked in the program you are using rather than assuming a Google Sheets menu path applies in Excel.

In either spreadsheet, merged cells are primarily a presentation feature and can complicate work with tabular data. If a workbook or sheet will be shared between programs, simple formatting and unmerged data grids are generally easier to edit consistently. Also, do not assume that a shortcut in one program works in the other; Google Sheets has no standard dedicated merge shortcut, so its Format menu or toolbar is the dependable command route.

Frequently Asked Questions

What is the command to merge cells in Google Sheets?
Select the cells, then choose Format > Merge cells > Merge all. Use Merge horizontally or Merge vertically instead when you want a separate merge for each row or each column of the selected range.

Is there a keyboard shortcut to merge cells in Google Sheets?
Google Sheets does not provide a standard dedicated keyboard shortcut for merging cells. Use the Format menu or the merge-cells toolbar control. You can use the usual undo shortcut immediately after an accidental merge.

Does merging cells combine their text?
No. It does not concatenate the contents. The value in the upper-left cell of each resulting merged area is retained, and content in the other cells in that area is removed. Combine or save needed text before merging.

How do I merge cells across each row?
Select the rectangular range, then choose Format > Merge cells > Merge horizontally. Each row becomes its own merged area across the selected columns; the rows do not all become one large cell.

How do I undo or reverse a merge?
Use Edit > Undo immediately after the merge, or select the merged cell and choose Format > Merge cells > Unmerge. Unmerge restores the separate cells but does not bring back discarded contents.

Why can’t I merge the cells I selected?
Check that you selected the intended continuous rectangular range and that you are not trying to merge separate, nonadjacent cells. If the toolbar control is unclear, use the Format menu to inspect the available merge options.

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.