Question: how to copy and paste column with drop down list in excel?
Answer: Select a cell that contains the drop down list you want to copy., Copy the cell by pressing Ctrl + C or Right-click -> Copy., Select the cells where you want to paste the drop down list., Right-click, select paste special, click on Validation and press OK.