Losing Cells Data Validation Rules After Cut and Paste Action - Microsoft Community

hello dears,

have excel table data validation rule applied cells.
when cut of them , paste in place, lose data validation rule of original cell.
there way prevent losing data validation rule when use cut command?
appreciate help. tks

ciao,

can use workaround:

1) open clipboard (home -> clipboard)
2) copy data (do not cut them). see data copied in clipboard
3) delete data
4) paste data clipboard

please let me know if works you.

ciao
ugo

Office / Excel / Microsoft Office Programming / Office 2016