Excel 2016 Tips and Tricks

Excel 2016

Lesson 2 – Working with Tables

more than one row within a Region with the same Month and Year (such as the Dec 2006 rows in the Northeast region), they are now sorted by Product.

Use the Undo button on the Quick Access Toolbar to undo all sorting and return the table to its unsorted state.

U SING T EXT F ILTERS  D ISCUSSION

When a table column contains text entries, the Filter menu for the column offers several special Text Filters which provide powerful options for filtering the data. Instead of simply filtering the data by selecting one or more column entries, you can filter the data to display all entries that begin with the same characters or end with the same characters, such as all entries that begin with sport . You can filter to display all entries that contain the same characters anywhere in the entry, such as entries that contain sport somewhere in the entry. You can also filter to display all entries that do not contain sport . When you select one of the Text Filters from the Filter menu, the Custom AutoFilter dialog box opens with the chosen filter type pre-selected. You simply need to enter the characters by which you want to filter. You can specify a second filter criteria in the dialog box, if desired. When you specify a second filter criteria, you must also choose whether both criteria need to be met to display a row in the filtered data (choose And ) or whether a row that meets either criteria should be displayed (choose Or ).

OFFICEPRO, Inc.

Page 47