Take a look at Debra Dalgleish's site:
http://contextures.com/xlDataVal01.html
for info about data|validation.

colt wrote:

I have seen spreadsheets that have a dropdown box option available when
you go into a cell i am struggling to find how to crete these and then
how to add options

Thanks to who will enlighten me

--
colt

--

Dave Peterson