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.
6 Replies
Sort By
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.
- fjhidalgogCopper ContributorThank you for your recommendation and time to answer. Unfortunately, that doesn't work on Excel Web, which is what I need.
It works for me in Excel Online:
(Excel Online is in Dutch on my PC, but the idea should be clear)