How do I add drop down choices to a spreadsheet?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Wendy - 19 Jun 2006 20:17 GMT

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!

Reply to this Message

Bob Phillips - 19 Jun 2006 20:58 GMT

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

Signature

HTH

Bob Phillips

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

> 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!

Reply to this Message

Wendy - 19 Jun 2006 21:16 GMT

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

> See http://www.contextures.com/xlDataVal03.html
>
[quoted text clipped - 3 lines]
> > being one of the choices on my list for the next one. I hope someone can
> > help! I am very frustrated!

Reply to this Message

Debra Dalgleish - 19 Jun 2006 23:49 GMT

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

> 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.
[quoted text clipped - 8 lines]
>>>being one of the choices on my list for the next one. I hope someone can
>>>help! I am very frustrated!

Signature

Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

Reply to this Message

Bob Phillips - 20 Jun 2006 00:00 GMT

Oh, I thought it was the other way.

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

Signature

HTH

Bob Phillips

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

> 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.
[quoted text clipped - 8 lines]
> > > being one of the choices on my list for the next one. I hope someone can
> > > help! I am very frustrated!

Reply to this Message

Wendy - 20 Jun 2006 16:50 GMT

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.

> Oh, I thought it was the other way.
>
[quoted text clipped - 17 lines]
> can
> > > > help! I am very frustrated!

Reply to this Message

Bob Phillips - 20 Jun 2006 23:53 GMT

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

Signature

HTH

Bob Phillips

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

> I have that - this is how I have the range
> =$A$1:$E$25
[quoted text clipped - 22 lines]
> > can
> > > > > help! I am very frustrated!

Reply to this Message