Google Sheets Merging Cells: Steps, Limits, and Fixes

How-to basics · Updated November 21, 2026

To merge cells in Google Sheets in a web browser, select the cells, then choose Format > Merge cells and pick Merge all, Merge horizontally, or Merge vertically. To reverse the change, select the merged cell and choose Format > Merge cells > Unmerge.

What merging cells does

Merging combines two or more neighboring cells into one larger cell for display and editing. It is commonly used to make a title span several columns, or to give a label a more prominent place in a report. The resulting cell occupies the space of the selected range, but the sheet still has its original row and column structure underneath.

A merged range has one editable value, not a separate value for each of its former cells. Google Sheets keeps the contents of the upper-left cell and removes the contents of the other cells in the merged range. For example, if A1 contains “Quarterly report” and B1 is empty, merging A1:B1 leaves the title in the expanded cell. If B1 contains a date or another label, that content is lost in the merge.

This is the key distinction between merging and simply making a cell look larger: merging changes how the selected cells behave as a range. It can affect sorting, filtering, copying, formulas, and later edits. Treat it as a layout choice rather than a way to combine data.

How to merge cells in the browser

In the Google Sheets web app, first select a rectangular group of adjacent cells. You can drag across the grid or select a range by clicking its first cell and extending the selection. Then use the menu path below:

  1. Choose Format > Merge cells.
  2. Choose Merge all to combine the whole selection into one cell, Merge horizontally to merge across columns in each selected row, or Merge vertically to merge down rows in each selected column.
  3. Enter or format the value in the resulting merged cell as needed.

The toolbar may also show a Merge cells control, depending on the available toolbar space. The Format menu is a dependable way to find the choices and see which merge operation you are selecting. If the command is unavailable, check that the selection is a suitable adjacent range and that you have permission to edit the sheet.

Before merging, inspect every cell in the selection. If there is more than one value, copy any content you need to another location first. Merging is not a text-concatenation operation: it will not join several names, numbers, or sentences into one value for you.

Choosing the right merge option

The three merge choices are useful for different shapes of selection. Consider what the final layout should look like, rather than choosing an option just because it makes the selection appear larger.

  • Merge all: Combines the entire selected rectangle into one cell. A common example is selecting A1:D1 to create a single heading spanning four columns.
  • Merge horizontally: Merges cells across the columns of each selected row, while keeping the rows separate. Selecting A1:C3 produces one merged cell in each of the three rows.
  • Merge vertically: Merges cells down the rows of each selected column, while keeping the columns separate. Selecting A1:C3 produces one merged cell in each of the three columns.

If you select A1:C2 and use Merge all, the outcome is one cell covering both rows and all three columns. If you use Merge horizontally, the outcome is two merged cells, one for each row. That difference matters when you need separate headings or labels for separate records.

Formatting a merged heading

Merging controls the cell range, but it does not automatically make the text look like a polished heading. After merging, you can use the normal Google Sheets formatting controls to change horizontal or vertical alignment, font style, text size, fill color, borders, and text wrapping. For a report title, centering the text and applying a fill or bold style can make the intended hierarchy clearer.

Text alignment is independent of merging. You can often make a heading look centered across a group of columns by selecting the cell containing the heading and applying horizontal center alignment, but that will center text within that cell, not make it span neighboring cells. A merged range is one way to create the broader visual area; alignment then determines where the text sits inside it.

Keep headings concise and check how they appear at different browser zoom levels or when columns are resized. A merged cell can extend across several columns, but its text may still wrap or be clipped depending on the row height and text-wrapping setting. Adjust formatting deliberately instead of assuming the merge alone will fix the display.

Data loss and other common problems

The most important risk is losing values outside the upper-left cell. Suppose A2 contains “North,” B2 contains “East,” and you merge A2:B2. The merged cell retains “North”; “East” is discarded. If you need both values, combine or preserve them before merging—for example, put the information in a separate helper cell or keep it in separate columns. Do not merge first and expect unmerge to restore all the original contents.

