How to Merge Cells in Google Sheets and Keep Data Safe

To merge cells in Google Sheets in a web browser, select the adjacent cells, then choose Format > Merge cells and pick Merge all, Merge vertically, or Merge horizontally. Before merging, check the selected cells: Google Sheets keeps the contents of the upper-left cell and removes the contents of the other cells in the selection.

What merging cells does

Merging turns two or more adjacent cells into a single larger cell. The grid still has the same underlying rows and columns, but the selected area behaves visually as one cell. This is useful when a heading needs to span several columns, or when a label should cover multiple rows in a report.

For example, if a monthly report has columns for January, February, and March, you could merge three cells above those columns and place the heading “Quarter 1” in the resulting space. The heading is stored in one cell, not copied into each of the three original cells. Merging changes the layout; it does not combine the contents of several cells into a sentence.

How to merge cells in a browser

Open the spreadsheet and select a continuous rectangular range of adjacent cells. Drag across the cells, or select the first cell and extend the selection with the keyboard.
Open Format in the menu bar, point to Merge cells, and choose the merge option that matches the layout you want.
Review the result. The selected range becomes a merged area, and its upper-left cell supplies the value that remains.

You can also use the merge control on the toolbar when it is visible. Select the cells, open the merge control’s dropdown, and choose the appropriate option. The Format menu is a dependable route when you cannot identify the toolbar icon or when you want to see the available choices by name. Google Sheets may disable options that do not apply to the current selection.

The cells must form a single adjacent rectangle. For example, you can merge A1:C1 or A1:A3, but you cannot merge A1 and C1 while leaving B1 out. If you selected the wrong range, click another cell and select the intended rectangle again before applying the command.

Choose the right merge option

The three merge choices work differently when the selection contains more than one row or column:

Merge all combines the entire selected rectangle into one cell. Selecting A1:C2, for instance, produces one merged area spanning three columns and two rows.
Merge horizontally combines cells across each selected row. For A1:C2, it creates one merged cell across A1:C1 and another across A2:C2.
Merge vertically combines cells down each selected column. For A1:C2, it creates a merged cell in column A, another in column B, and another in column C.

For a heading above several columns, select just the cells in the heading row and use Merge all. For a label that should span several rows in one column, select the cells in that column and merge them vertically. Choosing the narrowest range that achieves the layout makes the sheet easier to edit later.

What happens to existing data

Merging is not a way to preserve every value in the selection. Google Sheets keeps the value in the upper-left cell and discards values in the other selected cells. If A1 contains “North” and B1 contains “Harbor,” merging A1:B1 leaves “North” in the merged cell; it does not produce “North Harbor.” Depending on the selection and interface, Sheets may display a warning before completing a merge that would remove other cell contents.

Before you proceed, check every selected cell for text, numbers, formulas, or other information you need. If the other values matter, copy them elsewhere or combine them into one cell first. Copying the range to another area or making a copy of the sheet is a sensible precaution when the data is important. Do not assume that unmerging will bring discarded values back: it will not.

Formatting and values are separate concerns. Merging changes the cell layout, while the retained cell remains the one associated with the merged area’s value. If your goal is only to make a title appear centered across columns without changing the grid, consider a different layout or alignment approach instead of merging.

Use merging for presentation, not data structure

Merged cells can make a report easier to read, but they are often inconvenient in a table that people need to sort, filter, calculate, or import into another tool. A data table works best when each row is one record, each column has one field, and each data cell contains one value. A merged heading or a merged cell inside the records can make selecting, sorting, pasting, and maintaining consistent rows harder.

For example, a sales list should generally have one row per sale, with separate columns for date, product, region, and amount. Avoid merging a region label down ten rows in the data itself; put the region in each relevant row instead. If a report needs a large heading, place it above the table and merge only the heading cells, leaving the table’s rows and columns unmerged.

This distinction matters if you plan to use filters, formulas that refer to ranges, or a chart based on the table. A visually attractive layout is not always a convenient data layout. Keeping the source data rectangular and using a separate presentation area for headings can preserve both readability and flexibility.

