A drop-down list in excel is a feature that allows users to choose from a list of options. It is a handy feature that allows users to enter the data faster and accurately. It's an excellent way to give the user the pre-defined list.
Create A Drop-Down List
To create a drop-down list in Excel, follow these steps:
- Select the cell which you want the drop-down list to appear in.
- From the Data tab of the ribbon and select Data Validation.
- Change what’s allowed from ‘Any Value’ to ‘List’
- In the ‘Source’ box that appears,
- Type the list of items separated by a comma.
Your drop-down list is ready.
- Select the source box, then use your mouse to select the cells containing values that you’d like to use for the drop-down list.
The drop-down list is now created.
Allow Other Entries
You can create a drop-down list that allows you to enter other entries apart from the options given. To do that, follow these steps:
- Go to the data validation function arguments.
- On the Error Alert tab, uncheck 'Show error alert after invalid data is entered'.
- Click OK
Add Items to the List
You can also add the additional elements to your drop-down list without opening the data validation argument window. To add the elements, follow these steps:
- To add an item to a drop-down list, go to the items, and select an item.
- Right-click and select Insert.
- Select "Shift cells down" and click OK.
- Type a new item and click Enter. It adds the new item to the list.
Input Message Tab
You can set the input message to explain what data it allows in a given cell. This tab is optional.
- Check 'Show input message when the cell is selected'.
- Enter a title.
- Enter an Input message.
Gain expertise in the latest Business analytics tools and techniques with the Business Analyst Master's Program. Enroll now!
A drop-down list in Excel is an excellent way to limit the options for user entry. It ensures it enters the right data into a cell. We discussed ways in which we can create a drop-down list.
Boost your analytics career with powerful new Microsoft Excel skills by taking the Business Analytics with Excel course, which includes Power BI training
This Business Analytics certification course teaches you the basic concepts of data analysis and statistics to help data-driven decision making. This training introduces you to Power BI and delves into the statistical concepts that will help you devise insights from available data in order to present your findings using executive-level dashboards.
If you have any questions, please feel free to ask them in our comments section, and our experts will promptly answer them for you.