If you use simple copy and paste methods to duplicate an Excel drop-down list, you may discover a problem; when you copy a cell that has a drop-down list and press "Ctrl-V" to paste it into a new cell ...
To insert multiple rows in Excel, first highlight the number of rows you want to add. Then, right-click the selected rows and click Insert in the context menu. You can also add a row in Excel by right ...