How do I add drop down choices to a spreadsheet?
 

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!

How do I add drop down choices to a spreadsheet?
 

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

--
HTH

Bob Phillips

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

"Wendy" <Wendy @discussions.microsoft.com wrote in message
...
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!

How do I add drop down choices to a spreadsheet?
 

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


"Bob Phillips" wrote:

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

--
HTH

Bob Phillips

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

"Wendy" <Wendy @discussions.microsoft.com wrote in message
...
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!

How do I add drop down choices to a spreadsheet?
 

You can use a named range as the source, as described he

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

Wendy wrote:
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


"Bob Phillips" wrote:


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

--
HTH

Bob Phillips

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

"Wendy" <Wendy @discussions.microsoft.com wrote in message
...

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!





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

How do I add drop down choices to a spreadsheet?
 

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)

"Wendy" wrote in message
...
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


"Bob Phillips" wrote:

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

--
HTH

Bob Phillips

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

"Wendy" <Wendy @discussions.microsoft.com wrote in message
...
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!

How do I add drop down choices to a spreadsheet?
 

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" wrote:

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)

"Wendy" wrote in message
...
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


"Bob Phillips" wrote:

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

--
HTH

Bob Phillips

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

"Wendy" <Wendy @discussions.microsoft.com wrote in message
...
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!

How do I add drop down choices to a spreadsheet?
 

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)

"Wendy" wrote in message
...
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" wrote:

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)

"Wendy" wrote in message
...
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


"Bob Phillips" wrote:

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

--
HTH

Bob Phillips

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

"Wendy" <Wendy @discussions.microsoft.com wrote in message
...
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!

How do I choose multiple choices from a drop down box?
 

Is this possible in MS Excel 2007? I'm talking about a similar function as
on websites.
TY Carol

"Bob Phillips" wrote:

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)

"Wendy" wrote in message
...
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" wrote:

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)

"Wendy" wrote in message
...
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


"Bob Phillips" wrote:

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

--
HTH

Bob Phillips

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

"Wendy" <Wendy @discussions.microsoft.com wrote in message
...
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!

How do I choose multiple choices from a drop down box?
 

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
wrote:

Is this possible in MS Excel 2007? I'm talking about a similar function as
on websites.
TY Carol

"Bob Phillips" wrote:

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)

"Wendy" wrote in message
...
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" wrote:

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)

"Wendy" wrote in message
...
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


"Bob Phillips" wrote:

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

--
HTH

Bob Phillips

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

"Wendy" <Wendy @discussions.microsoft.com wrote in message
...
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!