Quickly Select Multiple Items From Drop Down Lists In Excel
By jarry on Friday, 23 September 2022
Posted in Kutools for Excel
Replies 3
Likes 0
Views 4.7K
Votes 0
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.
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
Amanda Lee
·
1 year ago
·
0 Likes
·
0 Votes
·
0 Comments
·
Thank you very much. That's great.
I have another question on the same topic. How do you delete an item in the cell grouping several items in the drop-down lists (for example if I selected incorrectly)? In fact how to go back. I couldn't find the information in the tutorial. Thanks in advance.
jarry
·
1 year ago
·
0 Likes
·
0 Votes
·
0 Comments
·
Hi there,

You can press Ctrl + Z to undo the selection. Or just select the items you don't want, and delete them from the result cell.

Amanda
Amanda Lee
·
1 year ago
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post