Forum Discussion
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.
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.