About
In this article we will review how to filter data using Excel on the web.
Environment
Excel on the web in a desktop browser.
Steps
- Navigate to Excel on the web as you normally would.
- Select the column you wish to filter by clicking its corresponding letter.
- In the ribbon on the Home tab you will click on the button that has A above Z to the left of a funnel.
- A drop down menu will appear.
- Click the filter button which resembles a funnel.
- Note that a little down arrow is now displayed at the top cell of the column you selected at the right.
- Click on that arrow. You will see your filter options at the bottom.
- Adjust as desired and your data will be filtered accordingly.
Hint: (You can only filter by one column at a time.)
Hint: (You can search for the item you wish to filter by. This is handy if you have a lot of options in the column.)
For more help, please contact ITS at its@manhattan.edu or 718-862-7973.