New Horizons Get Schooled Blog

Filter your table in a snap with slicers (Excel 2016)

Blog TT(10)To make filtering your table even more straightforward, use Slicers. Select a range within a table or PivotTable, then click on the Insert tab on the main ribbon. In the Filters group, click on Slicer. In the resulting Insert Slicers dialog box, choose the column you want to filter. Excel creates labeled buttons that allow you to filter your table with a single click. After clicking on one of the buttons to filter your table, you can choose more buttons by clicking on the Multi-Select button. When you’re ready to undo the filter, click on the Clear Filter button.

Posted on 9/14/18 10:36 AM by Get Schooled in Microsoft Excel

Get Schooled

Written by Get Schooled

Search by Topic

    Lists by Topic

    see all

    Be at the center of it all.


    Knowledge Ninjas

    a web-based service that allows software application end users to access a subject matter expert in real-time via a chat interface to resolve questions or problems they encounter in their specific software.