Excel Drop Down List Question

Factual Questions
1

I have this simple problem that for the life of me I cannot recall how toaccomplish.

On the main page I have some cells that need to have their data come from a short list of potential entries. For example, there is a list of 50 names and the cells that need the data must contain one of those names. I seem to recall that if i had the list of names in a range in one place in the workbook, then I could make it so the input cells created a drop down selection of the range of names from that list. But how do I do this?

2

Select the cell, click the Date menu, then the Validation option. Select List from the ‘Allow’ drop-down list in the pop-up tab, then enter the cell range of your list in the ‘Source’ input box.

3

Thanks! You rock, Crusoe!