How do you group rows in Google Sheets?
Row and column grouping adds outline controls on the left or top edge so readers expand or collapse sections. It is a presentation layer: formulas still see all cells whether collapsed or not. Grouping suits budgets, project plans, and any sheet with detail rows under subtotal headers.
When to use it
Use grouping when executives want a one-line department total with optional drill-down, or when long sheets need less scroll without deleting detail.
When to skip it
Skip grouping as a substitute for proper subtotal formulas or pivot tables when analytics are the goal. Do not rely on collapsed rows to hide sensitive data from editors.
How it works
-
1
Select the detail rows beneath a subtotal row (not including the subtotal line itself in the group).
-
2
Choose Data > Group rows (or columns) to create an outline level with +/- buttons.
-
3
Nest groups by grouping smaller sections first, then selecting larger blocks for another group level.
-
4
Click the minus icon to collapse; click plus to expand. Numbers on the gutter show depth.
-
5
Pair grouping with SUBTOTAL or SUM formulas on subtotal rows so collapsed math still makes sense.
-
6
Test print preview if PDF export must show only summary rows for some audiences.
Examples in Google Sheets
Budget by department
Each department has salary detail rows grouped under a subtotal row leadership can collapse monthly.
Project work breakdown
Phase groups contain task rows. Collapse finished phases during standup, expand during planning.
Regional sales sections
Group store-level rows under each region header so the sheet opens at region totals by default.
Better Sheets resources
Common mistakes
-
Grouping the subtotal row inside its own detail block, which double-counts visually.
-
Assuming collapsed rows are excluded from SUM ranges; they are not.
-
Over-nesting five levels deep so +/- controls confuse mobile readers.
-
Grouping before freezing header rows in a way that hides column titles accidentally.
-
Sharing a sheet without a note that important detail is collapsed by default.
Frequently asked questions
- Group vs hide rows?
- Hide removes rows from view without outline controls. Group keeps structured expand and collapse UI.
- Can I group columns too?
- Yes. Data > Group columns works the same way for horizontal sections like monthly buckets.
- Do formulas ignore grouped rows?
- No. Collapsed rows still calculate unless you use SUBTOTAL with the right function number.
- Ungroup everything?
- Select the sheet area and Data > Ungroup rows or columns, or remove groups level by level.
- Group with pivot tables?
- Pivot tables have their own expand collapse. Row grouping is separate on raw grid data.
- Print collapsed groups?
- Print usually includes hidden grouped detail unless you adjust print range or hide rows intentionally.
- Can viewers collapse groups?
- Viewers can use outline controls on shared view-only sheets in most cases.
- Group shortcuts?
- Use the Data menu or right-click selection. Keyboard shortcuts vary by OS and browser.
Related Tutorials
Watch how grouping rows in Sheets works
How to Insert Multiple Rows in Google Sheets (Easy to Hard)
Communicate Better with Gridlines, Border Styles, and Border Colors - Google Sheets
How to Merge Cells in Google Sheets
Move Entire Row when a Cell is changed to "Yes" - The $75,000 Google Script
Related blog posts
Guides that explain grouping rows in Sheets in more depth.
Quick Google Sheets Tips
Boost productivity and streamline your workflow in Google Sheets with our quick tips and free tools. Breathe new life into your spreadsheets today.
Read post →Spreadsheets Explained over 5 Levels of Difficulty
Master Google Sheets from simple text input to complex operations with our FREE tutorials, templates, and tools! Unleash the full power of spreadsheets now!
Read post →How to Use Google Sheets as a Website Database
Did you know you can use Google Apps Script to turn a Google Sheet into a free, auto-syncing database for your website? This guide shows you exactly how to set it up. You’ll prepare your spreadsheet, write a few lines of code and publish your site. Don’t worry if you’re not a developer, we’ll walk you through it. Why Use Google Sheets as a Database? For small projects, Google Sheets offers many advantages over traditional databases: * Free hosting and storage * Easy to edit data without...
Read post →Related terms
sorting data in Sheets
Sorting reorders rows by one or more columns. The Data > Sort range menu sorts selection in place. The SORT function returns a sorted copy that updates when inputs change. Always decide whether related columns must move together as a single row unit.
Read guide →budgets in Google Sheets
A budget sheet compares planned spending or revenue to actuals over time. Rows are categories, columns are months or quarters, and formulas SUM detail lines into subtotals. Variance columns show where you are over or under plan.
Read guide →reports from Google Sheets
A report turns raw data into a readable snapshot: summary metrics, charts, and tables formatted for an audience. Separate source data tabs from a Report tab that uses QUERY, pivot tables, or SUMIF so you refresh inputs without rebuilding layout every week.
Read guide →dashboards
A dashboard is a single view that answers "how are we doing?" without hunting across tabs. In Google Sheets, it is usually a summary tab with big numbers, charts, and conditional formatting fed by QUERY, pivot tables, or IMPORTRANGE from raw data you keep elsewhere.
Read guide →Done reading about grouping rows in Sheets?
Membership unlocks 600+ tutorials, unlimited generators, and every template. Practical lessons. Zero fluff.
Need this once
Jump to a free tool or a single tutorial for this topic.
Learning Sheets for real
Unlock the full library, generators, and templates with membership.