Note: The other languages of the website are Google-translated. Back to English
English English
Support is Offline
Today is our off day. We are taking some rest and will come back stronger tomorrow
Official support hours
Monday To Friday
From 09:00 To 17:30
  Anonymous User
  Friday, 23 September 2022
  3 Replies
  1.5K Visits
0
Votes
Undo
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.
2 months ago
·
#3085
Accepted Answer
0
Votes
Undo
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
2 months ago
·
#3085
Accepted Answer
0
Votes
Undo
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
2 months ago
·
#3086
0
Votes
Undo
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.
2 months ago
·
#3088
0
Votes
Undo
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
  • Page :
  • 1
There are no replies made for this post yet.