In this post, I am going to show you how to add drop down list in google sheets. There are many different types of lists that you could use but I will just focus on the dropdown list.

This is a very common type of list and it is easy to set up. It should only take about 10 minutes for someone with basic computer skills to complete this process, so please read through the steps carefully before starting!

What are Google Sheets:

Google sheets is a piece of software that you can use to do calculations, functions, and sorting on your data. In addition, the program will automatically save all of your information so it is always there when you need it.

The drop-down list in google sheets:

A drop-down list is a way of setting up a list within a spreadsheet. This list will vary based on what you put in it, but some examples include favorite colors, products for sale, and options of payment.

How to add drop down list in google sheets

google sheets drop down list

Here are the steps for how to add drop down list in google sheets:

Step 1: Open Google Sheets and click on the Format button (this is the paint roller one)

Step 2: Click on “data validation” to open up this window. Do not hit the next step until you are at this window!

Step 3: Click on “data validation” to see this dropdown list choice.

Step 4: In the “criteria” section, click on “cell value is equal to…” Then type this in as shown below.

*Note: one of my cells was named ’18’ so I had to change it from ‘integer’ to ‘rank’. Yours might be different!*

Step 5: Now, click on “OK” and you have successfully added a drop-down list to your sheet!

Step 6: Now it is time to test your dropdown list. If everything works out as planned the option that you selected in step 4 will appear when you choose something from the list below. In this case, I chose ’18’ and the dropdown list automatically selected ‘Ishant Sharma’ in cell B22.

Why We Use Google Sheets:

There are many benefits to using Google Sheets. For example, it is easy to use and very powerful. This program can be used on any device (smartphone, tablet, or computer) and all of your information will be saved as long as you sign in to your Google account before starting this process!

Off-Topic: LiveUpdater is a website with articles on tech, insurance, law, and medical topics. We also write about gadgets. Share your problem with us I will give you the best and possible solutions and answers.

The Benefits Of Drop Down List In Google Sheet

benefits of drop down list in google sheets

1. Only one person needs access to a spreadsheet to be able to use the list.

2. Less time-consuming than typing every item individually each time you need a new list.

3. Saves time from having to go back and edit lists that have grown too large with extra information that will never be used again.

4. Easy to change or update list information.

5. Each individual list is easy to sort and organize without having to delete any unwanted information.

6. Drop-down lists can be used for so many different reasons, some of which include creating test questions, keeping track of memberships, or even organizing recipes!


I hope the above article solves your problem of how to add drop down list in google sheets. If you have any questions about how to add drop down list in google sheets, or anything else that I may have missed please feel free to leave a comment.

Leave a Reply