View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default how do I copy and paste a drop down list in excel?

Copy cell A1
Select the range A2:A200
Goto EditPaste SpecialValidationOK

--
Biff
Microsoft Excel MVP


"Adriana" wrote in message
...
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!