Perfect!

If I only had a dollar for every time I went to data validation thinking it
had to be that, but not seeing how to make it happen....

Thanks,

Brad

"Jim Thomlinson" wrote:

In Excel from the main menu select Data- Validation -List...

You can enter values separated by comas or you can select a group of cells.
--
HTH...

Jim Thomlinson


"Brad" wrote:

Thanks for taking the time to read my question.

I wasn't sure which thread to post in. I hope I have chosen the correct one.

I have seen drop down lists on some spreadsheets that were in the cell, not
a regular drop down list. This list shows up when you click on the cell, but
when you move away from the cell, the arrow dissappears and the chosen value
remains. You create a list somewhere else that is the list of values in the
drop down list.

I hope this makes sense.

Brad