For example, if I had a column "Favorite Fruit" but wanted to limit the value
to apple, orange, banana, pear, mango - is that possible?
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?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks