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
