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.

=$A$1:$A$5

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.

2 Comments on this article. Feel free to join this conversation.

  1. Nora March 19, 2014 at 11:12 pm - Reply

    Great turtorial however there is one main thing missing. You must type a (‘) apostrophe before the equal sign or excel doesn’t know you’re trying to input a formula

  2. Nora March 19, 2014 at 11:12 pm - Reply

    Great tutorial however there is one main thing missing. You must type a (‘) apostrophe before the equal sign or excel doesn’t know you’re trying to input a formula

Leave A Response