Merging Cells Loses Data; Combine Values Safely Instead

Overview

To merge cells in Google Sheets, select the cells, open Format in the top menu, hover over Merge cells, and choose Merge all, Merge horizontally, or Merge vertically. One warning matters most: native merging is visual, and when the selected cells contain data, the standard Merge Cells tool keeps only the upper-left cell’s content and discards the rest, as documented by tools like Ablebits.

That single behavior is why “how to merge cells in Google Sheets” is really two questions: how to merge, and how to merge without losing text you care about. If your sheet is a static title or a print-only header, merging is quick and harmless. If the same range will later be sorted, filtered, pivoted, exported, or imported into another tool, merging can quietly break those workflows — and that is the deciding factor for which method you should use.

Here is a fast worked example you can apply immediately. Say cell A1 contains Q3 and B1 contains Regional Sales Report, and you want one wide title across A1:B1:

1. Copy the text from B1 somewhere safe, or plan to retype it.
2. Put your full title in the upper-left cell (A1): type Q3 Regional Sales Report.
3. Select A1:B1, go to Format > Merge cells > Merge horizontally.

Because Google Sheets keeps only the top-left value, the result is a clean merged title with no lost text — you preserved the wording by consolidating it into A1 before merging, not after. The rest of this guide expands that pattern into every merge type, safer formula alternatives, and the situations where you should not merge at all.

What merging cells actually does in Google Sheets

Merging cells changes the layout of the grid: two or more selected cells become one larger visual cell that spans multiple rows, columns, or both. It is a formatting action, not a data operation. The most important consequence to internalize is that a merged range holds a single value — the upper-left one — so any content in the other cells is dropped when you merge.

That is different from combining the values in those cells, which keeps every piece of text and writes the result somewhere new. Google Sheets offers dedicated functions for that job, including CONCATENATE, JOIN, TEXTJOIN, and the ampersand (&) operator. A Reddit thread in r/googlesheets, for example, recommends =CONCATENATE(A1," ",B1) to combine a first name in column A with a last name in column B — the source cells stay intact, and the joined text appears in a new cell.

The practical takeaway: reach for Format > Merge cells when you want a bigger visual box for a title or header, and reach for a formula when you need to keep all the underlying text. Confusing the two is the single most common reason people lose data while “merging.”

Visual merge versus combining values

A visual merge (Format > Merge cells) reshapes the grid and keeps one value. A formula such as =A2&" "&B2 or =TEXTJOIN(", ",TRUE,A2:C2) creates a brand-new combined value in whatever cell you type it into, without touching or physically merging the source cells.

The distinction matters because the two approaches have opposite side effects. A visual merge makes a range look unified but leaves the sheet harder to sort and query. A formula leaves the grid perfectly rectangular and machine-readable while producing a display value you can show wherever you like. If your data will ever be analyzed or moved, the formula approach is almost always the safer default.

How to merge cells from the Format menu

The Format menu is the primary, most reliable path on desktop and gives you all three merge types in one place. Before you start, do a quick safety check: if any of the cells you are about to merge contain data you need, either duplicate the sheet first (right-click the tab > Duplicate) or combine the values into the upper-left cell so nothing is lost.

To merge from the menu:

1. Click and drag to select the cells you want to merge.
2. Open Format in the top menu.
3. Hover over Merge cells.
4. Choose Merge all, Merge horizontally, or Merge vertically.

This is the same three-step flow described in mainstream tutorials such as Coursera’s guide, which highlights Format and then Merge cells as the core path. If your selection holds multiple values, Google Sheets keeps only the upper-left cell — so the pre-merge cleanup above is what actually protects your data. The next three subsections explain when to pick each merge type.

Merge all

Merge all combines every cell in your selection into one single large cell, regardless of how many rows and columns you highlighted. Use it when you want one unified area, such as a report title stretched across the top of a sheet or a single label spanning a block of the grid.

Because the entire selection collapses to one cell holding the upper-left value, Merge all is best reserved for presentation elements where there is only one piece of text to show anyway. A 2×4 block of populated data cells merged with Merge all becomes one cell with one value — the other seven are gone.

Merge horizontally

Merge horizontally merges the cells across each selected row separately, so every row in your selection becomes its own merged cell while the rows stay distinct from one another. It is the right choice for row-level headers — for example, a title bar that spans columns A through F but sits on its own row above the data.

This option keeps your rows intact, which is useful when you have several stacked headings that each need to span the same width. Each row still keeps only its upper-left value, so apply the same pre-merge text cleanup per row.

Merge vertically

