How to create drop down list in excel

Create Drop-down list in excel by following these simple steps;
Create a list of items you want to include in your drop-down,Go to location where you want the list to appear,select the cells,Go to data tab and then data validation,select list and then select range of your prepared list and finally click ok