To create a drop-down list in Excel

1. Start Excel and open a new, blank worksheet. 
2. In cell A1, type "Select", and then select cell B1. 
3. On the Data menu, click Validation, and then click the Settings tab. 
4. From the Allow list, click List. 
5. In the Source box, type the following values: Male,Female,

To create a drop-down list from values on the same worksheet

1. 
   
2. Type some menu starting at cell E4. 
3. Select the cell that contains the list you created earlier (cell B1, unless you chose otherwise), and then, on the Data menu, click Validation. 
4. Replace the list that you typed manually with the following value: =E4:E8 (Word,Excel,PowerPoint,Photoshop,Quickbook). 
5. Click OK, and then select a value from the list.