Merge vertically merges the cells down each selected column separately, turning each column of the selection into one tall merged cell while keeping the columns distinct. It suits vertical labels, such as a category name running down the side of a grouped section.

As with the other types, only the top cell’s value in each column survives the merge, so move any text you need into that top cell first. Vertical merges are especially prone to interfering with sorting, because a sort tries to rearrange rows that a vertical merge has locked together.

How to merge cells with the toolbar or keyboard

Beyond the Format menu, Google Sheets gives you a toolbar button and keyboard shortcuts for faster access. In the toolbar, the merge control sits near the borders icon; Catchr’s tutorial notes that you “click the Merge icon located next to the Borders icon in the toolbar,” and clicking its dropdown arrow exposes the same Merge all, horizontal, and vertical options.

Keyboard shortcuts exist but vary by operating system, so verify them in your own environment before relying on muscle memory. Reported sequences include the following:

• Open the merge path from Format: Alt + O + M (Windows, Chrome OS) or Ctrl + Option + O + M (Mac), per Ablebits.
• Merge all / vertically / horizontally: add A, V, or H to that sequence — for example Alt + O + M + A for Merge all on Windows or Chrome OS.
• A shorter merge toggle: Unito reports Alt + O on a Windows desktop and Ctrl + Option + O on a Mac.

Because these combinations differ between sources, browsers, and keyboard layouts, treat them as candidates to test rather than guarantees. If a shortcut does nothing, fall back to the Format menu, which behaves consistently.

How to merge cells in the Google Sheets mobile app

On mobile, open the sheet in the Google Sheets app, tap and highlight the rows or columns you want to combine, then use the merge toggle to merge them. The workflow is quicker but more limited than desktop: Unito notes that the Google Sheets mobile app only lets you use the “Merge all” option.

That limitation has a real consequence for your data. If you need row-level or column-level control — Merge horizontally or Merge vertically — switch to a desktop browser, where all three options are available. And because Merge all still keeps only the upper-left value, a quick mobile merge can silently drop text that a formula-based approach would have preserved. When you are away from your computer and the cells hold data you cannot afford to lose, it is safer to wait and merge on desktop, or combine the values with a formula instead.

How to unmerge cells in Google Sheets

To unmerge, select the merged cell (or a range containing it), open Format > Merge cells, and choose the merge control again to toggle it off; you can also click the toolbar merge button to reverse an existing merge. In many walkthroughs this is a single toggle — selecting the merge icon a second time unmerges the cell.

The important caveat is that unmerging restores the grid structure but does not restore data that was discarded during the original merge. If merging kept only the upper-left value and dropped the others, unmerging simply gives you back empty cells where that content used to be — the lost text does not reappear. If you need those values back, recover them from a duplicate of the sheet, from version history (File > Version history), or from your original source data. This is exactly why duplicating a sheet before a large merge is worth the extra few seconds.

Merge cells without losing data

If you want to combine what cells say while keeping every underlying value, do not use the visual merge tool — build the combined text with a formula first, then apply visual formatting only if you still need it. The pattern is: keep your source columns exactly as they are, add a helper cell or column that joins the values, and reference that helper wherever you want the combined display.

The example from the Overview scales up cleanly here. Instead of overwriting cells, you write a formula into an empty cell so the originals stay editable, sortable, and ready for export. The two subsections below give exact, copyable formulas for a single row and for a whole column.

Single-row examples

For one row, pick the formula that matches the separator you want:

• First and last name with a space: =A2&" "&B2 — joins the value in A2 and B2 into Jane Doe.
• Comma-separated values across a range: =TEXTJOIN(", ",TRUE,A2:C2) — joins A2, B2, and C2 with commas, and the TRUE argument skips blank cells so you do not get stray separators.
• Line-broken values in one cell: =TEXTJOIN(CHAR(10),TRUE,A2:C2) — stacks the values on separate lines using a newline character; enable Format > Wrapping > Wrap on that cell so the line breaks display.

Each formula writes its result into the cell you type it in, leaving A2, B2, and C2 untouched. That means you get the readable, “merged-looking” text while your raw fields remain individually usable — the outcome the visual merge tool cannot give you.

Column-wide example

To combine an entire column of values at once, use =ARRAYFORMULA(A2:A&" "&B2:B) in the first cell of a new display column. This single formula fills the whole column, pairing each first name in column A with each last name in column B, and it mirrors the approach Ablebits demonstrates with =ARRAYFORMULA(A2:A10&" "&C2:C10) for a bounded range.

The advantage is that you create one clean display column while columns A and B stay fully intact for sorting, filtering, and analysis. If you would rather cap the range instead of running it open-ended, swap A2:A and B2:B for explicit endpoints like A2:A10 and B2:B10. Either way, the source data is preserved, which is exactly what you want if the sheet will be exported, uploaded, or queried later.

