ERP Technical | Advance Excel, VBA, Power BI Developer

Create & Remove Drop Down List in Excel


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

Labels:
Reactions:

Post a Comment

[blogger][disqus][facebook]

MKRdezign

{facebook#https://www.facebook.com/proy20152016}

Contact Form

Name

Email *

Message *

Powered by Blogger.
Javascript DisablePlease Enable Javascript To See All Widget