Limiting Input in Cells to those in List

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

L.A. Lawyer - 29 Oct 2004 23:24 GMT

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

Reply to this Message

Debra Dalgleish - 30 Oct 2004 00:05 GMT

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

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

> 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

Signature

Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Reply to this Message

JE McGimpsey - 30 Oct 2004 00:09 GMT

Check out Data/Validation in XL Help.

See

http://contextures.com/xlDataVal01.html

for more.

Reply to this Message