| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copying a Drop Down Menu
I am making a data-entry spreadsheet. I have a drop down menu for each
column, and I want to copy that drop down menu and paste it in each cell for that column. When I have tried to follow instructions on excel (copy, paste special, check validation), the top item in the menu is erased. It looks like the range is changing in each cell (i.e. =F1:F6 in F16 goes to =F2:F7 in F17, then =F3:F8 in F18). How can I copy my drop down menu and keep it the same for each cell? Thanks for your help! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Drop Down choice needs to lead to another drop down menu | Excel Discussion (Misc queries) | |||
| Drop dwn menu. Formula to count selection frm menu in anoth cell? | Excel Worksheet Functions | |||
| filter dropdown menu so 2nd drop menu is customized | Excel Worksheet Functions | |||
| Cross-referenced drop-down menu (nested drop-downs?) | Excel Worksheet Functions | |||
| How do I set up a drop down menu within a drop down menu? | Excel Discussion (Misc queries) | |||
Threaded Mode
