How to Create a Drop-Down List in Google Sheets

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

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. As an Amazon Associate, we may earn a small affiliate commission at no cost to you when you buy through our links.

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!).

Sheets calls this "protecting" cells.
Michael Michael (175)

Google calls locking cells—"protecting" cells. And it's really quite easy to lock a cell in Google Sheets. What does it mean to lock a cell in Google Sheets?