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




Picture showing the sample excel file with the list of students

Click to Enlarge


















Create drop down list




Picture showing the list of classes to be added in the dropdown

Click to Enlarge





Picture showing the Data Validation button for adding the dropdown

Click to Enlarge





Picture showing the data validation popup for selecting the validation criteria

Click to Enlarge



Picture showing the button for selecting the source of data for the dropdown

Click to Enlarge



Picture showing selecting the range from the excel file

Click to Enlarge



Picture showing the data source selected in the data validation window

Click to Enlarge




Output




Picture showing the dropdown in the first cell

Click to Enlarge



Picture showing dragging the first cell to implement dropdown in other cells

Click to Enlarge


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

Query/Feedback


Your Email Id  
 
Subject 
 
Query/FeedbackCharacters remaining 250