Limiting Input in Cells to those in List

[L.A. Lawyer]

I want to limit input in each cell in a column to a group of options, eg,
"Mary, John, Bob". I'd like to have this list drop down, like a combo box,
but since this will be for many cells, I like to do this as a formula

 

[Debra Dalgleish]

You can use Data Validation to create the list. There are instructions
in Excel's Help, and here:

http://www.contextures.com/xlDataVal01.html

 

[JE McGimpsey]

Check out Data/Validation in XL Help.


See

http://contextures.com/xlDataVal01.html

for more.