How to Create a Drop-Down List in Google Sheets

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

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.

We'll show you how to add both easily!
Michael Michael (174)

In this guide, we'll show you how to add both a column and a row to your spreadsheet in Google Sheets. Can I add a blank column or row in Sheets without formatting?