Add/Insert Dropdown list in Google Sheets

  • Reading time:3 mins read
  • Post category:Utility
  • Post comments:0 Comments

Dropdown lists is a superbly useful tools to provide users with ease of input access. It helps control errors in data entry and helps in standardization of information.

Apart from basic data entry you can also use dropdown lists for creating smart data extraction features, interactive todo lists, dynamic charts etc

We shall talk more about applications of Dropdown lists in this tutorial after covering the basics. So, lets begin.

Sample Google Sheet File

In this tutorial we will be using the below Google Sheet Document to work. Feel Free to create a Copy of the same in your Google Account.

Create Dropdown list in Google Sheet

Create a Dropdown list using Cell Range

Follow the below steps to create a basic dropdown list in Google Sheet.

  1. Select the Cell where you want to create a dropdown list
  2. Goto Data->Data Validation
  3. Select “List from a Range” in Criteria
  4. Enter a Range
  5. Click Save

Below is an illustration of above steps in details

Step 1: Create a Sample Google Sheet File with a list of unique values to start with.

Sample Google Sheet File

Step 2: Select a cell where you want to create a dropdown list. For us it will be E3.

Step 3: Under Menubar goto Data -> Data Validation

Data Validation Option in Google Sheet

Step 4: In the data validation dialog box we need to make multiple changes.

a. Check if cell range is same as the cell you want to create the dropdown list on. If not, update accordingly.

b. In criteria select “List from a Range” and then go on to select the range.

c. Now Select the check mark “Show drop-down list in a cell” . This will ensure you get a dropdown type feature with list of possible options.

Select “Reject Input” for On invalid data. This will prevent the user from entering anything outside the realm of possible values.

d. Once Done, now you can easily use the drop-down feature in cell E3. simply click on the down arrow appearing on the right corner of the cell and select the suitable option.

You can also double click on the cell and start typing the input. You will be prompted with different valid options as per what you typed.

If you end up typing something incorrect then you should expect an error since we had selected “Reject Input” for Invalid Entry.

Create a Dropdown List using “List of Items”

This is another easier approach to creating a Dropdown list without using the Cell Ranges. It’s called “List of Items” method.

To apply this method:-

  1. Select a Cell
  2. Goto Data-> Data Validation
  3. In Criteria option, select “List of items”
  4. Manually enter all the options separated by comma’s
  5. Select appropriate choices for the other settings and press ‘Save’

Advantage of using this method is that you do no need to create a separate cell range.

Closing Remarks

Mastering dropdown list is a very useful skill that every user to aspire to have. There are multiple connected topics like creating a dependent dropdown list, adding color to dropdown list which you can also read about.

That’s it on this topic. If you face any issues in implementing the above methods then leave a comment down below. Keep browsing SheetsInfo for more such useful information 🙂

How useful was this post?

Click on a star to rate it!

Average rating 0 / 5. Vote count: 0

No votes so far! Be the first to rate this post.

Liked the content?? Then share the word!!!

Rishav

I love Google Sheets and heavily rely upon it on a day to day basis. SheetsInfo is my attempt to share my learning with all of you. Hope you find the articles easy to read and simple to understand.

Leave a Reply