Merge cells, combine values, or avoid merging

The right choice depends on what the sheet is for. If it is a presentation surface, a native merge is fine. If the data feeds analysis or other tools, combine values with formulas or skip merging entirely. The matrix below maps common goals to the safest method.

Goal or context	Native merge (Format > Merge cells)	Combine values (formula)	Formatting alternative
Centered title or dashboard header	Works well	Not needed	Center-align across a title row
Row-level or section headers	Works, but locks the row	Better if the header carries data	Bold + fill on a separate row
Sortable data range	Avoid — interferes with sorting	Safe — keeps rows rectangular	Keep cells unmerged
Filtered or pivoted data	Avoid	Safe	Keep cells unmerged
Combining names or fields into one value	Loses all but upper-left	Best fit (&, TEXTJOIN)	N/A
Shared or collaborative sheets	Risky if others rely on structure	Safe and transparent	Separate presentation tab
Data to be exported, imported, or queried	Avoid in raw ranges	Safe display column	Keep raw range clean

The three subsections below turn this matrix into plain guidance.

When native merging is fine

Native merging is appropriate in presentation-only layers — a title row, a dashboard heading, or a print view — where the underlying cells do not need to be sorted, filtered, queried, or fed into automation. In a small, manually maintained sheet such as a one-off class list or a printed schedule, the practical risk is low and the readability gain is real.

The test is simple: if nothing downstream reads that range as structured data, a visual merge costs you nothing. Keep the merge confined to the cosmetic layer and away from your actual records.

When formulas are safer

Formulas are the better choice whenever you need one combined display value but must keep the separate source fields for analysis, imports, uploads, or later edits. Joining First name and Last name into a Full name display field with =A2&" "&B2 gives you the readable output without destroying the individual columns.

This matters most for anyone maintaining data that other people or systems consume. Because the raw fields stay intact, you can still sort by last name, filter by first name, or export both columns cleanly — none of which is possible once those cells are physically merged.

When formatting alternatives are better

Sometimes you want the look of a merged header without any merge at all, which keeps the grid machine-friendly. Useful alternatives include centering text across a title row, enabling Wrap so long labels stay in one cell, adding borders to visually group a section, using a dedicated header row above the data, and keeping raw data on one tab with a separate presentation sheet for styled views.

These techniques give you attractive, readable layouts while leaving every cell individually addressable. That is the ideal state for sheets that will be sorted, queried, or handed to a tool that expects a rectangular grid — and it avoids every failure mode covered in the next section.

Common problems with merged cells

Merged cells cause a recognizable set of problems, most of which trace back to one root cause: merging creates an uneven grid, and Google Sheets features that expect neat rows and columns struggle with it. The subsections below cover the failures you are most likely to hit and how to respond to each.

The Merge cells option is greyed out or unavailable

If Merge cells is greyed out or won’t apply, the usual cause is the state of your selection or the sheet’s permissions. Work through these likely blockers:

• Invalid or single-cell selection: merging needs two or more adjacent cells selected.
• An existing partial merge: if your selection overlaps cells that are already merged, Google Sheets may refuse the operation until you unmerge first.
• Protected ranges: if the range is protected and you lack edit rights, structural changes like merging can be blocked.
• A filtered or special view: try clearing filters and returning to the standard grid before merging.
• Permissions: confirm you have edit (not view or comment) access to the file.

Because several of these involve shared or protected data, test any fix on a duplicated sheet before changing a range other people depend on. That way an accidental unmerge or overwrite never touches the live version.

Sorting, filtering, and pivot tables stop working cleanly

Merged cells create ranges of uneven shape, and sorting or filtering needs to rearrange whole rows or columns as uniform units. When a merged cell spans several rows, Google Sheets cannot cleanly reorder them, so a sort may be blocked entirely or applied only in part, and filters can behave unpredictably around the merged region.

Pivot tables have the same expectation of a clean rectangular source. The reliable fix is structural: keep your raw data completely unmerged and move any merged styling into a separate header row or a dedicated presentation sheet. Analysis features then see a tidy grid and behave as intended.

Formulas, QUERY, FILTER, and ARRAYFORMULA behave unexpectedly

Functions such as QUERY, FILTER, and ARRAYFORMULA are built to operate on regular rectangular ranges, where every row and column lines up. Merged cells break that assumption — a merged region leaves blank cells underneath the retained value, which can produce confusing references, misaligned outputs, or results that simply skip rows even when the formula itself is written correctly.

