Quickly Select Multiple Items From Drop Down Lists In Excel

Question

Hello,
I followed your tutorial which worked well. But I would like to combine several elements in the same cell but in another sheet. Is it possible ? I can't. Can you help me please ? Thnak you.

Amanda Lee · Accepted Answer

Hi there,

Let's say your drop-down list is in A1:A10 in Sheet1, and you will selected multiple items from the drop-down list in cells across A1:A10, you can enter the formula in A1 in Sheet2: =Sheet1!A1, and then drag the fill handle down to apply the formula to the below cells until A10.

Amanda

从 Excel 的下拉列表中快速选择多个项目