See Debra Dalgleish's website for instructions on Data Validation:
http://www.contextures.com/xlDataVal01.html
Does that help?
***********
Regards,
Ron
XL2002, WinXP
"ChrissyG" wrote:
For example, if I had a column "Favorite Fruit" but wanted to limit the value
to apple, orange, banana, pear, mango - is that possible?