No: Google Sheets keeps the content of only the upper-left cell when you merge a range, and discards the contents of the other cells. To preserve that information, combine it into one cell first, copy the combined result, paste it as a value into the range’s upper-left cell, and then merge.
What happens when you merge cells in Google Sheets?
Merging makes a selected group of adjacent cells act as one larger cell for display and editing. It is useful for a heading that spans several columns, such as a report title above a table. It does not combine the contents of those cells automatically. If A1 contains “North,” B1 contains “Region,” and C1 contains “Sales,” merging A1:C1 leaves only “North” as the cell content. “Region” and “Sales” are lost from the sheet’s active cell grid.
The same rule applies if the other cells contain numbers, dates, formulas, or formula results: only the upper-left cell’s content is retained in a merged group. A formula in that first cell remains a formula unless you replace it with a value first. Formatting and content are different things, so do not assume that keeping a cell’s appearance also keeps its data.
When a selection contains multiple rows or columns, the result depends on the merge option. “Merge all” creates one merged cell for the whole selection. “Merge horizontally” merges cells row by row, and “Merge vertically” merges cells column by column. In each resulting group, the upper-left cell is the one whose content survives.
How to combine the contents before merging
For a short label, you can manually assemble the desired text in the upper-left cell before merging. For a longer range, a helper cell and the TEXTJOIN function are less error-prone. This example combines three adjacent labels with spaces between them.
- Keep the original contents in A1:C1 and leave D1 empty as a helper cell.
- In D1, enter
=TEXTJOIN(" ",TRUE,A1:C1). With “North” in A1, “Region” in B1, and “Sales” in C1, the result in D1 is “North Region Sales.” - Copy D1. Select A1, then choose Edit > Paste special > Values only. You can also use Ctrl+Shift+V on Windows or ChromeOS, or Command+Shift+V on a Mac.
- Check that A1 now contains the complete text, then select A1:C1 and choose Format > Merge cells > Merge all.
- Delete the helper cell if you no longer need it. Keep a copy of the original range if you may need to inspect or reuse its separate values later.
Using Paste special > Values only is important here. If you put a formula in A1 that refers to A1:C1 and then merge that range, the formula would depend on cells whose contents are being removed. Pasting the completed result as a fixed value avoids that dependency. If you want to preserve the original entries as separate data, leave them where they are and put the combined label in a separate heading cell or another safe location instead of overwriting them.
Choose a separator that keeps the meaning clear
A combined value is useful only if a reader can still interpret it. A space works well for words, as in “North Region Sales.” For codes, dates, or values that might otherwise run together, a comma, slash, dash, or line break may be clearer. Consider how the text will look in the final column width and whether the separator could already appear in the source values.
TEXTJOIN can skip empty cells when its second argument is TRUE, which helps when some entries in the selected range are blank. However, skipping blanks can also hide the fact that a field was missing. If empty positions carry meaning—for example, if each cell represents a distinct part of an identifier—use a separator or layout that makes those gaps apparent, or review the source cells before joining them.
Also think about data types. Joining numbers and dates into a text label changes the result into text, not a new numeric value that can be summed or sorted as a number. If the values are meant for calculation, keep them in separate cells and use a merged cell only for a visual heading. For information that must remain sortable, searchable, and reusable, a separate label column is usually safer than combining the original records.
Merge cells in the browser
In Google Sheets in a web browser, select the adjacent cells you want to merge, then use Format > Merge cells and choose the appropriate option. The available choices include Merge all, Merge horizontally, and Merge vertically; Unmerge is available when a selected range is already merged. The toolbar also has a Merge cells control, but the Format menu makes it easier to choose the direction deliberately.
Before clicking a merge option, check the selected range and identify its upper-left cell. That is the cell whose content will remain in each merged group. If you are merging a heading across A1:D1, for example, prepare the final heading in A1. If you are merging horizontally across several rows, prepare each row’s first cell separately: each row becomes its own merged group rather than one large block.
After merging, review the alignment and wrapping. Use the toolbar’s horizontal and vertical alignment controls to position the text, and use text wrapping if the label is long. Merging changes the layout, not the wording or the amount of information represented by a label, so adjust column widths and row heights only after confirming the content is correct.
When merging is a poor choice
Merged cells are best for presentation areas such as a title above a report, a section heading, or a form label spanning multiple columns. They are usually a poor fit inside the body of a dataset. Sorting, filtering, filling formulas down, copying rectangular ranges, and importing data all work most predictably when each record occupies one row and each field has its own cell. Merged cells can interfere with those operations or make a selected range harder to manipulate.
For example, imagine a sales table with a region name merged across four rows, one for each product. The region is visually clear, but the individual product records do not each have a region value in their own row. A filter or export may not treat the layout as the reader expects. Repeating “North” in each row is more suitable for analysis, while a separate merged heading above the table can still provide a polished appearance.
- For a visual title: merging can be appropriate if the surrounding cells are not part of the working data table.
- For records used in sorting or filtering: keep one value per cell and repeat labels where each row needs its own value.
- For text that should span blank cells: leave the cells unmerged and consider whether the label can sit in a wider column or in a separate heading row.
- For a calculation or export: preserve the source values in separate cells and create a display label elsewhere.
What to do if data has already disappeared
If you have just merged the range and have not made other changes, try Undo immediately: Ctrl+Z on Windows or ChromeOS, or Command+Z on Mac. Undo can reverse the merge and restore the prior cell contents when the merge is the most recent action. Check the restored range rather than assuming the recovery worked.
If more work has happened since the merge, look at File > Version history > See version history. An earlier version may contain the unmerged data. Restoring a prior version affects the spreadsheet as a whole, so inspect the version and consider making a copy before restoring if newer edits matter. Version history is not a substitute for a backup of important source data, and it may be inconvenient to recover just one range from an older document state.
Unmerging alone should not be treated as data recovery. It restores the cell layout, but it does not recreate values that were discarded from the non-upper-left cells. If the information is not available through Undo, version history, a copy, or another source, it may need to be entered again.
Alternatives that keep the cells separate
If the goal is simply to make a heading look centered over a group, first consider whether a merged cell is necessary. You can leave the cells separate, put the heading in one cell, adjust the column width, and use alignment and text wrapping to make it legible. You can also use fill color, borders, and a distinct heading row to visually group columns without merging them. These approaches preserve the ordinary cell structure, which is useful when the sheet will be filtered, copied, or maintained by other people.
If you need to display several pieces of information together while retaining the originals, put the combined result in a dedicated display cell or a separate sheet. If you need to make one data value cover several records, repeat that value in every relevant row rather than using a vertically merged block. These choices may look less compact, but they preserve the structure expected by formulas, sorting, filtering, and data exports.
Excel has similar merge options and the same general risk: merging does not concatenate all selected values. Some Excel versions and workflows offer other presentation techniques, but a Google Sheets menu path or behavior should not be assumed to apply in Excel. For this task, follow Sheets’ own Format > Merge cells controls and verify the resulting cell contents in the browser.
Frequently Asked Questions
Does Google Sheets warn you before deleting the other cell contents?
Do not rely on a warning as protection. The safe assumption is that content outside the upper-left cell will be discarded when the merge is made. Combine or copy anything you need before choosing a merge option.
Can I unmerge cells and get the old values back?
Unmerging returns the cells to separate positions but does not restore the values that were removed. Use Undo if the merge was your last action, or look for an earlier version through File > Version history.
Can I merge cells that contain formulas?
Yes, but only the formula in the upper-left cell remains as cell content. Formulas in the other cells are removed along with their contents. If their results matter, combine or copy the needed results first, then paste values into the cell that will remain.
Does Merge horizontally keep the first value in every row?
Yes. It creates a separate merged group for each selected row, and the leftmost cell in each group is the one to prepare. Merge vertically works by column, retaining the top cell in each resulting group.
What is the safest way to make a heading span columns?
For a purely visual heading, place its complete text in the range’s upper-left cell and merge only after confirming the other selected cells are empty or their contents are backed up. If the range is part of a working dataset, keep it unmerged and use a separate heading row instead.
Related
- Google Sheets Join Columns: Formulas and Methods That Work
- Google Sheets Jira Connector: Setup, Sync, and Options
- Google Sheets INDIRECT in Data Validation: How It Works
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Google Sheets Apps Script Page Not Found? Causes and FixesIf Google Sheets Apps Script says “page not found,” first check that you opened the script editor from…
- Google Debt Snowball Spreadsheet: Build One in SheetsYes. You can build a debt snowball spreadsheet in Google Sheets by listing each debt, sorting debts from…
- Camping Meal Planner Spreadsheet: Plan Meals and Pack FoodA camping meal planner spreadsheet helps you map meals to each day, estimate how much food to bring,…
- Google Sheets Date Formatting: A Practical Guide to DatesTo format a date in Google Sheets, select the cell or range, then choose Format > Number >…
- Excel Data Model and SharePoint: How They WorkYes. You can save an Excel workbook that contains a Data Model in a SharePoint document library; the…
- Make an Academic Poster in PowerPoint: Step by StepYes. In PowerPoint for Microsoft 365 on Windows, start with a blank slide, choose Design > Slide Size…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.