Merge Cells in Google Sheets: Steps and Data Tips

To merge cells in Google Sheets in a web browser, select the cells, then choose Format > Merge cells and pick a merge option. Merging keeps the value in the upper-left cell of the selection and removes the contents of the other cells, so check the range before confirming.

What merging cells does

Merging turns two or more neighboring cells into one larger cell. The grid still has the same rows and columns, but the selected cells behave as a single area for displaying content. A common use is a heading that should span several columns, such as a report title centered above monthly figures.

Merging is a layout change, not a way to combine the values stored in separate cells. If A1 contains First and B1 contains Last, merging A1:B1 does not produce First Last. Only the upper-left cell’s content remains; the other cell’s content is discarded from the merged result. If you need to preserve both values, combine them in a separate cell first or use an appropriate formula.

The merge applies only to the selected range. For example, selecting B2:D2 and choosing Merge horizontally creates a single wide cell across those three columns. Selecting B2:B4 and choosing Merge vertically creates one tall cell across three rows.

How to merge cells in a browser

Open the spreadsheet in Google Sheets and select the neighboring cells you want to merge. Drag across the grid, or click the first cell and extend the selection with Shift-click.
Choose Format > Merge cells from the menu bar.
Select the option that matches the selection: Merge all, Merge horizontally, or Merge vertically.
Review the merged cell and its contents. If Sheets warns that merging will keep only one cell’s value, cancel if you need to copy or combine the other data first.

In many browser layouts, the toolbar also has a Merge cells button. Its small arrow opens the merge options. The Format menu is a reliable route if the toolbar control is hidden, disabled, or difficult to identify. The command may be unavailable when the selection is not a suitable range, such as when you select nonadjacent cells.

To select a rectangular range precisely, click the first cell, hold Shift, and click the last cell. For instance, clicking C1 and then Shift-clicking F1 selects C1:F1. Avoid selecting whole rows or columns unless that is genuinely the area you intend to merge.

Which merge option should you choose?

Merge all combines the entire selected rectangle into one cell. Use it for a title spanning a block, not for a range where each row needs to remain a separate record.
Merge horizontally merges cells across each selected row separately. Selecting A1:C3 creates three merged cells: A1:C1, A2:C2, and A3:C3.
Merge vertically merges cells down each selected column separately. Selecting A1:C3 creates three merged cells, one in each column: A1:A3, B1:B3, and C1:C3.
Unmerge reverses a merge and restores the original cell grid. It does not restore content that was removed from cells during the merge.

For a single heading across columns, Merge all is usually the straightforward choice. For a table with one heading per row, Merge horizontally can be appropriate, but check that each row’s data layout makes sense when its cells are joined. Merge vertically is less common in ordinary data tables and can make row-by-row sorting or filtering awkward.

Protect your data before merging

Before merging a range, look through every cell in it, not just the cell at its upper-left corner. If the other cells contain text, numbers, dates, or formulas, copy that information somewhere safe. Google Sheets does not append those values to the retained cell. Undo can reverse the immediate merge, but it is not a substitute for checking the range, especially if you continue editing afterward.

For example, suppose A1 contains North, B1 contains South, and C1 contains West. Merging A1:C1 keeps North in the merged cell; South and West do not become part of the new value. If you want a label reading North South West, combine the text in a separate empty cell before merging anything, then copy the result if needed.

When working in a shared spreadsheet, consider telling collaborators before changing a layout that others may be editing or using in formulas. A merge can change how the sheet looks and behaves for everyone with access. If the sheet is important, making a copy first gives you a straightforward fallback.

Formatting a merged heading

Merging is often only one step in making a heading clear. After the merge, use the toolbar or the Format menu to set horizontal alignment, vertical alignment, text wrapping, font size, and background color as needed. Centering the text can make a report title appear balanced across the merged area, while vertical alignment can help when the merged cell spans multiple rows.

For example, to create a heading above a quarterly report, select A1:D1 and merge the cells. Enter the title in A1, then center the text and apply a fill color. Keep the labels in row 2 as four separate cells so each column remains identifiable. This separates a decorative heading from the structured data below it.

If the text is too long, consider wrapping or resizing columns before making the merge wider. A merged cell can display a heading attractively, but it does not make the underlying columns wider or change the values in the data rows.

