Creating A Drop Down Box in Excel

Just in case your screen looks slightly different, I have Excel 2011 for Mac.
I used information on Excel 2003 to remember how to do this though, so hopefully between the two you can find the right way to do it.

1. Create a new worksheet page. Type your list into the cell boxes. Select all the cell boxes that you want in your list and then name the list.

2. Go back to your first worksheet page (Sheet 1). Select the cell where you want your drop down box to appear.
3. Under Data, choose Validate.
4. Select Data Validation

5. Under Settings, choose the information to appear as List.

6. In the box labeled Source, type an = sign and then the name of your list. (Example: =Title)

7. Click Ok. Your cell should now have an arrow and when you click the arrow the drop down box with your list will appear.

For the 2003 information, go here.