Is there a way to limit the content of a cell to 5 choices?

C

ChrissyG

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

aidan.heritage

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formating bolded text exclusively. 0
vlookup 3 sheets 1
Create a text based count with criteria from two differnt workbook 4
Define a Range based on Cell Values 2
Unable to identify appropriate formula for very simple scenario 2
Categorizing Data Question 4
Sorting data with a formula 4
Search cell value in same column 3

Top