Microsoft Office Tutorials and References
In Depth Information
Using Slicers to Filter a Table
Using Slicers to Filter a Table
Instead of using the AutoFilter menu each time you want to filter data in a table, you can
create a slicer ( New ! ) button that enables you to quickly filter data in a table with a single
click. Each slicer is shown on the screen with button labels that indicate the data being
filtered. A slicer includes a header, filtering buttons, a Clear Filter button, a scroll bar, and
move and resize controls. You can have more than one slicer and move them around on
the worksheet. You can also format slicers with styles to match the look and feel of your
worksheet and easily set options to customize slicer settings.
Create, Format, and Delete a Slicer
Click any data field in the table for which you want to create a slicer.
Click the Design tab under Table Tools.
Click the Insert Slicer button.
Select the check boxes with the table fields for which you want to create a
slicer.
Click OK .
Search JabSto ::




Custom Search