Monday, February 18, 2008

Excel Drop Down List

When inputting data into Excel, often you will find yourself have to type the same data into cells. And now, in Excel, you can create a drop down list for the cell, instead of typing the same data over and over again. A drop down list in Excel makes data entry easier, avoids typo error in a cell, and limit entries to certain items.

Next, I will show you how to create a drop down list step by step.

Imagine that we want to create a drop down list which contains a list of sections as below:

Now we have the source for the drop down list.

Highlight cells E2 to E10 to create a drop down list for each cell within this range.

Click the Data | Validation. A Data Validation dialog box will pop out.

Go to Settings tab. Choose List from the Allow drop down menu. Click on the icon from the Source field.

Highlight the sources from cell A1 to A18. Press Enter and click OK.

Now all of the selected cells in the Section column should have a drop down list, as below:

That’s it. Cheers!


Anonymous said...

Have you tried parsing an excel file with a drop down list like show using C#.NET?

ejuly on March 27, 2008 at 2:24 PM said...

Plese refer to the post - Add a Drop Down List into Excel file using C# .NET

Does this help you?

Anonymous said...

I found this site using [url=][/url] And i want to thank you for your work. You have done really very good site. Great work, great site! Thank you!

Sorry for offtopic


Get paid for your opinions! Click on the banner above to join Planet Pulse. Its totally free to sign up, and you can earn UNLIMITED. Find out more by visiting PLANET PULSE.
July Code Blog Copyright © 2010 Blogger Template Designed by Bie Blogger Template