Limits for sorting, filtering, and formulas

Merged cells are usually best reserved for presentation areas rather than the body of a dataset. Sorting and filtering work most predictably when every row has the same structure and each value occupies its own cell. A merge that crosses rows can interfere with selecting, sorting, or filtering a consistent table range. Even horizontal merges within data rows can make the table harder to interpret because one value appears to occupy several columns.

Similarly, a merged range is still a single cell for purposes such as entering a value or referring to it in a formula. The retained value belongs to the upper-left cell of the range. Other cell positions within the merged area are not independent places to enter data while the merge remains in effect. If a calculation depends on each original cell, preserve the individual values and avoid merging those cells.

A useful design rule is to keep headings and explanatory notes separate from the actual data table. You can place a merged title above the table, but keep column headers and records in ordinary individual cells. This makes the sheet easier to sort, filter, reference, and export.

How to unmerge cells

Select the merged cell, then choose Format > Merge cells > Unmerge. The original grid boundaries return, and the retained value appears in the upper-left cell. Other cells in the range become empty; unmerging does not bring back values that were discarded when the cells were first merged.

If you merged by mistake and have not made other changes since, use the Undo command in Sheets. Undo can roll back the merge as an edit. If you have already continued working, unmerge the cell and check version history or a backup for earlier content rather than assuming all removed values are still available. Version history is available from File > Version history > See version history; access to earlier versions can depend on your file permissions and the document’s history.

Alternatives when you need the values, not a merged layout

If your goal is to join text rather than create a larger visual cell, combine the values in an unused cell and leave the source cells intact. With First in A1 and Last in B1, this formula joins them with a space:

=TEXTJOIN(" ",TRUE,A1,B1)

With those example inputs, the result is First Last. The formula combines text for display; it does not merge the cells or remove the original values. You can also use a plain space between cell references, but TEXTJOIN is useful when combining several values and handling empty cells. Check that the destination cell is empty and that the joined text is the result you want before replacing or deleting any source data.

If you only want text to look centered across several columns, Google Sheets does not provide Excel’s Center Across Selection command. A practical alternative is to put the heading in one cell, adjust the column widths, and use alignment or text wrapping. Another option is to keep the heading in its own row and use a merged range only there, while leaving the dataset itself unmerged.

Common problems and fixes

The merge option is unavailable: Check that you selected a continuous rectangular range of adjacent cells. A nonadjacent selection cannot form one merged area.
Some contents disappeared: A merge retains only the upper-left cell’s content. Undo immediately if possible, or inspect version history or a backup for the previous values.
The text seems off-center: Merging does not automatically apply every formatting choice. Set horizontal and vertical alignment separately using the toolbar controls.
The merged cell makes a table hard to use: Unmerge data areas and keep each record field in its own cell. Reserve merges for titles or notes outside the sortable range.
The row or column looks unusually large: A vertical or horizontal merge changes the area occupied by one cell, but it does not remove the underlying rows or columns. Review row heights, column widths, and wrapping settings.

If multiple people are editing at once, a collaborator may also change the selection or formatting while you work. Confirm the range again before applying a merge, particularly in a shared report or template.

Frequently Asked Questions

Can I merge cells in Google Sheets without losing data?
Not by merging alone when more than one selected cell contains content: the upper-left cell’s value is kept and the other contents are removed from the merged result. Copy or combine the values elsewhere first if you need to preserve them.

How do I merge only two cells?
Select the two adjacent cells, open Format > Merge cells, and choose the suitable option. Choose Merge all for a single pair in one row or column; the resulting cell keeps the value from the upper-left position.

Can I merge cells across several rows but keep each row separate?
Yes. Select the rectangular range and choose Merge horizontally. Sheets merges each row in the selection independently rather than turning the entire rectangle into one cell.

How do I undo a merge in Google Sheets?
Use Undo right after merging if you want to reverse that edit. Otherwise, select the merged cell and choose Format > Merge cells > Unmerge. Unmerge restores the grid but does not recover contents that were discarded.

Does merging cells combine their text?
No. Merging changes the layout and retains the upper-left cell’s content; it does not concatenate text. Use a formula such as TEXTJOIN in a separate cell when you need a combined text result.

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.