How to create a drop down list using data validation?

1. Data Validation option is used in creating drop down lists

For example: Various Departments in office, Different Courses in a college etc

(Data validation is the process of ensuring that a program operates on clean, correct and useful data.)

2. Data Validation lists the data from a source on the same worksheet or another worksheet in the same

workbook. The source is basically a column  of cells containing data.

3. The steps are as follows

a) Highlight the locations where you want the list to appear in the worksheet. (in example> COURSE LIST)

b) Enter the required data in another worksheet (in example> REFERENCE)

c) In this method the different lists are identified by the different names provided to their ranges. 

    Select cells from A2 to A4 in REFERENCE worksheet by dragging the mouse with the left 

     button clicked.  

    Then click on the name box and enter the word COURSE in it and press enter. Follow the  

    same step for COMBINATION.

d) Now go back to the COURSE LIST sheet and select cell B2. Select Data validation command under the data tab. 

e) In the data validation dialog box under allow choose list.

f) In the Source box enter = sign and then the name COURSE and press enter.

g) A list will be created in Cell B2 for the courses offered in college. Follow the same steps to create a list for COMBINATION.