HOW TO MAKE MULTIPLE DROPDOWN ON EXCEL SHAREPOINT

Question

I badly wonder how to make a multiple dropdown in excel share point.
Example:
Fruits Category:
banana
grape
peach
apple

I want to fill one cell with:
"banana, grape, apple"
which mean i can select more than 1 fruits. But i can't find any solution in internet.
Please help me

Answer 1

Excel sharepoint can't solve this,

1. Data Validation: can't solve this - it say "The Formula you entered is not valid"
2. VBA can't work in share point because its online feature

Answer 2

Dear @Niko Patty,

Thank you for reaching out to the Microsoft Q&A forum. I’m happy to assist you.

In Excel for the web, there is no built‑in feature to make multiple selections from a single drop‑down list. True multi‑select is only possible in the Excel desktop app using VBA.

That said, here is a workaround you can try in Excel for the web to display multiple items in one cell:

Build a helper columns with formulas like TEXTJOIN

In Sheet1, list your fruits in cells A2:A5

For example, in cell A6, enter this formula:

=TEXTJOIN(", ", TRUE, A2:A3)

This formula concatenates the text in cells A2:A3 with a comma and space, ignoring blanks.

This gives Banana, Grape.

Repeat for other pairs/triples manually.

Apply Data Validation (List):

Select the range of cells where you want the drop-down list (for example, Sheet2, A2:A20).

Go to Data > Data Tools > Data Validation.

In the Data Validation window, under Allow, select List. Specify the source by navigating to Sheet1 and selecting the range containing all the choices.

Click Apply.

As a result, the target cell will show something like “banana, grape, apple” based on the values chosen in the helper cells.

If you’re comfortable sharing your current formula, I can review it to see why it isn’t working as expected.

Also, could you let me know why using the Excel desktop app isn’t an option in your scenario? In the desktop app, this requirement can be handled much more efficiently with a small VBA macro.

Please try these steps, and if you encounter any difficulties, let me know.

Since I do not have access to your device/tenant environment, there may be cases where my recommended solutions do not fully resolve the issue or other problems appear. If that happens, please update me right away with any new details or results in the Comment. I will do my best to support you and help find a solution as quickly as possible.

---

If you found the answer useful, please click "Accepted Answer" and kindly give it an upvote.

If you have any follow-up questions, feel free to click "Comment" to continue the discussion.

Note: To receive email notifications related to this thread, please follow the steps in our documentation to enable email alerts.