Google Sheets Merge Cells: Do They Keep All Values?

How-to basics · Updated November 21, 2026

No—Google Sheets keeps only the value in the upper-left cell when you merge a range; content in the other selected cells is discarded. If you need every value, combine or copy the data somewhere safe before choosing Format > Merge cells.

What happens when you merge cells

Merging changes several cells into one larger cell. For example, if A1 contains “North,” B1 contains “Central,” and C1 contains “South,” merging A1:C1 keeps “North” and removes the contents of B1 and C1. The merged cell does not contain three separately accessible values, even if the removed content was text, a number, a date, or a formula.

Sheets may display a warning when a selected range contains more than one populated cell. Treat that warning as a data-loss notice, not as a choice to preserve everything: merging still retains the upper-left value. If the other cells are blank, there is no additional content to lose. If they contain values you may need later, stop and make a copy or combine them first.

The upper-left cell means the first cell in the selected range, not necessarily the first cell with content. If A1 is blank and B1 contains a label, merging A1:B1 does not reliably promote B1’s label into the merged cell. Put the content you want to keep in the range’s upper-left cell before merging.

Why people merge cells

Merging is often used to make a heading span several columns, or to create a label centered over a group of rows. It can make a presentation sheet or a small report easier to scan. For instance, a title such as “Quarterly Results” may look more balanced when it spans columns A through D above a table.

That visual benefit comes with a trade-off: a merged range is no longer a simple grid of independent cells. The operation is usually most appropriate for decorative headings or layout areas, not for the body of a dataset. A spreadsheet designed for sorting, filtering, analysis, or repeated data entry is generally easier to maintain when each record stays in its own row and each field stays in its own column.

How to preserve all values before merging

First decide how you want the separate values represented after the merge. They can be joined into one text string, kept in a backup range, or left in separate cells while you use a non-merge formatting option. If you join them, choose a separator that makes the result readable and does not create confusion with the values themselves.

  1. Make a copy of the sheet or copy the source range to an unused area. This gives you a fallback if you later discover that a value, formula, or format was important.
  2. In an empty helper cell outside the range you plan to merge, combine the values into one result. For A1:C1, enter =TEXTJOIN(", ", TRUE, A1:C1). If A1:C1 contains North, Central, and South, the result is North, Central, South. The TRUE argument skips blank cells.
  3. Check the result, including its separators. If a value itself contains a comma, consider a different separator, such as a vertical bar, or preserve the original values separately.
  4. Copy the helper cell, select the upper-left cell of the range you will merge, and choose Edit > Paste special > Values only. The combined text is now a fixed value rather than a formula that depends on the original range.
  5. Confirm that the combined result is visible and that your backup remains intact. Then select the intended range and merge it.

TEXTJOIN is available in Google Sheets, and the example uses ordinary cell references. It turns the selected contents into one text result; it does not preserve them as separate values inside the merged cell. For dates, percentages, or currency, inspect the result carefully because joining values into text may not retain the display format you want. You may need to format the combined text deliberately or keep the original typed values in a backup.

How to merge cells in Google Sheets

In Google Sheets in a web browser, select the adjacent cells you want to combine, then use Format > Merge cells. The submenu offers different merge choices depending on the selected range:

  • Merge all: combines the selected cells into one cell.
  • Merge horizontally: combines cells across each row of the selected range. When multiple rows are selected, each row is merged horizontally.
  • Merge vertically: combines cells down each column. When multiple columns are selected, each column is merged vertically.
  • Unmerge: separates a previously merged range back into individual cells.

After selecting a merge option, review the resulting range and any warning Sheets shows. The same upper-left-value rule applies to the merged groups: content in other cells in each group is not retained. The menu wording and behavior described here are for Google Sheets; Excel has its own interface, though its merge feature also should not be treated as a way to preserve every selected cell’s contents.

A practical example: a report heading

Suppose a report has columns A through D for product, region, units, and revenue. You want a title above the table to read “Monthly Sales.” If the cells A1:D1 are empty, merging them for the heading is straightforward: select A1:D1, choose Format > Merge cells > Merge all, and enter the title in the resulting cell.

