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.

step 1

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

step 2

Become The Highest-Paid Business Analysis Expert

With Business Analyst Master's ProgramExplore Now
Become The Highest-Paid Business Analysis Expert

  • 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

Your Data Analytics Career is Around The Corner!

Data Analyst Master’s ProgramExplore Program
Your Data Analytics Career is Around The Corner!

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!


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

Data Science & Business Analytics Courses Duration and Fees

Data Science & Business Analytics programs typically range from a few weeks to several months, with fees varying based on program and institution.

Program NameDurationFees
Post Graduate Program in Data Analytics

Cohort Starts: 17 Jun, 2024

8 Months$ 3,500
Applied AI & Data Science

Cohort Starts: 18 Jun, 2024

3 Months$ 2,624
Post Graduate Program in Data Science

Cohort Starts: 19 Jun, 2024

11 Months$ 3,800
Data Analytics Bootcamp

Cohort Starts: 24 Jun, 2024

6 Months$ 8,500
Post Graduate Program in Data Engineering

Cohort Starts: 27 Jun, 2024

8 Months$ 3,850
Caltech Post Graduate Program in Data Science

Cohort Starts: 8 Jul, 2024

11 Months$ 4,500
Data Scientist11 Months$ 1,449
Data Analyst11 Months$ 1,449