Page 134 - Ms Excel Note and Workbook
P. 134
MICROSOFT EXCEL NOTE AND WORKBOOK
To apply multiple filters:
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.
1. Click the drop-down arrow for the column you want to filter. In this example, we will
add a filter to column D to view information by date.
2. The Filter menu will appear.
3. Check or uncheck the boxes depending on the data you want to filter, then click OK. In
our example, we'll uncheck everything except for August.
4. The new filter will be applied. In our example, the worksheet is now filtered to show only
laptops and projectors that were checked out in August.
125 | P a g e
