Copy cell with drop down list

Copper Contributor

How can one copy a cell which containing drop down list?

2 Replies


I presume you're looking to copy the validation list but not necessarily the value chosen from the list.


Copy the cell with the validation list.


Select the cell or range destination.  Right-click | Paste Special and then select Validation.



No thanks.

In a one time case, I would simply use ctrl+C and ctrl+V to get the same drop down list in the new cell.

However, I want to compose a macro that will copy a specific cell (containing a drop down list) to any cell. I.e. staying in a cell and pushing the macro batten will do exactly the same action as a simply ctrl+C and ctrl+V dose.  @Patrick2788