Drop Down List in Excel

http://www.contextures.com/xlDataVal01.html
Select from a drop down list on the Excel worksheet. Details at http://www.contextures.com/xlDataVal01.html

Category:

Science & Technology

Tags:

• Excel
• Contextures
• Data
• Validation
• Dropdown
• List

[choateusaf]

Is there anyway to add or subtract things off the list after the list has already been created?

[andycrofts]

SO SIMPLE EVEN A BRICKLAYER CAN UNDERSTAND

[GR8GUY54]

Thanks! Simple and to the point:}

[ucheucheuche]

Concise. Clear. Cwick.

This tutorial is as good as Lynda.com ones.

Thanks.

[velcrots]

hey guys, here's a tough one...i'm making a daily nutritional intake chart. say column 1 says "oatmeal", column 2 has the # of calories, 3 has # of carbs, 4 has # of fat...etc. how can i make the word "oatmeal", say in dropdown list on another worksheet, represent all of those columns of data? and once selected, that data shows up in seperated columns in a results table, to sum with other data from other dropdowns? have i described it so it makes sense? is it even possible? thanks so much!

[pcharl01]

can you create a sublist of a list?

[CapitanoGUC]

but how can i give each selectet iton a certain value or price that it will give, together with the number of itoms the right price ????

[kaftxx]

thank you!

[Doubleauseven]

Exactly what I was looking for. You've just saved me hours!!! Thank you

[Winnelisjoh]

Great tutorial!! A big thumbs up for the fact that this video is also available as a step-by-step guide on your website.

You saved me time!

I would have liked it if you would have shown how to use the other functionalities of this feature as well though. But still Fantatastic and Helpfull!