Microsoft Excel is a tool that can be used for various purposes, including data analysis, budgeting, and financial planning. One of the features that make Excel so useful is the ability to create drop-down lists. Drop-down lists are a great way to provide users with a set of predefined options, making it easier to input data accurately and consistently. In this article, we will show you how to add a drop-down list in Microsoft Excel.
Data entry is quick and more accurate when you use a drop-down list to limit the entries people can make in a cell. When someone selects a cell, the drop-down list’s down arrow appears, and they can click it and make a selection.
How to add a Drop-Down List in Excel
Follow the below steps to create a drop-down list in Microsoft Excel:
STEP 1: Suppose I want to create a drop-down list for Apple products. Now, select the cell where you want to create a drop-down list. See the below image:
STEP 2: Now, on the ribbon, go to Data and select Data Validation.
STEP 3: A prompt box will appear. Here, select the "List" from the "Allow".
After that, in the source, enter the names of the product which you want in a drop-down list. Enter the names with commas between them.
For example, for Apple, I have entered "iPhone, Macbook, Ipad".
STEP 4: Click OK.
STEP 5: Click on the cell and select the product from a drop-down list.
How to Delete a Drop-Down List in Excel
To delete a drop-down list, follow the above steps from SETP 1 to STEP 3. When a prompt box will appear, click on "Clear all". Then, click OK.
If you need to remove all Data Validation from a worksheet, including drop-down lists, then you can use the "Go To Special".
STEP 1: Press Ctrl+G => Special.
STEP 2: Data Validation => All or Same, and repeat the steps above.
Conclusion
Drop-down lists are a great way to make data entry easier and more accurate. They can be used for a wide range of applications, from product types to budget categories. With this tutorial, you should be able to create drop-down lists in Excel with ease.