New: ready-to-use spreadsheet templatesExplore the collection →

Google Sheets tutorials›Spreadsheet basics›Group rows

Google Sheets · Verified tutorial

Group rows in Google Sheets

Group rows 2 through 4 using the row headers. Leave the group expanded and do not change any values.

Verified by JosephineJuly 25, 2026About 60 seconds

Quick answer

Group rows 2 through 4 using the row headers. Leave the group expanded and do not change any values.

Step-by-step

1

Select the targetGroup rows 2 through 4.

2

Complete the next actionthe row headers.

3

Apply the changeLeave the group expanded and.

Shortcut or faster method

Select the full target range first. This avoids repeating the same change cell by cell.

Expected result

Rows 2 through 4 have a row group.

Common mistake

Changing the source values while applying the formatting or structure change.

Troubleshooting

Undo the last change, reselect the intended range, and try again. Rows 2 through 4 have a row group.

Example spreadsheet data

This is the clean fixture used for the verified run.

Employee	Department	Week	Hours
Anna	Design	Week 1	32
Ben	Sales	Week 1	38
Cara	Finance	Week 2	35
Dev	Operations	Week 2	40
Eva	Support	Week 3	36

Video transcript

Open the prepared Team schedule spreadsheet.
Select the target. Group rows 2 through 4.
Complete the next action. the row headers.
Apply the change. Leave the group expanded and.
Rows 2 through 4 have a row group.