Excel Filters Tutorial
- 1). Log on to your computer and open Microsoft Excel. Open the spreadsheet you wish to filter. When learning to filter data it is best to choose a large spreadsheet, one that contains a lot of columns and lot of rows.
- 2). Highlight the column or columns you wish to filter. To highlight a single column, simply click on the gray bar at the top of the column. To select more than one column, highlight the first column and use your mouse pointer to highlight the remaining columns.
- 3). Click the "Home" tab and choose "Sort and filter." Click the "Filter" button.
- 4). Place your cursor at the bottom of the first cell and click the "Arrow" button. Click the "Text Filter" and choose the words you wish to filter by. Excel will display only the rows that meet the filter criteria.
- 5). Click the "Sort and filter" button and choose "Clear" to remove the filter. All of the data in the spreadsheet will again be displayed.
Source...