Trusted Reviews is supported by its audience. If you purchase through links on our site, we may earn a commission.Learn more.
How to create a drop-down list in Google Sheets
In This Article
Struggling to gather all of your information in Google Sheets? Try creating a drop-down menu to display all of your statistics concisely.
Google Sheets allows you to create spreadsheets directly in your browser and comes with a lot of handy features. One of the best features of Google Sheets is the ability to add drop-down menus, to make organising your work even easier.
If you want to learn how to create and edit a drop-down menu in Google Sheets, keep reading, as we’re going to be running through the process with a simple step-by-step guide.
S23 Ultra and Galaxy Chromebook Go Bundle
Samsung fans can nab an S23 Ultra with a Galaxy Chromebook Go for a seriously reduced price with this incredible bundle.
What you’ll need:
The Short Version
Step1
Open a new spreadsheet
Open a new Google Sheets spreadsheet on your PC.
Step2
Select the cells where you want to create a drop-down list
Select all the cells where you want to create a drop-down list by clicking and dragging over them.
Step3
Click Insert
From the menu at the top of the screen, click Insert.
Step4
Go to Drop-down
Select Drop-down from the menu.
Step5
Add another item if needed
If you need to add more items in your drop-down menu, click on Add another item.
Step6
Label all the items
Label all of your drop-down items.
Step7
Add colours if needed
If you want to add colours to all your drop-down menu items, select them now.
Step8
Click Advanced options
Click on Advanced options.
Step9
Select all options you require
Select any options in this section that you require for your drop-down menu.
Step10
Click Done
Once you are happy with your drop-down menu, click Done.
Step11
Insert your drop-down menu
Insert your drop-down menu items.
Troubleshooting
Yes, you can edit your drop-down menu at any time once it has been created.
Yes, you can delete a drop-down menu created in Google Sheets if you need to.
You might like…
Gemma joined Trusted Reviews as a staff writer after graduating from Leeds Beckett University with a Journalism degree. She’s worked with national outlets, covering breaking news stories to reviews fo…
Founded in 2003, Trusted Reviews exists to give our readers thorough, unbiased and independent advice on what to buy.
Today, we have millions of users a month from around the world, and assess more than 1,000 products a year.
Editorial independence means being able to give an unbiased verdict about a product or company, with the avoidance of conflicts of interest. To ensure this is possible, every member of the editorial staff follows a clear code of conduct.
We also expect our journalists to follow clear ethical standards in their work. Our staff members must strive for honesty and accuracy in everything they do. We follow the IPSO Editors’ code of practice to underpin these standards.
Why trust our journalism?
Founded in 2003, Trusted Reviews exists to give our readers thorough, unbiased and independent advice on what to buy.
Today, we have millions of users a month from around the world, and assess more than 1,000 products a year.
Editorial independence means being able to give an unbiased verdict about a product or company, with the avoidance of conflicts of interest. To ensure this is possible, every member of the editorial staff follows a clear code of conduct.
We also expect our journalists to follow clear ethical standards in their work. Our staff members must strive for honesty and accuracy in everything they do. We follow the IPSO Editors’ code of practice to underpin these standards.
