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 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.
Hold shift and click on the rows you want to group into a drop-down list.
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!).
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?