The practical rule is to keep merges out of any range a formula reads from. If you need a combined value for display, generate it with a formula (as shown earlier) rather than merging the source cells, so your analytical ranges stay uniform and predictable.

Copying and pasting merged cells changes the layout

Copying a merged range and pasting it elsewhere can carry the merge formatting into the target area, unmerge cells unexpectedly, or overwrite merges that already exist there. The result is often a layout that looks broken in ways that are tedious to unpick.

To avoid surprises, test with Edit > Paste special > Values only when you only want the content, and unmerge cells before moving analytical data so the paste lands in a predictable grid. When in doubt, paste into an empty area first and confirm the layout before overwriting anything important.

A safer layout pattern for reports and datasets

Picture a common failure: you build a monthly report, merge a title across the top of the data range to make it look polished, then share it. A colleague tries to sort the table by value — and the sort is blocked or scrambles rows because the merged header sits inside the same range. The formatting that looked professional has made the data unusable.

The safer pattern separates presentation from data. Keep the raw records in a clean, fully unmerged range with one value per cell. Put any title styling in its own row above the data or, better, on a separate presentation tab, and never merge cells inside a range that will be sorted, filtered, queried, uploaded, imported, or turned into an interactive table. This is the same discipline data teams apply to pipelines: a clean rectangular grid is what downstream tools expect.

That discipline pays off the moment your spreadsheet leaves Google Sheets. If you later publish a dataset as a shareable, filterable web page — for instance with a tool like TablePage, which lets you drag and drop CSV, TSV, XLSX, or XLS files and instantly generates a public dataset page with charts and a filterable table — an unmerged source range imports cleanly, while merged headers can leave blank cells and misaligned columns that muddle the output.

Sample clean field layout

Here is a machine-friendly layout that still supports a combined display value. Notice how a display field lives alongside — not instead of — the raw source columns:

First name | Last name | Full name display | Department | Month | Metric | Value

In this structure, Full name display is produced by a formula like =A2&" "&B2 rather than by merging First name and Last name. Every column stays individually sortable and filterable, the display field gives you the readable “merged” look, and the whole range remains ready to export or upload. A grid like this is exactly what stays intact when uploaded and shared as an interactive page where anyone can explore charts and a filterable table without signing up.

How to clean up existing merged cells

If you have inherited a sheet full of merged cells, resist the urge to unmerge everything in place — work on a copy so you can recover anything the cleanup disturbs. A safe, repeatable workflow looks like this:

1. Duplicate the sheet (right-click the tab > Duplicate) so the original stays untouched.
2. Scan the copy for visible merged regions, especially inside data ranges rather than headers.
3. Select the affected range and toggle Format > Merge cells off to unmerge.
4. Fill in repeated labels where unmerging left blanks, so each row is self-contained.
5. Test sorting and filtering to confirm the range now behaves as a clean grid.

Once the data range is unmerged and verified, you can preserve a separate presentation copy if you still want the styled, merged look for viewing or printing. The goal is one clean, analyzable version of the data plus, optionally, one pretty version — never a single sheet trying to be both. This preparation is also what makes a dataset safe to export to CSV or XLSX and publish downstream.

Quick answers

How do I merge cells without losing the text from the other cells? Combine the values with a formula before merging, or instead of merging. Use =A2&" "&B2 for two cells or =TEXTJOIN(", ",TRUE,A2:C2) for a range, then apply visual formatting only if you still need it. The native merge tool keeps only the upper-left value.

Why is Merge cells greyed out or unavailable? Common causes are a single-cell or invalid selection, an overlapping existing merge, a protected range, an active filtered view, or view-only permissions. Select two or more adjacent cells, clear filters, unmerge any overlap, and confirm you have edit access — testing on a duplicate sheet first.

Should I merge cells in a sheet I need to sort, filter, or pivot? No. Merged cells create uneven ranges that can block sorting, disrupt filters, and confuse pivot tables. Keep the data range unmerged and put any styled header in a separate row or tab.

Can I merge cells in the mobile app? Yes, but the Google Sheets mobile app only offers Merge all. For Merge horizontally or Merge vertically, use a desktop browser.

How do merged cells affect formulas like QUERY, FILTER, and ARRAYFORMULA? These functions expect rectangular ranges, so merged cells can cause misaligned outputs, skipped rows, or confusing references. Keep merges out of any range a formula reads from.

Are merged cells safe in imported or shared datasets? Generally no. If the data will be imported, queried, exported, or turned into an interactive table, keep the raw range unmerged and use a separate presentation layer — a clean grid is what tools like TablePage and other downstream systems read most reliably.