How do I add drop down choices to a spreadsheet?

[Guest]

I have figured out how to get drop downs in my spreadsheet but I can not
figure out how to be able to re-use the same one in different boxes over
again. When I put in a selection from a drop down, it takes it away from
being one of the choices on my list for the next one. I hope someone can
help! I am very frustrated!

 

[Bob Phillips]

See http://www.contextures.com/xlDataVal03.html

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[Guest]

I want to be able to reuse the entries over and over. It is a spreadsheet of
codes and the codes may need to be entered more than once.

Wendy

 

[Debra Dalgleish]

You can use a named range as the source, as described here:

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

Then, the list items won't disappear as you move down the worksheet.

Or, if you select a range on the worksheet, use absolute references, so
the range won't adjust as you move down. For example,

instead of:
=A1:A10
use
=$A$1:$A$10

 

[Bob Phillips]

Oh, I thought it was the other way.

Just use absolute references in you range, such as $A$1 not A1.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[Guest]

I have that - this is how I have the range
=$A$1:$E$25
It still doesn't work. I have been working on this for a while and can not
get it to work.

 

[Bob Phillips]

Surely you get an error with that, a list must be one row or one column, not
multi in both dimensions.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[Carol Montalbano]

Is this possible in MS Excel 2007? I'm talking about a similar function as

 

[Gord Dibben]

Since you have tacked onto an existing thread it is hard to tell what your
needs are.

Do you want simple Data Validation dropdown list of choices?

http://www.contextures.on.ca/xlDataVal01.html


Gord Dibben MS Excel MVP

On Mon, 21 Dec 2009 17:50:01 -0800, Carol Montalbano <Carol