Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating a dropdown list based on selection from a differernt drop | Excel Discussion (Misc queries) | |||
Creating a dropdown list within a column | Excel Discussion (Misc queries) | |||
Creating a Dropdown List | Excel Worksheet Functions | |||
Creating a dropdown list | Excel Discussion (Misc queries) | |||
creating a dropdown list in excel | Excel Discussion (Misc queries) |