Excel 2016 Tips and Tricks

Excel 2016

Lesson – Working with Tables



S TEP - BY -S TEP

Filter data using text filters.

Steps

Practice Data

1. Select the desired Filter arrow. The Filter menu opens.

Click Purchaser

2. Point to Text Filters .

Point to Text Filters

The Text Filters submenu opens.

3. Select the desired text filter option.

Click Contains

The Custom AutoFilter dialog box opens with the desired filter pre- selected. 4. Enter the desired matching text in the box to the right of the selected text filter. The text appears in the box. 5. Enter a second filter criteria in the dialog box, if desired. The desired criteria appear in the second row of boxes.

Type sport

Follow the instructions shown below the table before continuing to the next step

6. Select the OK button.

Click

The Custom AutoFilter dialog box closes and the table data is filtered.

Select the left-hand list in the second row of boxes in the dialog box. Scroll as necessary and select does not contain . Click in the right-hand box in the second row of boxes and type city . Select the And option between the two rows of boxes, if necessary.

Return to the table and continue to step 6.

Practice the Concept: Select the Product Filter arrow and point to Text Filters . Select Ends With from the submenu. In the Custom AutoFilter dialog box, type balls in the right-hand box in the first row. Select the left-hand list in the second row. Scroll as necessary and select ends with . Click in the right-hand box in the second row and type machines . Select the Or option, then click OK . Notice that the filtered data displays Products that end with balls or that end with machines .

OFFICEPRO, Inc.

Page 49