About
In this article we will review how to filter data using Excel locally installed.
Environment
Excel locally installed on your computer.
Steps
- Navigate to Excel as you normally would.
- Select the column you wish to filter by clicking its corresponding letter.
- In the ribbon on the Data tab you will click on the Filter button that has a funnel icon.
- 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, click Apply Filter 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.