For example your worksheet contains a lot of content, 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.
Select the Data tab, then click the Filter command.
A drop-down arrow
will appear in the header cell for each column.
Click the drop-down arrow for the column you wish to filter. In our example, we will filter column B to view only certain types of equipment.
The Filter menu will appear.
Check or uncheck the boxes depending on the data you wish to filter, then click OK. In our example, we'll uncheck everything except for August.
Click the drop-down arrow for the filter you wish to clear. In our example, we'll clear the filter in column D.
The Filter menu will appear.
Choose Clear Filter From [COLUMN NAME] from the Filter menu. In our example, we'll select Clear Filter From "Checked Out".
How to filter data:
In this example, we'll apply a filter to an equipment log worksheet to display only the laptops and projectors that are available for checkout. In order for filtering to work correctly, your worksheet should include a header row, which is used to identify the name of each column. In our example, our worksheet is organized into different columns identified by the header cells in row 1: ID#, Type, Equipment Detail, and so on.A drop-down arrow
will appear in the header cell for each column.Click the drop-down arrow for the column you wish to filter. In our example, we will filter column B to view only certain types of equipment.
The Filter menu will appear.
Uncheck the box next to Select All to quickly deselect all data.
Check the boxes next to the data you wish to filter, then click OK. In this example, we will check Laptop and Tablet to view only those types of equipment.
The data will be filtered, temporarily hiding any content that doesn't match the criteria. In our example, only laptops and tablets are visible.
Uncheck the box next to Select All to quickly deselect all data.
Check the boxes next to the data you wish to filter, then click OK. In this example, we will check Laptop and Tablet to view only those types of equipment.
The data will be filtered, temporarily hiding any content that doesn't match the criteria. In our example, only laptops and tablets are visible.
To apply multiple filters in Excel:
Filters are cumulative, which means you can apply multiple filters to help narrow down your results. In this example, we've already filtered our worksheet to show laptops and projectors, and we'd like to narrow it down further to only show laptops and projectors that were checked out in August.
Click the drop-down arrow for the column you wish to filter. In this example, we will add a filter to column D to view information by date.
The Filter menu will appear.
Check or uncheck the boxes depending on the data you wish to filter, then click OK. In our example, we'll uncheck everything except for August.
The new filter will be applied. In our example, the worksheet is now
filtered to show only laptops and tablets that were checked out in
August.
How To clear a filter in Excel:
After applying a filter, you may want to remove, or clear, it from your worksheet so you'll be able to filter content in different ways.Click the drop-down arrow for the filter you wish to clear. In our example, we'll clear the filter in column D.
The Filter menu will appear.
Choose Clear Filter From [COLUMN NAME] from the Filter menu. In our example, we'll select Clear Filter From "Checked Out".
The filter will be cleared from the column. The previously hidden data will be displayed.
To remove all filters from your worksheet, click the Filter command on the Data tab.
