Question: how to copy a drop down list from one sheet to another 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.