» Copying and Pasting Validation list only in Microsoft Excel

When copying a cell that contains validation criteria to a different cell, the criteria are copied along with the text, formula and format.

If you want to copy only the validation criteria, use Paste Special.

To copy only the validation criteria, first copy the cell which contains the validation, and then select a different cell and right-click. From the shortcut menu, select Paste Special, click Validation, and click OK.