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!

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
news:[email protected]...
> 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!

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
> news:[email protected]...
> > 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!
>
>
>

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

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
>>news:[email protected]...
>>
>>>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

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" <[email protected]> wrote in message
news:[email protected]...
> 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
> > news:[email protected]...
> > > 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!
> >
> >
> >

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" <[email protected]> wrote in message
> news:[email protected]...
> > 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
> > > news:[email protected]...
> > > > 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!
> > >
> > >
> > >
>
>
>

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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
> > news:[email protected]...
> > > 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
> > > > news:[email protected]...
> > > > > 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!
> > > >
> > > >
> > > >
> >
> >
> >