Do you want to know how to add or remove dropdowns in Excel worksheet using Data Validation? In this post, you will learn how to add or delete a dropdown list from Excel in a few simple steps. It is simple to add or remove a drop-down list from an Excel spreadsheet using Data validation.
Excel data validation is a useful function that lets users control the data entered into a cell. Users can use data validation to restrict what data can be entered into a cell, such as a range of values, a list of permitted values, or data received from another worksheet or range.
Add a drop-down in Excel using Data Validation
Suppose you have sales data and have to restrict the country in column B. Your team decided to add a dropdown on column B, then the end-user only selects anyone from the list.
In this example, the country names are in the range G2:G5.
- Select the cell B2
- Go to the Data tab and then select Data Validation
- In the Data Validation window, select List from the Allow dropdown.
- Click the Source box and select the range of cells that contain the items you want to appear in the dropdown.
- Click OK.
You can see the dropdown is added in cell B2. Drag to add the same dropdown to all other cells in the range B2:B16. Now user can select only the country listed in the dropdown.
Remove a drop-down in Excel
Please follow the below steps to remove the dropdown in Excel
Select cell B2, Go to the Data tab and then select Data Validation.
Press the Clear All button and OK.
Conclusions
Data validation in Excel is a powerful feature that can help you control what data is entered into your worksheets. It can help to ensure accuracy and consistency, prevent incorrect data from being entered and make data entry more efficient.
If you have any questions, please leave a comment below and I will get back to you as soon as possible.
