Forum Discussion
fjhidalgog
May 24, 2023Copper Contributor
Excel Web options to select on option from a list of items.
I need to be able to select an option from various products so I can filter the data by this product. Do you know how I can choose from a bunch of ten options? It must be working on Excel Web.
HansVogelaar
May 24, 2023MVP
Just like in the desktop version:
- Enter the 10 options in a range, for example M1:M10.
- Select the cell or cells where you want to be able to select an option.
- On the Data tab of the ribbon. click Data Validation.
- Select List from the Allow drop down.
- Click in the Source box, them point to the range - M1:M10 or whichever range you used.
- Click OK.
- fjhidalgogMay 24, 2023Copper ContributorThank you for your recommendation and time to answer. Unfortunately, that doesn't work on Excel Web, which is what I need.
- HansVogelaarMay 24, 2023MVP
It works for me in Excel Online:
(Excel Online is in Dutch on my PC, but the idea should be clear)
- fjhidalgogMay 24, 2023Copper ContributorThank you for taking again the time to answer. However, you see, the title of my problem is in Web Excel, not Excel Online, where I have the problem. So, when I share the link (that I sent you), people cannot see the drop-down list. That's why I have this problem, and I need a solution. The idea is that people don't have Excel. Only uses Web Excel.