Select the cell then Data>Validation>Settings
What is in the "Source" dialog?
That will be the list...............either a range of cells like =A1:A10
Or a named range like =TheList
Or comma-separated values like dog,cat,elephant,mouse
Which ever the case you would add to the list.
Gord Dibben MS Excel MVP
On Thu, 24 Jul 2008 11:50:03 -0700, Doug B <Doug