Combine text instead of merging cells

If the actual goal is to put multiple cell values together, combine the contents with a formula rather than merging the cells. With “North” in A2 and “Harbor” in B2, enter =TEXTJOIN(" ", TRUE, A2:B2) in C2. The result is “North Harbor”; the space in the first argument separates the values, and TRUE tells TEXTJOIN to ignore empty cells.

This formula leaves A2 and B2 intact, so you can still sort or reuse the original values. The result updates if either source cell changes. If you need a fixed text value rather than a live formula, copy the formula result and paste it as values using the available paste-special option. Check the result before removing or changing the source cells.

When you simply want text to appear centered over several columns, another option is to put the title in one cell, leave neighboring cells empty, and adjust alignment or column widths. This avoids combining or deleting values and can be easier to maintain. The right choice depends on whether you need a single large cell, a combined text value, or only a particular visual presentation.

How to unmerge cells

To undo the merged layout later, select the merged cell or area and choose Format > Merge cells > Unmerge. The original grid cells become separate again. Unmerging does not restore contents that were removed during the original merge, so it is not a recovery method for data that was discarded.

After unmerging, the retained value remains in the cell at the upper-left of the former merged area. Other cells are available as separate cells again, but they may be blank. If the sheet will be edited by other people, explain which cell contains the value or restore any needed labels from a backup or another source.

Common problems and fixes

The merge option is unavailable: Check that you selected a valid adjacent range and that the sheet permits editing. Try using the Format menu to confirm which options are available for that selection.
Some text disappeared: The merge kept the upper-left value and removed the others. Use undo immediately if the merge was the most recent action and undo is available; otherwise, look for a copy, version history, or another source of the missing information.
The result is not the shape you wanted: Unmerge the range, select the intended cells again, and choose Merge horizontally, Merge vertically, or Merge all as appropriate.
The text is difficult to read: Adjust the column width, row height, alignment, or text wrapping after merging. A merged cell does not automatically make long text fit neatly into the visible space.

If you are working in a shared spreadsheet, changes can affect other collaborators’ view and editing. Confirm that the selected range is the intended one before merging, especially in a sheet used as a shared data source. If a command behaves unexpectedly, verify the selection first; a range that includes more rows or columns than intended can change the outcome.

Google Sheets and Excel are not identical

The instructions above are for Google Sheets in a web browser. Excel has a similar concept, but its interface and exact menu paths differ, so do not follow Excel ribbon directions when working in Sheets. In Sheets, use Format > Merge cells; the available options are named Merge all, Merge vertically, and Merge horizontally.

Regardless of the spreadsheet program, merging can affect how a table is edited and what happens to values in the selected range. Check the program’s warning and preserve important data before proceeding. If you switch between Sheets and Excel, verify the merged layout after opening the file, particularly if the workbook contains complex formatting or shared data.

Frequently Asked Questions

Can I merge cells in Google Sheets without losing data?
Not by merging alone when multiple selected cells contain values: the upper-left value is kept and the others are removed. Combine the values into one cell first, or copy them somewhere safe before merging.

Can I merge cells across several rows?
Yes. Select the relevant cells and choose Merge all to create one large merged area, or choose Merge vertically to create a separate merged cell in each selected column. The outcome depends on the shape of the selection.

How do I merge cells without combining their contents?
Merging does not combine contents; it retains the upper-left value and removes other selected values. If you mean joining text, use a formula such as TEXTJOIN in a separate cell, then decide whether you still need to merge cells for appearance.

Why can’t I merge cells in Google Sheets?
The selected cells may not form a continuous rectangle, the chosen merge option may not fit the selection, or you may not have permission to edit the sheet. Reselect an adjacent range and check the Format > Merge cells menu.

Does unmerging restore the original cell values?
No. Unmerge separates the cells but does not restore values discarded during merging. Recover those from undo, a backup, version history, or another copy if available.

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.