how do I copy and paste a drop down list in excel?

A

Adriana

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!
 
G

Gord Dibben

Dragging with the fill handle works for me in 2003

Do you have drag and drop enabled?


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

drop-down list 2
Formatted cell column in drop down list 1
Excel Excel: How do I put a formula in a drop down list 11
Dependent drop down dynamic range formula, off sheet. 7
How do I create a drop down box within a drop down box? 1
drop down list 3
customize drop-down box 1
Excel 2007 / right-click / pick from drop down list 1

Top