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

Change cell into drop down list in excel 2007





  1. Software requirement
  2. Prerequisite knowledge
  3. Create sample data
  4. Create drop down list
  5. Output

Software requirement





Prerequisite knowledge





Create sample data




Picture showing the sample excel file with the list of students

Click to Enlarge



  1. Enter the class name by typing text.
  2. Select the class name from drop down.


  1. You have to remember class name
  2. Data entered by you may contain spelling mistakes
  3. You may enter data in different cases (like some classes in uppercase and some in lowercase) which doesn’t look professional.



Create drop down list


  1. First of all add all the classes in a column which you want in the drop down list
  2. Picture showing the list of classes to be added in the dropdown

    Click to Enlarge

  3. Select the first cell where you want a drop down. In this case we will select a cell next to ‘Ramesh’.
  4. Click on ‘Data Validation’ button in ‘Data’ ribbon group.
  5. Picture showing the Data Validation button for adding the dropdown

    Click to Enlarge

  6. Once you click on the button, a drop down appears as shown in figure above. Click on ‘Data Validation…’
  7. Once you click on that a pop up appears as shown in figure below. From the ‘Allow:’ drop down select ‘List’
  8. Picture showing the data validation popup for selecting the validation criteria

    Click to Enlarge

  9. From the ‘Source:’ field click on button on the right hand side of textbox to select range of values.
  10. Picture showing the button for selecting the source of data for the dropdown

    Click to Enlarge

  11. Select the range of values and click on the button as shown in figure below
  12. Picture showing selecting the range from the excel file

    Click to Enlarge

  13. Once you click on the button you could see selected range. See the figure below
  14. Picture showing the data source selected in the data validation window

    Click to Enlarge

  15. Click on Ok.

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