US Trends

how to merge cells in google sheets

To merge cells in Google Sheets, you basically select a range, hit a merge option, and choose what happens to the contents.

How to Merge Cells in Google Sheets

(Quick Scoop guide + a bit of “what people get wrong”)

Core Ways to Merge Cells

1. Standard toolbar/menu merge (desktop)

This is the classic way most people use.

  1. Select the cells you want to merge (for example A1:C1 for a big header).
  1. Go to Format → Merge cells.
  1. Choose one of:
    • Merge all – combines everything into one big cell, only the top‑left value is kept.
 * **Merge horizontally** – merges cells across each selected row.

 * **Merge vertically** – merges cells down each selected column.
  1. Or click the Merge cells icon in the toolbar and pick the same options from the dropdown.

After merging, Google Sheets centers the text vertically in that merged cell by default.

2. On mobile (Google Sheets app)

If you’re on your phone, the flow is slightly different but the idea is the same.

  1. Open your sheet and select the cells you want to merge (tap, then drag the blue handles).
  1. Tap the formatting icon (usually a letter “A” with lines).
  1. Go to the Cell tab.
  1. Scroll down and toggle Merge on.

On mobile this toggle basically does a “merge all” and keeps only the upper‑left cell’s value.

3. Keyboard shortcuts style (desktop navigation)

If you like going via menus but faster:

  1. Select your cells.
  1. Open Format → Merge cells.
  1. Then press:
    • A for Merge all.
 * **V** for **Merge vertically**.

 * **H** for **Merge horizontally**.

This is handy when you’re doing a lot of formatting in one sitting.

Important Warnings (People’s Common Headaches)

Merging is visual; it does not combine the data inside each cell (and it can even throw some away).

  • Only the content of the top‑left cell is preserved; the rest is discarded.
  • Sorting, filtering, and some formulas become awkward or break when there are many merged cells in the middle of a data table.
  • Over‑merging can make your spreadsheet look nice but behave badly (especially for reports used by other people).

If you care about preserving all values, use a formula-based “merge” (really: text combining) instead of actual merged cells.

How to “Merge” Text Without Losing Data

Instead of merging the cells themselves, you can keep each cell separate and combine the values into a new cell, for example to create full names or combined labels.

Popular options:

  • Ampersand:
    • =A1&" "&B1 – joins A1 and B1 with a space.
  • CONCATENATE:
    • =CONCATENATE(A1," ",B1) – same effect, more explicit.
  • JOIN:
    • =JOIN(" ",A1:C1) – joins a range with a delimiter between each value.
  • TEXTJOIN:
    • =TEXTJOIN(" ", TRUE, A1:C1) – like JOIN, but can ignore empty cells (that TRUE flag).

These let you “merge” information into one display cell while keeping your original data intact and sortable.

Mini “What people ask on forums”

People on Google Sheets forums often ask things like:

“Can I merge cells across a whole sheet?”
“Is there a way to merge cells but keep all the values?”

The usual expert replies are roughly:

  • Technically you can merge lots of cells, but you shouldn’t do it across a full data range you intend to sort or analyze.
  • If you want to keep all values, use formulas like TEXTJOIN, JOIN, CONCATENATE, or & instead of real merges.

So, visually merging is great for headers, section titles, and presentation; formula “merging” is better for real data work.

Quick HTML Summary Table (for your post)

Method Where Steps Keeps all data? Best use
Merge all / vertically / horizontally Desktop toolbar or Format menu Select range → Format → Merge cells → choose type (or use toolbar icon). No, only top-left cell value is kept. Headers, titles, visual layout.
Mobile Merge toggle Google Sheets app Select cells → formatting icon → Cell tab → toggle Merge. No, keeps the upper-left value only. Quick formatting on phone/tablet.
Text formulas (&, CONCATENATE, JOIN, TEXTJOIN) Any platform Write a formula like =TEXTJOIN(" ", TRUE, A1:C1) in a new cell. Yes, combines all values into one text string. Data-safe “merge” for reports and analysis.

SEO Bits for Your Post

  • Try to use the phrase how to merge cells in Google Sheets in your title, intro, and one subheading.
  • Short, scannable sections like “Desktop”, “Mobile”, and “Without losing data” help readability and search ranking.
  • Include at least one example formula and one caution about losing data when merging to match what users typically search and ask in forums.

Meta description idea:

Learn how to merge cells in Google Sheets on desktop and mobile, plus how to combine values without losing data using formulas like TEXTJOIN and JOIN.

Information gathered from public forums or data available on the internet and portrayed here.