drop-down list

K

karelina

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.
 
T

T. Valko

Let's assume the list is in A1 and you want to copy it to A2:A10...

Select cell A1
Copy it: Edit>Copy
Now select A2:A10
Edit>Paste Special>Validation>OK
 
G

Gord Dibben

I would pre-select the 600 cells then Data>Validation>Allow>List

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
 

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

Formatted cell column in drop down list 1
how do I copy and paste a drop down list in excel? 2
Dependent drop down dynamic range formula, off sheet. 7
data validation drop down list format 1
Display invisible numbers in a drop down menu 1
Drop Down with dynamic named range offsheet source list 14
Vlookups not working 2
Excel Excel: How do I put a formula in a drop down list 11

Top