Microsoft Office Tutorials and References
In Depth Information
Filtering Excel table data by using slicers
21
On the Quick Access Toolbar , click the Undo button to remove your filter and restore
the table to its uniltered state.
CLEAN UP Close the PackageExceptions workbook, saving your changes if you
want to.
Filtering Excel table data by using slicers
In versions of Excel prior to Excel 2013, the only visual indication that you have applied a
filter to an Excel table column is the indicator added to a column’s filter arrow. The indicator
lets users know that there is an active filter applied to that column but provides no
information about which values are displayed and which are hidden. Beginning with Excel 2010, you
could use slicers to provide a visual indication of which items are currently displayed or
hidden in a PivotTable. Excel 2013 extends that ability to filtering an Excel table.
5
To create a slicer, click any cell in an Excel table and then, on the Insert tab, in the Filters
group, click Slicer to display the Insert Slicers dialog box.
Search JabSto ::




Custom Search