Microsoft Office Tutorials and References
In Depth Information
Filtering Excel tables visually by using slicers
Filtering Excel tables visually by using slicers
In versions of Excel prior to Excel 2013, the only visual
indication that you had applied a filter to Excel table column was the
indicator added to the column’s filter arrow. The indicator told
users that there was an active filter applied to that column but
provided no information about which values were displayed and
which were hidden. In Excel 2013, Slicers provide a visual
indication of which items are currently displayed or hidden in an Excel
table field.
Add a slicer
1 Click any cell in the Excel table that you want to filter.
2 Click the Insert tab.
3 Click Slicer.
4 Select the check box next to each column by which you want to
filter the table.
5 Click OK.
Search JabSto ::

Custom Search