How to Create Drop Down Lists on Google Sheets

This updated guide explains how to Create Drop Down Lists on Google Sheets through clear steps, practical examples, and important checks that help prevent common errors.

Instructions for Creating Drop-lists in Google Sheets

Step 1:

In the table of data we localize the column we want to create a drop down list. Next we choose Data> Data Validation .

Create Drop Down Lists on Google Sheets — Instructions for Creating Drop-lists in Google Sheets screenshot 1

Step 2:

Display the new interface, in the Range you will see the selected data area to create a list of droplists. Next to the Criteria section you can choose List from a range or List of items.

If we select List from a range , we click the grid icon to select the selected values from other cells in the same sheet or another worksheet.

Create Drop Down Lists on Google Sheets — Instructions for Creating Drop-lists in Google Sheets screenshot 2

Now show the interface for us to select the range of values, you just need to localize in the data table and click OK .

Create Drop Down Lists on Google Sheets — Instructions for Creating Drop-lists in Google Sheets screenshot 3

Then you just need to click Save in the Data Validation table . The drop down list results are as follows.

Create Drop Down Lists on Google Sheets — Instructions for Creating Drop-lists in Google Sheets screenshot 4

Step 3:

If you entered the content manually , select List of items . You can enter text or numbers separated by commas.

Create Drop Down Lists on Google Sheets — Instructions for Creating Drop-lists in Google Sheets screenshot 5

At that time, you also have the drop down list as below.

Create Drop Down Lists on Google Sheets — Instructions for Creating Drop-lists in Google Sheets screenshot 6

FAQ

What is the easiest way to Create Drop Down Lists on Google Sheets?

Start with the requirements in this guide, then follow each step in order. Check the result after every major change so problems are easier to identify.