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

When you want to combine values in Microsoft Excel, instead of complex expressions or VBA, opt for Power Query – it’s fast and easy.