How to add dropdown list in Excel

In this excel tutorial, we are going to see how to add dropdown list in Excel 2016 and 2013. Excel users can add drop down using the option available as part of Data Validation settings.

Add dropdown in Excel 2013

Adding dropdown in Microsoft Excel

Step 1: Click Data in Office Ribbon and navigate to Data Tools section.

image

Step 2: Click the arrow pointing downwards below Data Validation and select Data Validation from the dropdown list.

image

Step 3: Click the Settings tab under Data Validation window and select List for the Allow dropdown list.

image

Step 4: Now enter the Data that needs to be displayed in the Source column i.e 2013, 2012, 2010, 2009, 2008,2007,2006. You can also provide a cell range with the defined set of values.

Data Validation in Excel 2016 and Excel 2013

After entering the required data, click OK button to confirm and save the changes. Now selecting the cell and then clicking dropdown arrow should display the dropdown list.

image 

Also See:

How to display input message for cell in Excel 2010

In Category: Excel 2013, Excel 2016, MS Office

Ravi Shankar

A Software developer and blogger who is always looking to provide technical help to the wider community.

Show 0 Comments
No comments yet. Be the first.

Leave a Comment

Get your free copies of the following tech guides by joining the Digital Answers mailing list.