Immediately after a mistaken merge, use Edit > Undo or the browser-appropriate undo control to reverse it. Undo can restore the prior state while the action remains in the undo history. If the sheet has since been edited or closed, Google Sheets version history may help you review or restore an earlier version, but restoring a version can also roll back other changes. Make a copy or carefully review the version before using it to recover data.

Merged cells can also get in the way of sorting and filtering. A range with merged cells may not sort as expected, and Sheets can restrict sorting when a selected range includes merged cells. Merges across records are especially troublesome: a data table works best when each row is one record and each column is one field. If a sheet must be sorted or filtered regularly, keep its data cells unmerged.

Another common surprise is that a merged range is still tied to its top-left cell. When a formula or another cell refers to that range, the useful value is associated with the upper-left position, not with every grid cell covered by the merge. This can make formulas, references, and later copy-and-paste operations harder to reason about. Keep calculations and source data in ordinary cells, and use merges only in presentation areas.

When to merge—and when not to

Merging is usually appropriate for a title, a section heading, or a small form where a larger label area is part of the design. For instance, a monthly summary might use a merged A1:D1 heading above a table, while the rows below remain unmerged so they can be sorted and filtered. This separates presentation from the underlying records.

Avoid merging cells inside a list of transactions, inventory, survey responses, or other structured data. Each row should usually represent one complete item, with consistent columns for its fields. Merging cells inside that structure can make it difficult to select a complete record, maintain consistent formulas, or use the sheet’s data tools.

If you only want text to appear visually centered over several columns, consider whether a merged cell is necessary. You can instead put the heading in one cell, center its text, and leave adjacent cells empty; this avoids joining the cells, although the text will not behave like a single cell spanning the whole area. The best choice depends on whether the sheet is mainly a presentation or a working dataset.

Unmerge cells and restore a workable layout

To unmerge a range, click the merged cell and choose Format > Merge cells > Unmerge. This restores the individual grid cells in the range. The value that survived the merge remains in the upper-left cell, while the other cells are blank; unmerging does not recreate values discarded when the cells were merged.

If you are unsure where merged ranges are, inspect the sheet visually and click a suspected range. A selected merged cell covers more than one row or column in the grid. Before sorting or restructuring a sheet, unmerge presentation ranges that overlap the data you need to manipulate, then check that each row and column has a consistent meaning.

For recurring reports, it can help to keep a clean data tab and a separate presentation tab. The data tab can remain unmerged and easy to filter, while the presentation tab can use headings and merged cells where they improve readability. This arrangement reduces the chance that a formatting change will interfere with routine data work.

Google Sheets and Excel: a practical difference

Google Sheets and Microsoft Excel both offer cell merging, and both preserve the upper-left cell’s content when a range contains multiple values. The menu locations differ: this article’s instructions use Google Sheets in a browser, where the command is Format > Merge cells. In Excel for Microsoft 365 on Windows, merge choices are on the Home tab in the Alignment group; Excel’s ribbon also includes a Merge & Center control.

Do not assume a workbook or spreadsheet will behave identically after moving between programs. Merged layouts can complicate sorting and other range-based operations in either application, and formatting may need review after conversion or import. If collaborators use both Sheets and Excel, keeping the data area unmerged is generally the more portable choice.

Frequently Asked Questions

Does Google Sheets keep all data when I merge cells?
No. It keeps the content of the upper-left cell and removes content from the other cells in the selected range. Copy or combine anything you need before merging.

Can I merge cells without losing text?
Only if the other cells are empty, or if you first preserve their contents elsewhere. Merging itself does not combine text from multiple cells.

How do I undo a merge in Google Sheets?
Use Edit > Undo immediately after merging, or select the merged cell and choose Format > Merge cells > Unmerge. Unmerge restores the grid but not values discarded during the merge.

Why can’t I sort a range with merged cells?
A merge can make rows or columns in the range uneven, so Sheets may block sorting or make the intended records unclear. Unmerge cells in the data range and keep each record in its own consistent row.

Can I merge cells in Google Sheets on a phone?
The Google Sheets mobile app has its own interface and controls, which differ from the browser menu steps above. For the exact browser path described here, open the spreadsheet in Google Sheets on the web and use Format > Merge cells.

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.