Create and Delete Dropdown Lists in Google Sheets using Data Validation

Welcome!

In this blog, I am going to show you how to create and delete drop-down lists in Google Sheets.

Step 1: Sample Google Sheet

The Google Sheet that I will be using has some colours store in on column and using that data I want to create a dropdown in the adjacent cell.

Step2: Data Validation

To add a dropdown to the selected cell we are going to use a feature known as Data Validation. Data Validation in Google Sheets allows you to set certain parameters around numbers, dates, and text that prevent you from making input errors.

To add the drop-down to the cell follow these steps:

  1. Select target cell where the drop-down has to be

2. Click on Data and select Data Validation.

3. On clicking Data Validation, it will bring up a box where you need to add some further details.

Here you need to specify the cell range where you want to add the dropdown. Next, you need to specify the criteria for Data Validation. Since we already have a range from which we need to create the dropdown, we are going to specify the range in the box. After filling in all the details, the box should look like this.

After filling in the details click on Save.

Step 3: Check the Dropdown

On clicking the Save button, you will see a dropdown in the cell that we had specified.

If you click on the dropdown, you can see all the contents have successfully come into the dropdown.

Here you can select the value from the dropdown list provided. If the user puts in a value that is outside the given range,it will show and error.

Here I have put in a colour outside the given range, giving me an error saying the input must be present in the range.

Step4: Delete Dropdown Lists

Until now we have added the data validation, specified some criteria and created the dropdown list, now lets go ahead and delete the dropdown.To delete the dropdown follow these steps:

  1. Select the cell where the dropdown is added

2. Open Data and select Data Validation.

3. Click on Remove Validation.

4. On clicking Remove Validation, the dropdown will get removed from the selected cell.

Here you can see that the Dropdown has been removed from the cell.

Summary

In this blog we saw how to create and delete dropdown in Google Sheets using Data Validation.

If you prefer watching a video, we have got you covered.

I hope you have understood how to create and delete dropdown in Google Sheets using Data validation. You can send your feedback to aryanirani123@gmail.com.

Currently pursuing B Tech at MPSTME. Technical Blogger, interested in Google Workspace. Hope to remain a life long student.