How to Create a Simple Drop Down list in Microsoft Excel 2013?

Creating or adding a dropdownlist in Microsoft Excel is something that most people do when using using Excel specially when creating an data entry sheet.

A drop down list enables the user to select the value from the predefined list instead of user typing them.

How to Create a Simple Drop Down list in Microsoft Excel 2013?

Creating a Drop Down list in Microsoft Excel is very simple and you can do that by following the below steps

When a drop down list is created, the user can enter the data by selecting it. In this blog post, I will show you how you can create a Simple Drop Down list in Microsoft Excel 2013 where the list of data to be populated comes from the same worksheet.

1. Open Microsoft Excel 2013 CP and create a new Excel Workbook.

2. To prepare the list of data to be populated in the Drop Down list, lets add the below data to the corresponding cells

A1 – Senthil Kumar

A2 – Senthil

A3 – Kumar

A4 – isenthil

A5 – Senthil Kumar B

3. Select the Cell where you want the drop down list to appear.

4. Navigate to the Data Tab -> Data Validation Menu and click “Data Validation” option from the dropdown.

5. In the Data Validation Dialog -> Settings Tab, select “List” from the Allow option and then enter the following data in the source textbox and click OK.


6. Now, you should see the drop down list on the selected cell.

If you enjoyed this post, please consider leaving a comment or subscribing to the RSS feed to have future articles delivered to your feed reader.


  1. Nora March 19, 2014 Reply
  2. Nora March 19, 2014 Reply

Leave a Reply


Interesting BlogPosts to read

Event on Building intelligent bots with the Microsoft Bot Framework in Manchester
Want to learn about building intelligent bots using Microsoft's Bot Framework. Here's an interesting...
How to find the Created and Last Modified time in Microsoft Excel ?
You can easily find out the exact date and time when the excel workbook was created and modified usi...
How to copy multiple sheets in Excel?
There are scenarios where you might want to make a copy of multiple worksheets in a workbook in Micr...