Filter Data in an Excel Spreadsheet

Another useful feature in Excel is the Filter feature.
If your worksheet contains a lot of data, it can be difficult to find information quickly. Filters can be used to narrow down the data in your worksheet, allowing you to view only the information you need.
To add filters to the data in your worksheet, position anywhere on the header row and press Control + Shift + L.
Then you can access the filter by pressing Alt + Down Arrow on the column for the data that you want to single out. Arrow Down to the Select All option and press Spacebar to unselect that. Then Arrow Down to find the information you want to filter on and press the Spacebar to select it.
Now, only the relevant rows will be displayed in your worksheet.
To clear the filter, press Alt + Down Arrow on the header of the column, and then press C to Clear the filter.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.