Create Drop Down List in Excel Worksheet Cell

http://www.contextures.com/xlDataVal01.html In an Excel worksheet, you can create a drop down list in a cell, or group of cells.

Instead of typing, people can just select from that drop down list, to prevent typing mistakes and invalid entries.

The list can be stored on a different worksheet, as long as you give the list a name.

Watch this video to see how to name a list, and then create drop down lists in the worksheet cells, based on that list.

These instructions are for Excel 2007 and Excel 2010.

Category:

Science & Technology

Tags:

• Excel data validation
• Excel
• Excel drop down
• Excel drop down list
• data validation
• data validation list
• Excel data validation list
• Excel tips
• Contextures

[Mitrellik]

Well done, thanks!!

[MmeDesgranges]

Thank you!

[nektariostune]

nice and simple - thanks

[heliburg]

WOW. Had to sign in to say thank you! Massive help. Been here ages looking for a drop down. I just hope that I dont. :-)

[rdalben]

Thx a lot for your video !

[rdalben]

Hi, how do I edit this list name ou delete this list name?

[AbbaDabbaUTube]

Thank you so very much! Very helpful and easy to foolow. I saved this under my Excell tools folder for quick reference. :)

[DragoshSTANCU]

Just perfect!



[sakute21]

thank you very much, you realy saved me:DD

[sillysausagePSN]

Just what i needed.