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

How to change orientation of the worksheets in Microsoft Excel ?
This blog post will show the steps that are needed to change the orientation of the current workshee...
How to hide page breaks in worksheets in Microsoft Excel ?
When the page breaks is used to adjust the print area in a worksheet in excel , this would show up a...
How to protect all worksheets at once in Excel using VBA ?
Assume that you have a worksheet and you wish to protect all of the worksheets with a password at on...