howto.org.in

How to Merge Cells in Google Sheets

Learn how to merge cells in Google Sheets, use merge all, horizontal, or vertical options, avoid data loss, troubleshoot sorting, and read FAQs.

Excel & Google SheetsEdited by Pramod Tiwari
2 min read

Quick Answer

To merge cells in Google Sheets, select the cells, click Format > Merge cells, then choose Merge all, Merge horizontally, or Merge vertically. Keep only the top-left value, because other cell contents may be removed.

What You Need

  • Google Sheets file
  • Edit access
  • Cells to merge
  • Backup or undo if data matters

Safety Precautions

  • Merging can remove data outside the top-left cell.
  • Avoid merged cells in sortable data tables.
  • Use center across a range or formatting alternatives when possible.
  • Check formulas before merging.
  • Warn collaborators before changing shared layouts.

Step-by-Step Instructions

  1. Step 1

    Select cells

    Highlight the adjacent cells you want to merge.

  2. Step 2

    Open Format

    Click Format in the menu.

  3. Step 3

    Choose Merge cells

    Select the merge option that matches your layout.

  4. Step 4

    Confirm data behavior

    Keep or move important content before merging.

  5. Step 5

    Align text

    Use horizontal and vertical alignment for a clean label.

  6. Step 6

    Test sorting if needed

    Avoid merged cells in ranges you plan to sort or filter.

  7. Step 7

    Unmerge if needed

    Select the merged cell and choose Format > Merge cells > Unmerge.

Practical Example

Example: You merge cells across the top of a budget sheet to create one centered title above monthly columns.

Common Mistakes

  • Merging cells that contain multiple values
  • Using merged cells inside sortable tables
  • Forgetting formulas may shift
  • Merging non-adjacent cells
  • Not checking collaborator views
  • Using merge for spacing instead of layout

Troubleshooting

Data disappeared

Use Undo immediately, then move data before merging.

Cannot sort range

Unmerge cells inside the sortable range.

Text is not centered

Use alignment buttons after merging.

Merge option is unavailable

Check edit permission and select adjacent cells.

FAQs

Does merging cells delete data?

It can remove values outside the top-left cell, so move important data first.

Can I unmerge cells?

Yes, select the merged cell and choose Unmerge.

Can I merge cells vertically?

Yes, Google Sheets has vertical and horizontal merge options.

Should I merge cells in tables?

Usually avoid it if you need sorting, filtering, or formulas.

Help us improve this guide

Tell us about an outdated instruction, unclear step, broken link or safety concern. Do not include passwords, account numbers, medical records or other sensitive information.

Email a correction or suggestion