Drop-Down List In Excel: The Best Guide For Beginners

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. 

In this article, we will discuss the following topics: 

  • Create a drop-down list
  • Allow other entries
  • Add Items to the list
  • Input message tab

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.

step 1

  • Change what’s allowed from ‘Any Value’ to ‘List’

step 2

Business Analyst Master's Program

Gain expertise in Business analytics toolsExplore Program
Business Analyst Master's Program

  • In the ‘Source’ box that appears,
  • Type the list of items separated by a comma.

step 5

Your drop-down list is ready.

step 6

  • 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.

step 3

The drop-down list is now created.

step 4

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'.

uncheck dropdown

  • Click OK

allow output

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.

insert dropdown

  • Select "Shift cells down" and click OK.
  • Type a new item and click Enter. It adds the new item to the list.

insert output

FREE Course: Introduction to Data Analytics

Mastery to Data Analytics Basics is a Click Away!Start Learning
FREE Course: Introduction to Data Analytics

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.

step 3

Gain expertise in the latest Business analytics tools and techniques with the Business Analyst Master's Program. Enroll now!

Conclusion

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. 

About the Author

Aryan GuptaAryan Gupta

Aryan is a tech enthusiast who likes to stay updated about trending technologies of today. He is passionate about all things technology, a keen researcher, and writes to inspire. Aside from technology, he is an active football player and a keen enthusiast of the game.

View More
  • Disclaimer
  • PMP, PMI, PMBOK, CAPM, PgMP, PfMP, ACP, PBA, RMP, SP, and OPM3 are registered marks of the Project Management Institute, Inc.