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

Google Sheets tutorials›Spreadsheet basics›Group columns

Google Sheets · Verified tutorial

Group columns in Google Sheets

Group columns B through D using the column headers. Leave the group expanded and do not change any values.

Verified by JosephineJuly 25, 2026About 60 seconds

Quick answer

Group columns B through D using the column headers. Leave the group expanded and do not change any values.

Step-by-step

1

Select the targetGroup columns B through D.

2

Complete the next actionthe column 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

Columns B through D have a column 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. Columns B through D have a column 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 columns B through D.
Complete the next action. the column headers.
Apply the change. Leave the group expanded and.
Columns B through D have a column group.