I have a drop down list in cell A1 and I need to copy and paste that list all the way down to A200. Copying and pasting is not working nor is dragging down the corner of the cell. Help.
I have a drop down list in cell A1 and I need to copy and paste that list all the way down to A200. Copying and pasting is not working nor is dragging down the corner of the cell. Help.
There is a easy for that. Copy cell A1 and then select the range A2:A200. Then Goto Edit > Paste Special > Validation > OK.
Dragging with the fill handle works for me in 2003. Do you have drag and drop enabled. There is no option to copy the entire drop down list. Somehow the paste special can help you in this.
Bookmarks