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

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

Click to Enlarge


2. Select the first cell where you want a drop down. In this case we will select a cell next to ‘Ramesh’.
3. Click on ‘Data Validation’ button in ‘Data’ ribbon group.

Click to Enlarge


4. Once you click on the button, a drop down appears as shown in figure above. Click on ‘Data Validation…’
5. Once you click on that a pop up appears as shown in figure below. From the ‘Allow:’ drop down select ‘List’

Click to Enlarge


6. From the ‘Source:’ field click on button on the right hand side of textbox to select range of values.

Click to Enlarge


7. Select the range of values and click on the button as shown in figure below

Click to Enlarge


8. Once you click on the button you could see selected range. See the figure below

Click to Enlarge


9. Click on Ok.

Output