The Paste Special dialog box opens and displays several pasting options.Click "Validation" followed by "OK." Excel copies the drop-down list to the cells you selected.

The Data Validation feature in Excel 2013 offers a List option to confine selections in a cell to a preconfigured series of values. This selection can further influence the values in another list ...