How to Create a Drop-Down List in Google Sheets

To create a drop-down list, you "group" the rows.
Michael Michael (179)
0

In Google Sheets, you create a drop-down list by "grouping" the rows of your spreadsheet. We'll walk you through how to group rows in Google Sheets so that users can expand and minimize a drop-down list you've created.

Google WorkspaceGoogle Workspace ×1

Howchoo is reader-supported. When you buy through links on our site, we may earn a small affiliate commission at no cost to you.

Select rows Google Sheets

Hold shift and click on the rows you want to group into a drop-down list.

Select Group Rows Google Sheets

Right-click on the highlighted rows and choose Group rows #-#.

minimize or expand a group google sheets

To minimize or expand your drop-down list in Google Sheets, click on the + or - sign on the left of the spreadsheet.

You can continue to edit the drop-down list and add more rows if necessary.

If you want to optimize your workflow, visit this guide to see how you can [view the latest list of keyboard shortcuts in Google Sheets]((yzu1n2zizjn!).

Expand what you can do in Google Sheets!
Britt Britt (54)
1 minute

Google Sheets makes it easy to create data spreadsheets that can be used by a team of collaborators.