Articles → EXCEL → Change cell into drop down list in excel 2007

Change cell into drop down list in excel 2007
















Software requirement





Prerequisite knowledge





Create sample data





Click to Enlarge


















Create drop down list





Click to Enlarge






Click to Enlarge






Click to Enlarge




Click to Enlarge




Click to Enlarge




Click to Enlarge




Output





Click to Enlarge




Click to Enlarge


Posted By  -  Karan Gupta
 
Posted On  -  Friday, June 27, 2014

Query/Feedback


Your Email Id  
 
Subject 
 
Query/FeedbackCharacters remaining 250