Page 136 - Ms Excel Note and Workbook

MICROSOFT EXCEL NOTE AND WORKBOOK

Advanced filtering

If you need a filter for something specific, basic filtering may not give you enough options.
Fortunately, Excel includes many advanced filtering tools, including search, text, date,
and number filtering, which can narrow your results to help find exactly what you need.

To filter with search:

Excel allows you to search for data that contains an exact phrase, number, date, and more. In our

example, we'll use this feature to show only Saris brand products in our equipment log.

1. Select the Data tab, then click the Filter command. A drop-down arrow will appear in
the header cell for each column. Note: If you've already added filters to your worksheet,
you can skip this step.

2. Click the drop-down arrow for the column you want to filter. In our example, we'll filter
column C.

3. The Filter menu will appear. Enter a search term into the search box. Search results will
appear automatically below the Text Filters field as you type. In our example, we'll
type saris to find all Saris brand equipment. When you're done, click OK.

TIP
you need a filter for
something specific, basic
filtering may not give you
enough options.

127 | P a g e