Create and remove Drop Down Menu List in Excel 2003, 2007, 2010 by using Date Validation option under the Date Menu.

Create Drop Down List or Data Validation
First create a option list in the plain Excel Sheet

Select C2 cell, Select DATA menu & select VALIDATION option

Select SETTINGS, select LIST under ALLOW

click on SOURCE Tab & select OPTION RANGE previously created i.e. here cell A1 to A5,

Click on OK

Remove Drop Down List or Data Validation

select C2 cell, click on DATE Menu, click on VALIDATION OPTION
Validation Box open, then click on CLEAR ALL
Drop Down List or Data Validation is removed

Stay Connected With Free Updates

Subscribe via Email
You can leave a response, or trackback from your own site.

Pijush Roy, Founder & Author of "Share Your Knowledge", is a young freelance blogger, a reader, a painter, more