To copy the same formula to other cells in Excel is easy, and you can use keyboard shortcuts, AutoFill or Copy and Paste command.

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 ...