How do I copy cells containing drop downs?

M

mad227

I want to copy a row of cells that contain drop downs to another worksheet.
How do I do this. The copy & paste won't bring it over and the copy & paste
special (either values, formulas or formats) won't do it either.
 
G

Gord Dibben

Assuming your dropdowns are Data Validation List dropdowns they will copy
over.

But I see a potential problem....

If the list range is a selection of cells like $A$1:$A$10 you will see
nothing in the dropdowns on target sheet.

To work around this, either enter the list as comma-delimited

cat,dog,horse,raven

Or select the list on the source sheet and give it a name like mylist.

In the dropdowns source enter =mylist

When copied to new sheet, they will work.


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

Creating drop downs for multiple cells 1
Drop Down with dynamic named range offsheet source list 14
Dependent drop down dynamic range formula, off sheet. 7
Paste, Paste Special 2
Locking combo box into a cell? 1
Can't Copy and Paste in Excel 2003 0
Paste special from cells without formulas/formats 2
Copy formula only from one spreadsheet to another 1

Top