Hello! I have a cell in A1 with a drop down list. I want to move this cell, for example from A1 to B4 (with drag / drop or cut / paste BUT I don't want to copy / paste), with: in B4, the moved cell which keeps the drop-down list (and therefore possibility of changing the choice in my drop-down list) --- I manage to do it in A1, the "new" cell still allows me to have access to the drop-down list --- I can't do it, the drop-down list is no longer there after I use drag / drop or cut / paste. In other words, how to do so that in A1 there is always the drop-down list, even if I moved the cell (drag / drop or cut / paste) elsewhere? Thank you! Yvan

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

drop down list + drag/drop cut/paste

Thread starter Yvan73
Start date Jun 1, 2021

Yvan73

New Member

Jun 1, 2021

Hello!

I have a cell in A1 with a drop down list. I want to move this cell, for example from A1 to B4 (with drag / drop or cut / paste BUT I don't want to copy / paste), with:

in B4, the moved cell which keeps the drop-down list (and therefore possibility of changing the choice in my drop-down list) --- I manage to do it
in A1, the "new" cell still allows me to have access to the drop-down list --- I can't do it, the drop-down list is no longer there after I use drag / drop or cut / paste.

In other words, how to do so that in A1 there is always the drop-down list, even if I moved the cell (drag / drop or cut / paste) elsewhere?

Thank you!

Yvan