Merge Cells in Google Sheets: Web and App Steps

To merge cells in Google Sheets, select a rectangular range, then choose Format > Merge cells and pick Merge all, Merge horizontally, or Merge vertically. In the Google Sheets mobile app, select the cells, tap Format, open the Cell tab, and turn on Merge cells. Before merging, check the selected cells: only the value in the upper-left cell is kept.

What merging cells does

Merging combines neighboring cells into a single larger cell. It is mainly a layout and presentation tool: for example, a heading can span the columns beneath it, or a label can cover several rows in a report. The cells remain part of the sheet’s grid, but the selected range behaves visually as one cell.

Merging does not join the contents of multiple cells. If A1 contains “North” and B1 contains “Region,” merging A1:B1 will not create “North Region.” Google Sheets keeps the upper-left cell’s content and removes the content from the other cells in the range. If the discarded values matter, combine or copy them elsewhere before merging.

This distinction also matters when using formulas. A merged range has one stored value, in its upper-left cell; the other positions in the range do not become separate places to store data. A merged cell may look like it occupies several columns, but it is not a substitute for several independent cells in a data table.

Merge cells in Google Sheets in a browser

These steps apply to Google Sheets in a desktop web browser. You need a range of adjacent cells forming a rectangle; a selection of separate, nonadjacent cells cannot be merged as one range.

Open the spreadsheet and select the cells you want to merge. Drag across them, or click the first cell and extend the selection with the keyboard.
Open Format > Merge cells from the menu bar.
Choose Merge all, Merge horizontally, or Merge vertically, depending on the result you want.

You can also use the Merge cells button on the toolbar when it is visible. Its icon and position can vary with window width or toolbar layout. If the button is not obvious, the Format menu is the reliable route. If other selected cells contain data, Sheets warns that only the upper-left value will be retained; review that warning before confirming.

To reverse the operation, select the merged cell and choose Format > Merge cells > Unmerge. Unmerging restores the individual grid cells, but it does not bring back values that were discarded when the cells were first merged. Use Undo immediately after a merge if you need to restore the prior contents.

Choose the right merge option

The three merge choices produce different layouts. Consider the shape of the selection and whether you want one large cell or a set of merged cells in rows or columns:

Merge all: combines the entire selected rectangle into one cell. Selecting A1:C1 and choosing this option makes one cell spanning three columns. Selecting A1:C3 makes one cell covering the whole three-by-three block.
Merge horizontally: merges cells across each row separately. For A1:C2, the result is one merged cell across A1:C1 and a second across A2:C2. This can be useful for row labels or grouped headings, but each row’s upper-left value is the one that remains for that row.
Merge vertically: merges cells down each column separately. For A1:B3, the result is a merged cell in column A and another in column B, each spanning three rows.

For a simple title above a table with columns A through D, select A1:D1 and use Merge all. For a report with a group name spanning two rows in one column, select the relevant vertical range and use Merge vertically. Be deliberate when selecting a larger rectangle: Merge all can turn the entire selection into one cell, rather than merging each row independently.

Merge cells in the Google Sheets app

On Android and iPhone or iPad, open the spreadsheet in the Google Sheets app and select the cells you want to combine. Tap the Format button, usually shown as an “A” with formatting lines, then open the Cell tab and switch on Merge cells. The selected cells will merge, and the upper-left cell’s value is retained. If the app displays a prompt about other contents, read it before continuing.

The mobile interface is more compact than the browser version, so the Format panel may take up part of the screen and options may be arranged differently. If you do not see the merge setting, confirm that the selection covers adjacent cells and check that you are on the Cell tab rather than the Text tab. You can also use the browser version for the more explicit Merge all, Merge horizontally, and Merge vertically menu choices.

To undo a recent merge in the app, use the app’s Undo control. To undo it later, select the merged cell, return to the Cell formatting options, and turn off Merge cells if the control is available. As with the browser, unmerging restores the grid but does not recover values removed during the merge.

Format the merged cell after merging

Merging and alignment are separate actions. A merged heading is not automatically centered just because it spans several columns. Select the merged cell and use the horizontal alignment control on the toolbar to center, left-align, or right-align its text. Use vertical alignment controls if you want the content positioned at the top, middle, or bottom of a taller merged area.

