How to Insert the Same Drop-Down List Into Multiple Cells of an Excel Spreadsheet. If you use simple copy and paste methods to duplicate an Excel drop-down list, you may discover a problem; when ...

Microsoft Excel updates cell references when you copy an expression. Here are a couple of workarounds for those rare occasions when you don't want to change the cell references.