excel+training - Creating a drop down box

Hi Shani

Thank you for your question, and apologies for the delay in reply.

You can create a dropdown list by using Data Validation.

This is how:

1. Select the cells you wish to create the dropdown list in.
2. Go to Data - Validation.
3. Under Allow: select List
4. In the Source box, type each item you want in the dropdown list separated by a comma and a space.
e.g. North, South, East, West.

5. Click OK.

You should then be able to select one of the items from the list and it should then appear in the cell.

I hope this helps.
Amanda