You can also change the font, text size, fill color, borders, and text wrapping just as you can for other cells. For example, a report title might use a merged A1:D1 cell, bold text, a colored fill, and centered alignment. If the text seems clipped, increase the row height, enable text wrapping, or adjust the column widths. Merging changes the available display area, but it does not automatically make every long heading readable.

When applying formatting to a merged area, select the merged cell itself. If you later unmerge it, formatting may remain on the constituent cells, so inspect the range if you want a clean, uniform layout afterward.

Common problems and practical fixes

The merge option is unavailable: check that you selected a contiguous rectangular range, not separated cells. If a single merged cell is selected, you may see Unmerge rather than the merge choices. Confirm that you have permission to edit the sheet.
Some text disappeared: Sheets retains the upper-left value and discards the other cell contents when merging. Undo the action promptly if possible. Otherwise, restore the values from version history or another copy if available; unmerging alone will not restore them.
The text is not centered: merging does not set alignment. Use the horizontal alignment control after merging.
The layout looks wrong after sorting: merged cells can get in the way of sorting or rearranging tabular data, particularly when merged ranges do not match the records being sorted. Unmerge cells in the data area and keep headers in ordinary cells when sorting is important.
The merged area is difficult to select: click within the visible merged area, then use the name box or keyboard navigation if needed. Selecting the merged cell allows you to format or unmerge it.

Before merging a range that contains important information, make a copy of its contents or use Undo as soon as you notice an unwanted result. A merge warning is not a content-combining feature: it tells you that values in non-upper-left cells will be lost from the selected range.

When to merge—and when to use an alternative

Merging is usually best for decorative headings, report titles, or labels in a presentation-style sheet. It is less suitable for the main body of a dataset, where each row should represent a record and each column should hold a consistent field. Merged cells can make it harder to select, sort, filter, copy, or extend data consistently.

If your goal is simply to make a heading appear centered across several columns, consider selecting the heading cell and using horizontal alignment controls without merging. This keeps the underlying cells separate. Google Sheets does not offer Excel’s “Center Across Selection” command, so ordinary alignment may not reproduce that exact appearance; another practical option is to place the heading in one cell and adjust column widths or use a separate title row.

If you need to keep words from several cells, combine them as text before changing the layout. For a one-off label, you can type the complete phrase into the upper-left cell and then merge the range. If those source values need to remain separately available for calculations or sorting, do not merge over them; use a separate display row or column instead.

How Google Sheets merging differs from Excel

The basic idea is familiar in both spreadsheet programs: a selected range can become one larger visual cell, and merging is not the same as joining text. In Google Sheets, the browser menu path is Format > Merge cells. Excel for Microsoft 365 on Windows uses the Home ribbon’s Merge & Center controls, with options such as Merge & Center and Merge Across. The exact menus and labels differ, so instructions for one program should not be assumed to match the other.

Regardless of the program, merged cells are generally a presentation choice rather than a good structure for sortable source data. If a workbook or sheet will be shared between programs, check the layout after opening it elsewhere; formatting and controls can differ, and merged areas can complicate editing. Keep a separate, unmerged data table when reliable analysis and sorting matter.

Frequently Asked Questions

Can I merge cells in Google Sheets without losing data?
Not by merging alone. Sheets keeps the upper-left cell’s value and removes other contents in the selected range. Copy or combine the needed information before merging, or use a separate cell for the display heading.

How do I unmerge cells in Google Sheets?
Select the merged cell and choose Format > Merge cells > Unmerge in a browser. In the mobile app, select the cell, open Format and the Cell tab, then turn off Merge cells if shown. Unmerging does not restore discarded values.

Can I merge cells in the Google Sheets app on my phone?
Yes. Select adjacent cells, tap Format, open the Cell tab, and turn on Merge cells. The browser menu provides the separate Merge all, Merge horizontally, and Merge vertically choices more explicitly.

Can I merge cells vertically or horizontally?
Yes. In the browser, select the range and choose the corresponding option under Format > Merge cells. Horizontal merging creates a merged cell for each selected row; vertical merging creates one for each selected column.

Why is Merge cells greyed out?
The selection may not be a single adjacent rectangle, you may have selected an existing merged cell, or you may not have editing access. Try selecting a simple block of neighboring cells and check that the sheet is editable.

Does merging cells combine their text?
No. It combines the cells’ layout, not their contents. Only the upper-left value remains in the merged range, so put any wording you want to keep into that cell before merging.

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.