Merge cells in Google Sheets - Step-by-Step Guide

Introduction

Merging cells combines two or more adjacent cells into one larger cell. This helps to create clear titles or organize data better in your spreadsheet.

When you want to create a title that spans across several columns.

When you need to center a label over multiple cells for better readability.

When you want to combine empty cells to make a cleaner layout.

When you want to group related data visually by merging header cells.

When you want to reduce clutter by combining cells with the same content.

Steps

Step 1: Select the cells you want to merge

- Spreadsheet grid

The selected cells are highlighted with a blue border

Step 2: Click the Merge cells button

- Toolbar at the top (icon looks like two cells merging)

The selected cells combine into one larger cell

Step 3: Choose the merge type from the dropdown

- Merge cells button dropdown

The cells merge according to your choice: Merge all, Merge horizontally, or Merge vertically

💡 Use 'Merge all' to combine all selected cells into one big cell

Step 4: Check the merged cell content

- Merged cell in the spreadsheet

Only the content from the top-left cell remains visible; other contents are removed

Before vs After

Before

Cells A1, B1, and C1 each contain separate text: 'Sales', '2023', 'Q1'

After

Cells A1, B1, and C1 merge into one cell A1 with text 'Sales' centered across the combined width

Settings Reference

Merge all

📍 Merge cells button dropdown in the toolbar

Combine all selected cells into one single cell

Default: No merge (cells remain separate)

Merge horizontally

📍 Merge cells button dropdown in the toolbar

Combine selected cells only across columns in the same row

Default: No merge (cells remain separate)

Merge vertically

📍 Merge cells button dropdown in the toolbar

Combine selected cells only down rows in the same column

Default: No merge (cells remain separate)

Common Mistakes

Merging cells with important data in multiple cells

Only the top-left cell content remains after merging; other data is lost

Copy or move important data to the top-left cell before merging

Trying to sort data after merging cells

Merged cells can cause sorting errors or unexpected results

Avoid merging cells in data tables that need sorting or filter; use merging only for headers or labels

Summary

Merging cells combines multiple adjacent cells into one larger cell.

Only the top-left cell content remains visible after merging.

Use merging mainly for titles, labels, or layout, not for data tables that require sorting.