Can You Merge Cells in Google Sheets? How It Works

Yes, you can merge cells in Google Sheets in a web browser. Select the cells, then choose Format > Merge cells and pick a merge option; keep in mind that if more than one selected cell contains data, only the upper-left cell’s content is retained.

What merging cells does

Merging combines two or more neighboring cells into one larger cell. The result can make a heading span several columns or create a label that sits across a group of rows. The selected cells must form a rectangular block, such as A1:C1 or B2:B4. A scattered selection, such as A1 and C1 with B1 skipped, cannot be merged as one cell.

A merged range still occupies the same rows and columns on the sheet; it changes how those cells are displayed and edited. For example, merging A1:C1 makes one visible cell covering three columns, but it does not combine three separate values into a sentence. Google Sheets keeps the value from the top-left cell of the selected range and discards the contents of the other cells if they contain data. A merge is therefore a layout choice, not a way to concatenate information.

That distinction matters when formulas refer to a range. A merged block has one visible value, in its top-left position, rather than a value stored independently in every part of the block. If you need to preserve multiple names, figures, or labels, combine or reorganize them before merging—or choose a layout that leaves the cells separate.

Merge options in Google Sheets

The Merge cells submenu offers different ways to combine a rectangular selection. Which option makes sense depends on the shape of the selection and the layout you want:

Merge all combines the entire selected rectangle into one cell. Selecting A1:C2, for example, creates one cell spanning three columns and two rows.
Merge horizontally merges cells across each selected row. If A1:C2 is selected, the cells in row 1 form one merged cell and the cells in row 2 form another.
Merge vertically merges cells down each selected column. With A1:C2 selected, A1:A2, B1:B2, and C1:C2 become three separate merged cells.
Unmerge returns a merged selection to individual cells. It does not restore any content that was discarded when the cells were originally merged.

These options are useful for different layouts, but none automatically combines the values in the selected cells. If each row needs its own heading across several columns, horizontal merging is different from making the whole selected area one large cell. Check the preview implied by the selection before choosing an option.

How to merge cells in a browser

In Google Sheets on the web, use this sequence:

Select the adjacent cells you want to merge. Drag across them, or click the first cell and extend the selection with the mouse or keyboard.
Open Format in the menu bar and point to Merge cells.
Choose Merge all, Merge horizontally, or Merge vertically, as appropriate.
If Sheets warns that only the upper-left value will remain, review the selected range. Cancel if you need to preserve other cell contents; otherwise confirm the merge.

There is also a merge-cells control in the toolbar when it is available for the current selection. The Format menu is the clearest route because it displays the merge choices by name. If a merge option is unavailable or disabled, verify that you have selected a valid rectangular range and that you have permission to edit the sheet. Protected ranges can prevent changes.

To undo a merge immediately, use the normal Undo command while the action is still the most recent change. For an already merged range, select it and choose Format > Merge cells > Unmerge. Unmerging restores the cell grid, but not text or numbers that were removed from non-top-left cells at the time of merging.

What happens to data and formatting

Before merging, inspect every cell in the selection, not just the one you intend to keep. Suppose A1 contains “Quarterly sales,” while B1 and C1 contain notes or values. Merging A1:C1 retains the content in A1; it does not append the other contents or move them somewhere safe. Copy anything important to another location first, or use separate cells and a formula or text-editing step to combine the information you want displayed.

Formatting is separate from content. A merged cell can be given a fill color, border, font, and alignment like other cells. You can also use text wrapping or adjust row height and column widths so a long heading is readable. If the text appears off-center, select the merged cell and use the horizontal or vertical alignment controls in the toolbar. Merging itself does not guarantee centered text.

One useful example is a report title: enter “Regional results” in A1, select A1:D1, and merge the row to create a title area across four columns. This is appropriate when the cells to the right are blank and the title is the only content meant to occupy that row. It is not appropriate for a table header where A1, B1, C1, and D1 each need to identify a different field.

When merging helps—and when it causes trouble

