View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
BeBe BeBe is offline
external usenet poster
 
Posts: 14
Default 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