| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
drop-down list
I would pre-select the 600 cells then DataValidationAllowList
But setting one cell then dragging works for me in 2003 and 2007 versions. Are your options set to "allow cell drag and drop"? Gord Dibben MS Excel MVP On Fri, 20 Feb 2009 13:53:02 -0800, karelina wrote: How do I copy a drop down list easily in a column of 600 rows? Dragging doesn't work, copying all the cells and validating doesn't work, fill down doesn't work. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Drop down list dependant on previous drop down list | Excel Discussion (Misc queries) | |||
| Drop down lists that auto create and then filter the next drop down list | Excel Worksheet Functions | |||
| Drop Down List choice selecting another drop down list | Excel Worksheet Functions | |||
| how do I link a drop down list entry to a new drop down cell? | Excel Discussion (Misc queries) | |||
| multiple select from the drop down list in excel. list in one sheet and drop down in | Excel Discussion (Misc queries) | |||
Threaded Mode
