Create and Delete Dropdown Lists in Google Sheets using Data Validation

September 08, 2021
Create and Delete Dropdown Lists in Google Sheets using Data Validation
Table of Contents
Table of Contents

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 one 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 an 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 let’s 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 dropdowns 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 dropdowns in Google Sheets using Data validation. You can send your feedback to  aryanirani123@gmail.com.



Great! Next, complete checkout for full access to The Yet Another Mail Merge Blog
Welcome back! You've successfully signed in
You've successfully subscribed to The Yet Another Mail Merge Blog
Success! Your account is fully activated, you now have access to all content
Success! Your billing info has been updated
Your billing was not updated