Creating a dropdown list
 

I created a dropdown list in an existing worksheet; however, when I try to
paste the list into multiple cells, the values in my list disappear. I have
used COPY and PASTE SPECIAL and the same thing happens. EX: There are 4
items in my list. All 4 appear in my 1st cell. But when I paste to the
remaining cells, only 3 items appear, then 2, then 1, then NONE. Please
help. I'm pulling my hair out! Thanks.
--
Bev

Creating a dropdown list
 

It sounds like you might have used relative references as the source for
your list. For example:

=G1:G4

Try making the source range absolute:

=$G$1:$G$4

--
Biff
Microsoft Excel MVP


"Bebe" wrote in message
...
I created a dropdown list in an existing worksheet; however, when I try to
paste the list into multiple cells, the values in my list disappear. I
have
used COPY and PASTE SPECIAL and the same thing happens. EX: There are 4
items in my list. All 4 appear in my 1st cell. But when I paste to the
remaining cells, only 3 items appear, then 2, then 1, then NONE. Please
help. I'm pulling my hair out! Thanks.
--
Bev

Creating a dropdown list
 

Thank you, thank you, thank you. It worked!
--
Bev


"T. Valko" wrote:

It sounds like you might have used relative references as the source for
your list. For example:

=G1:G4

Try making the source range absolute:

=$G$1:$G$4

--
Biff
Microsoft Excel MVP


"Bebe" wrote in message
...
I created a dropdown list in an existing worksheet; however, when I try to
paste the list into multiple cells, the values in my list disappear. I
have
used COPY and PASTE SPECIAL and the same thing happens. EX: There are 4
items in my list. All 4 appear in my 1st cell. But when I paste to the
remaining cells, only 3 items appear, then 2, then 1, then NONE. Please
help. I'm pulling my hair out! Thanks.
--
Bev

Creating a dropdown list
 

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"Bebe" wrote in message
...
Thank you, thank you, thank you. It worked!
--
Bev


"T. Valko" wrote:

It sounds like you might have used relative references as the source for
your list. For example:

=G1:G4

Try making the source range absolute:

=$G$1:$G$4

--
Biff
Microsoft Excel MVP


"Bebe" wrote in message
...
I created a dropdown list in an existing worksheet; however, when I try
to
paste the list into multiple cells, the values in my list disappear. I
have
used COPY and PASTE SPECIAL and the same thing happens. EX: There are
4
items in my list. All 4 appear in my 1st cell. But when I paste to
the
remaining cells, only 3 items appear, then 2, then 1, then NONE.
Please
help. I'm pulling my hair out! Thanks.
--
Bev

Creating a dropdown list
 

Hi,

And of course if you are copying down there is not need for $ signs in front
of the column letters.

=$G$1:$G$5 can be

=G$1:G$5

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Bebe" wrote:

I created a dropdown list in an existing worksheet; however, when I try to
paste the list into multiple cells, the values in my list disappear. I have
used COPY and PASTE SPECIAL and the same thing happens. EX: There are 4
items in my list. All 4 appear in my 1st cell. But when I paste to the
remaining cells, only 3 items appear, then 2, then 1, then NONE. Please
help. I'm pulling my hair out! Thanks.
--
Bev