For example, if I had a column "Favorite Fruit" but wanted to limit the value
to apple, orange, banana, pear, mango - is that possible?

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?

YES! This is perfect, thanks so much.

"Ron Coderre" wrote:

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?

Yup, use the data menu, then validation - set it to list and either
type the list or reference it - the reference must be on the same
worksheet UNLESS it's a named range which can be anywhere!
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?