Slicers were introduced with Pivot Tables in Excel 2010 and they allowed us to select items to filter with beautiful interactive buttons.

You can see the power of Slicers and the different ways you can format them in these posts: https://www.myexcelonline.com/category/pivot-tables/slicers/

In Excel 2013, Slicers have been extended to be used with Excel Tables.  WOW!

To insert a Slicer in an Excel Table you have to follow these short steps:

STEP 1: Click inside the Excel Table

STEP 2: Select Table Tools > Design > Insert Slicer

STEP 3: Tick the Table Headers that you want to include in your Slicer and press OK

STEP 4: Click on the Slicer buttons and see how your Excel Table gets filtered without needing to select the filter drop down.

DOWNLOAD WORKBOOK

Table Slicers

HELPFUL RESOURCE:

728x90

If you like this Excel tip, please share itEmail this to someone

email

Pin on Pinterest

Share on Facebook

Tweet about this on Twitter

Share on LinkedIn

Share on Google+

Related Posts

Show The Percent of Column Total With Excel Pivot ... Excel Pivot Tables have a lot of useful calculations under the SHOW VALUES AS option and one that can help you a lot is the PERCENT OF COLUMN TOTAL calculation.This option will immediately calculate the percentages for you from a table filled with numbers such as sales data, ...
Show The Percent of Parent Row Total With Excel Pi... Excel Pivot Tables have a lot of useful calculations under the SHOW VALUES AS option and one that can help you a lot is the PERCENT OF PARENT ROW TOTAL calculation.This is a new calculation in Excel 2010 and onwards.This option will immediately calculate the percentages f...
Find Errors with Go to Special Constants Say you have a data set and want to make sure that each column contains what it is supposed to.For example, say you have a column which contains Dates and you want to check that there are no cells which contain Text.You can easily check this by highlighting that column an...
Filter Unique Records The Advanced Filter allows you to filter unique records and copy them to another location outside the data set.  This is useful when you want to use a filtered list for further analysis.This can also be achieved by using a Pivot Table.  Placing a Field in the Row Labels will ...