Function Problems

How to Create a Multi-Select Dropdown Workaround in Excel for the Web

Tauseeq Magsi Oct 7, 2026 871 views

Question details

The user needs a way to select multiple values from a dropdown menu in Excel for the Web, where VBA macros are not supported.

How to Create a Multi-Select Dropdown Workaround in Excel for the Web

Product: Excel for the Web
Device & OS: not provided
Scenario: Attempting to input multiple items from a predefined list into a single record or cell using data validation in a browser environment.
Observed behavior: Excel for the Web does not natively support multiple selections within a single data-validation dropdown cell, and VBA macros used to bypass this in the desktop version cannot execute in the browser.

Before you start

Before setting up this workaround, determine the maximum number of items you might need to select at once, and ensure you have that many adjacent empty columns available in your worksheet.

Solution 1Recommended

Use Multiple Dropdown Cells and the TEXTJOIN Function

This is the most efficient workaround for the web. By using multiple cells for selection and merging them with TEXTJOIN, you avoid the need for VBA macros.

Since VBA cannot run in Excel for the Web, you cannot modify a single dropdown to accept multiple clicks. Instead, you must spread the selections across several columns and use a formula to combine the results into a final display cell.

Create helper columns

Insert a series of new columns next to your data entry area. For example, if you need to select up to four items, reserve columns D, E, F, and G.

Apply Data Validation

Highlight the reserved helper cells. Navigate to the Data tab on the ribbon, click Data Validation, choose 'List', and select your source items to create standard dropdowns in each cell.

Combine values with TEXTJOIN

In your final result cell, enter the formula =TEXTJOIN(", ", TRUE, D2:G2). This formula merges the selected text and automatically ignores any dropdown cells you leave blank.

Hide helper columns (Optional)

To keep your spreadsheet looking clean, select the headers of your helper columns (D through G), right-click, and select 'Hide'.

Use Multiple Dropdown Cells and the TEXTJOIN Function

Clean Formatting: Setting the second argument of TEXTJOIN to TRUE ensures you won't have awkward dangling commas if you don't use all the dropdown slots.

Solution 2

Concatenate Cells Manually using Ampersands

If you are using an older spreadsheet environment where the TEXTJOIN function is unavailable, you can manually combine the cell values.

Advanced Data Handling

Easily Handle Data Validation and Macros with WPS Spreadsheet

WPS Office Spreadsheet provides robust data validation features, comprehensive advanced formula support including TEXTJOIN, and full VBA macro capabilities on the desktop version, allowing you to easily build true multi-select dropdowns.

1. Open WPS Spreadsheet: Launch WPS Office and open your workbook in the Spreadsheet application.
2. Set up Data Validation: Highlight your target cells, navigate to the Data tab, click on Validation, and select List to insert your dropdown options.
3. Use TEXTJOIN: Easily merge multiple cell values into one by typing =TEXTJOIN(", ", TRUE, A1:C1), fully supported in WPS Spreadsheet.
4. Utilize VBA for advanced needs: Switch to the Developer tab on WPS Desktop to write a quick VBA script, allowing you to bypass web limitations and create true multi-select dropdowns in a single cell.

Fully compatible with Microsoft Excel file formats (.xlsx)Supports modern functions like TEXTJOIN for seamless data aggregationRobust VBA macro support in the desktop app for true multi-select dropdownsFree, lightweight, and incredibly easy to use

microsoft office alternative - wps office

Frequently Asked Questions

Why can't I just use a macro for multi-select dropdowns in Excel for the Web?

Excel for the Web operates in a browser environment and does not support running VBA macros. Any scripts or code designed to enable true multiple selections in a single cell will only function when the file is opened in the desktop application.

Will the TEXTJOIN function leave extra commas if I leave a dropdown cell blank?

No. The TEXTJOIN function is designed to handle this cleanly. As long as you set the second argument to TRUE (e.g., =TEXTJOIN(", ", TRUE, D2:G2)), the formula will automatically ignore any empty cells and prevent dangling delimiters.

Is there a way to do this without cluttering my sheet with extra columns?

Because VBA is restricted on the web, using helper columns is the most reliable workaround. To keep your sheet looking professional, you can simply hide the helper columns by right-clicking their column headers and selecting 'Hide' after you have set up your formulas.

What should I do if I need to select more items than I have helper columns?

If you reach your limit, you will need to insert additional helper columns next to your existing ones, apply Data Validation to them, and expand the cell range in your TEXTJOIN formula to include the new columns.

Excel & Data Problems