Row and column grouping in Google Sheets - Step-by-Step Guide

Introduction

Row and column grouping helps you organize your spreadsheet by hiding and showing groups of rows or columns. This makes large sheets easier to read and work with by collapsing sections you don't need to see all the time.

When you have monthly sales data for a whole year and want to collapse each quarter to focus on one at a time.

When you track project tasks and want to hide completed tasks to focus on pending ones.

When you create a budget sheet and want to group expense categories to see summaries easily.

When you have a large table and want to hide detailed rows or columns temporarily for presentations.

When you want to organize data by departments and collapse each department's data for clarity.

Steps

Step 1: Select the rows or columns you want to group

- Spreadsheet grid

The selected rows or columns are highlighted

💡 Click and drag on row numbers or column letters to select multiple rows or columns

Step 2: Right-click on the selected row numbers or column letters

- Spreadsheet grid

A context menu appears with options related to rows or columns

Step 3: Click on 'Group rows' or 'Group columns' from the context menu

- Context menu

A bracket appears next to the grouped rows or columns with a minus sign to collapse

Step 4: Click the minus sign bracket next to the grouped rows or columns

- Left side for rows or top for columns

The grouped rows or columns collapse and hide from view, the bracket changes to a plus sign

Step 5: Click the plus sign bracket to expand the grouped rows or columns

- Left side for rows or top for columns

The grouped rows or columns become visible again

Before vs After

Before

Rows 5 to 10 are all visible showing detailed sales data for each day

After

Rows 5 to 10 are collapsed and hidden, only a bracket with a plus sign appears to expand them

Settings Reference

Group rows

📍 Right-click menu on selected rows

To group selected rows so they can be collapsed or expanded

Default: No grouping

Group columns

📍 Right-click menu on selected columns

To group selected columns so they can be collapsed or expanded

Default: No grouping

Ungroup rows or columns

📍 Right-click menu on grouped rows or columns

To remove grouping and show all rows or columns permanently

Default: Grouped

Common Mistakes

Trying to group non-adjacent rows or columns

Google Sheets only allows grouping of continuous rows or columns

Select only adjacent rows or columns before grouping

Clicking outside the bracket to collapse or expand groups

Only clicking the bracket with plus or minus sign controls grouping

Click exactly on the bracket next to the grouped rows or columns

Summary

Row and column grouping helps hide and show parts of your sheet to keep it tidy.

You can group only adjacent rows or columns by selecting and right-clicking them.

Use the plus and minus brackets to expand or collapse grouped sections easily.