Table Slicers In #Excel

Slicers are a more visual way to filter the data in an Excel table

You can download the workbook here to follow along.

Slicers are an option in Excel that allows you to filter the data in a table more visually and easier. Click anywhere in your table, and on the contextual Design tab that appears, select Insert Slicer:

TS1

A dialog box will appear with a list of each of the headers in your table. You can now check to select which you want to filter by. Here I’ve chosen Salesman, Model, Region, and New/Used:

TS2

These four slicers now appear in my worksheet:

TS3

And I can size them and rearrange them any way I’d like:

TS4

Now, by clicking on any of the fields within each slicer, I can filter the data for that column and visually see what is filtered in each. By holding down the Ctrl key I can select multiple items within a slicer:

TS5

Clicking on the red “X” in the upper right corner will remove that filter from the table:

TS6

You can right click on any slicer to remove it, or modify some of the settings:

TS7

Slicers can be a very valuable tool in Excel. Try them, play around with the options. Note that if you reduce the height of a slicer to be shorter than the list of options, a scroll bar will automatically appear to allow access to all the items in the list.

Happy Excelling!

Related Post

Free Download!

Subscribe to Download Your FREE Copy of
"My 70+ Favorite Excel Keyboard Shortcuts" Today!

, , , ,

5 Responses to Table Slicers In #Excel

  1. Oz December 11, 2013 at 9:19 am #

    Tables with slicers are an EXCELLENT feature.
    Something to add: This is a reason to upgrade to Excel 2013.

    This isn’t on Excel for Mac or Excel 2010. It’s so sad to show this to people who don’t have it. 🙁

  2. Eddie December 11, 2013 at 10:04 am #

    Can you use this in excel 2010?

    • Michael Rempel December 11, 2013 at 4:06 pm #

      Eddie, Excel added slicers to PIVOT tables in 2010, but the slicers for regular tables only in 2013.

Trackbacks/Pingbacks

  1. How To Use SUMIF & SUMIFS In Excel | Excel Bytes - July 21, 2015

    […] we’ll filter our table using the Table Slicers (You can find the post regarding Table Slicers here) and we get the same […]

Leave a Reply