Creating a dropdown list

  • Thread starter Thread starter Bebe
  • Start date Start date
B

Bebe

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.
 
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
 
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
 
Back
Top