Page 137 - Ms Excel Note and Workbook

MICROSOFT EXCEL NOTE AND WORKBOOK

4. The worksheet will be filtered according to your search term. In our example, the
worksheet is now filtered to show only Saris brand equipment.

To use advanced text filters:

Advanced text filters can be used to display more specific information, like cells that contain a
certain number of characters or data that excludes a specific word or number. In our example, we'd
like to exclude any item containing the word laptop.

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. Hover the mouse over Text Filters, then select the desired
text filter from the drop-down menu. In our example, we'll choose Does Not Contain to
view data that does not contain specific text.

128 | P a g e