Merging is most useful for presentation-oriented areas of a sheet: a title above a report, a section heading spanning a group of columns, or a form label that needs more visual space. It can make a printed or screen-viewed summary easier to scan, especially when the merged cells are outside the data table itself.

For ordinary data tables, merged cells often create friction. Sorting and filtering work best when each column has a consistent field name and each row is a record. If a heading is merged across several columns inside the table, it may be harder to sort, filter, select, or paste data predictably. Merged cells can also make it awkward to copy a rectangular range or fill a formula down a column, because the merged shape does not match the one-cell-per-record structure expected by many spreadsheet operations.

A practical rule is to keep the actual dataset unmerged. Put decorative titles above it, and use one header cell per column. If you need a group label over several columns, consider placing it in a separate row above the field names, while leaving the field-name row unmerged. This preserves the table’s structure without giving up a clear visual hierarchy.

Merges may also surprise collaborators. Someone entering data can click a large merged region and assume it contains multiple independent entry points, when it is actually one cell. If a sheet is shared for ongoing data entry, favor clear labels and consistent individual cells over visual styling that changes the grid.

How to unmerge and recover a usable layout

To undo a merge that is no longer useful, click the merged cell or select the merged range, then go to Format > Merge cells > Unmerge. The former cells reappear as separate grid cells. The retained value stays in the top-left cell; the other cells will not recover values lost during the merge.

If you need to restore information, use Undo if the merge is still recent. Otherwise, check version history or an earlier copy of the sheet for the original contents. Google Sheets version history can help you review or restore an earlier version, but restoring a version may also roll back other edits made since then. Before changing a shared sheet, consider making a copy or checking with collaborators if recovering data is important.

After unmerging, you may need to reapply alignment, borders, or column widths. If the goal was simply to make a heading look centered over several columns, unmerge the range and center the heading across its cells without combining them where possible. That keeps the grid intact while preserving much of the visual effect.

Alternatives to merging

For a title that should appear centered across a group of columns, try selecting the title cell and applying horizontal center alignment. The text remains in one cell, and neighboring cells stay available for data. Another option is to widen the column, wrap the text, or increase the row height rather than merging cells just to make a label fit.

If you need a label to span columns visually but want to retain a regular grid, you can use borders, fill colors, and alignment to distinguish sections. For example, a colored group-heading row above an unmerged header row can show that several fields belong together without interfering with the individual field names. If you need a combined text value, create it in a separate cell using a formula or edit the text directly; merging alone will not combine the source values.

Excel has a similar general idea of merged cells, but its interface and exact menu wording can differ. Instructions for Excel should not be assumed to match Google Sheets exactly. In Sheets, use the Format menu’s Merge cells submenu, and remember that the same data-preservation caution applies: a merge is not a substitute for joining cell contents.

Frequently Asked Questions

Can I merge cells in Google Sheets without losing data?
Only if the other selected cells are empty, or if you first move or combine their contents. When multiple cells contain content, Google Sheets keeps the upper-left cell’s value and removes the others from the merged result.

Can I merge cells across multiple rows?
Yes. Select a rectangular range and choose Merge all to make one cell across the full selection, or use Merge vertically to create a separate merged cell in each selected column.

Can I merge cells horizontally in Google Sheets?
Yes. Select the range and choose Format > Merge cells > Merge horizontally. This merges cells across each row separately, rather than turning the full selection into one cell.

Why is Merge cells grayed out?
Check that you have selected adjacent cells in a rectangular block and that you can edit them. A protected range or a selection that is not valid for the requested merge can prevent the option from being used.

How do I undo a cell merge?
Select the merged cell and choose Format > Merge cells > Unmerge. This separates the cells again, but it does not bring back data that was discarded when the merge was made.

Should I merge cells in a spreadsheet table?
Usually not in the data area. Keep one value per cell and one field per column so sorting, filtering, copying, and data entry remain straightforward. Merging is better reserved for titles and section labels outside the table.

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.