The risk appears if A1:D1 already contain separate notes, labels, or formulas. Merging that range to make room for a title will not stack those items or combine them automatically. If all four entries matter, put a combined version in A1 first and keep a backup, or place the title in a separate row that does not contain data. This distinction—empty presentation cells versus populated data cells—is a useful test before merging.

Also consider whether the title needs a merged cell at all. You can often center a heading across a visual area without changing the cell structure by selecting the title cell and adjusting alignment, or by placing the title in a dedicated row above the data. The exact best layout depends on how the sheet will be used, but avoiding a merge can make later edits less surprising.

Can unmerging restore the lost values?

No. Unmerge separates the merged area into individual cells, but it does not reconstruct the contents that were removed when the cells were merged. Usually the retained upper-left value remains, while the newly separated cells are blank. Unmerge is useful for restoring the grid layout, not for recovering discarded values.

If you merged by mistake and have not made many subsequent changes, try Edit > Undo immediately. Undo can reverse the merge as part of the recent edit history, but it is not a long-term backup strategy. If the sheet was closed, the undo history may no longer help. Look for a copied range, a duplicate tab, or the file’s version history instead. In Google Sheets, use File > Version history > See version history to review earlier saved states; restoring an older version can also undo other edits, so consider copying the needed data from it rather than replacing the current sheet outright.

Alternatives to merging

If the goal is visual clarity rather than a single true cell, formatting can often achieve the same result with fewer complications. For a heading, try centering text, applying a fill color, using borders, or giving the title its own row. These choices preserve the underlying cells and are easier to revise when the table grows.

For repeated records, avoid merging cells that represent fields or categories. A column where the same category appears on every row may look repetitive, but repeated values are often useful: they allow the range to be sorted, filtered, and analyzed consistently. If you want to avoid visual repetition in a report, create a separate presentation sheet rather than changing the structure of the source data.

Another option is to combine values into one text cell while leaving the original cells untouched. This is useful when a display label needs to show several pieces of information but the original data still matters independently. Keep in mind that a combined text string is less convenient for calculations and filtering by individual components than separate columns. Choose the format based on the sheet’s purpose, not just how the cells look at first glance.

How merged cells affect editing and analysis

Merged cells can make common spreadsheet tasks less predictable. A sort or filter expects a consistent grid, while a merged range spans multiple cells; depending on the operation and layout, that can prevent the action or produce a result that is difficult to interpret. Copying and pasting ranges can also be awkward when the source and destination have different merged-cell shapes.

Merges can complicate selecting cells, filling formulas down a column, and adding rows or columns within a structured table. They may also make it harder to refer to each piece of information in a formula, because the merged area functions as one cell rather than several independent inputs. If a sheet will be shared with coworkers or used as a data source, simple unmerged rows and columns are generally the safer structure.

A practical rule is to merge only cells that are purely for display and contain no independent data. Keep raw data in an unmerged table, and add a separate formatted report or dashboard for presentation. That separation lets the data remain sortable and reusable while still allowing a polished heading or layout elsewhere.

Frequently Asked Questions

Does Google Sheets keep the first non-empty value when merging?
No. It keeps the upper-left cell’s value, which might be blank even if another cell in the selected range is populated. Move the value you want to retain into the upper-left cell before merging.

Can I merge cells without losing values?
Not as separate cell values. Combine the contents into one value or save a backup before merging. Once values are combined, the merged cell contains one text result, not the original individual entries.

Does unmerging bring the deleted values back?
No. Unmerge restores separate cells but does not restore content that was discarded during the merge. Use Undo soon after the operation or retrieve the data from a backup or earlier version.

Can one merged cell display multiple values?
Yes, if you first join the values into a single text string, such as “North, Central, South.” They will display together, but they will not remain separate values that you can independently sort or calculate with.

Is merging cells a good idea in a data table?
Usually not. Merged cells can interfere with sorting, filtering, copying, and formula workflows. Keep source data in unmerged rows and columns, and use merges only in presentation areas where the cells do not hold separate records.

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.