How to Create dropdown in Google Sheets(Easy Guide)

In this tutorial, you will learn How to Create dropdown in Google Sheets

Create a drop-down list

  1. Open an existing or new spreadsheet using Google Sheets
  2. Choose the cells for which you want to create a drop-down list.
  3. Click on the Data menu and Select data validation (Data-> Data validation.)
  4. Choose “List of items” under the Criteria section
  5. After entering the items, Click on Save
  6. A drop-down list will be visible

How to Create dropdown in Google Sheets: Step-by-Step Guide

Here are the steps to Create dropdown in Google Sheets :

Step 1: Open Google Sheets and prepare your data

Open an existing or new spreadsheet and prepare the data for which you want to create a drop-down list.

In this example, we will use the below dataset.

Step 2: Choose the cells for which you want to create a drop-down list.

Here we have selected the cells B2 to B8 for which we will create a drop-down list.

Step 3: Click on the Data menu and Select data validation

(Data-> Data validation.)

Step 4: Choose “List of items” under the Criteria section

On the data validation screen under the Criteria section, Select “List of items from the drop-down options.

Step 5: Specify the list of items

Now specify the list of items in the text area where it says “Enter items separated by a comma

Step 6: Ater entering the items, Click on Save

Step 7: Drop-down list will be visible.

You required a drop-down list will be created. Click on the down arrow in the cell to get the list of options to select.

How to Create dropdown in Google Sheets

How to Create dropdown in Google Sheets(Conclusion)

In the above, we have walked you through a step-by-step guide to create a drop-down list in Google Sheets.

We hope this tutorial on How to Create dropdown in Google Sheets was helpful.

Related articles :

How to Insert Spin Button in Google Sheets ( Easy Guide )

How to Freeze Rows in Google Sheets

How to Calculate Square Root and Cube Root in Google Sheets(Quick & Easy Guide)

How to use SUMSQ Function in Google Sheets(Quick & Easy Guide )