How to create drop down list in Microsoft Excel ?

Published on April 4, 2013 by abundantcode

Filed under Excel

Last modified April 4, 2013

Print this page

rate 1 star rate 2 star rate 3 star rate 4 star rate 5 star
Your rating: none, Average: 0 (0 votes)

This article have been viewed 4484 times

This article will explain how to create drop down list in Microsoft Excel 2007 .

Drop down list is one of the most commonly used ways in excel to allow users to select the items from the predefined list . The drop down list in Excel allows the users to select only the valid entries.

How to create drop down list in Microsoft Excel ?

Follow the below steps to create drop down list in Microsoft Excel

1. Enter the following values in the Column A of the worksheet.

Abundant Code

Programming tutorials

Excel combobox

Excel Dropdownlist

Excel tips and tricks

How to create drop down list in Microsoft Excel ?

2. Use a different worksheet . Select the cell where you want the drop down list to appear. For example , I select “C1”.

3. In the Data Menu , click “Data Validation” Dropdownlist and then click “Data Validation”.

How to create drop down list in Microsoft Excel ?

4. Specify the source of the data for the dropdown list item in the Data Validation Dialog. In the Validation Criteria , select Allow “List” and specify the range of values in the source and click OK.

How to create drop down list in Microsoft Excel ?

5. You should now see the Dropdownlist in the selected cell “C1” .

How to create drop down list in Microsoft Excel ?

0saves
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 Comment

  1. How to create drop down list in Microsoft Excel ? | TechBlog
    April 7, 2013 - 2:28 pm

Leave a Comment


x

You might be Interested in these Posts

How to make a Type Sortable in C# using IComparable interface?

Assume that you have a type which would be stored in a List. You would want to use List.Sort method ...

How to Add item to the beginning of List in C# ?

If you want to add or insert an item to the beginning of the List in C# , you can use the Insert met...

How to Get the Top 5 elements from a List in C# ?

If you want to get the top 5 elements from a list in C# or skip the first item and get the next five...