In this blog, I am going to show you how to create a drop-down list in Google Sheets as well as how to remove one.
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.
Step 2: Creating a Drop Down List in Google Sheets with 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 list in Google Sheets follow these steps:
- 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 in Your Google Sheet
On clicking the Save button, you will see a dropdown in the cell that we had specified.
If you click on the down arrow, you can see all the contents have successfully come into the dropdown menu of Google Sheets.
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.
Step 4: How to Remove Data Validation and Get Rid of 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:
- Select the cell where the dropdown is added
2. Open Data and select Data Validation.
3. Click on Remove Validation.
4. Upon removing the data validation, the dropdown will get removed from the selected cell.
Here you can see that the Dropdown has been removed from the cell.
Summary: How to Create a Drop Down Menu in Google Sheets
In this blog, we saw how to add a 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 dropdowns in Google Sheets using Data validation. You can send your feedback to firstname.lastname@example.org.