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

Pinterest

Share on Facebook

Facebook

Tweet about this on Twitter

Twitter

Share on LinkedIn

Linkedin

Share on Google+

Google+

Related Posts

Running Total In % with an Excel Pivot Table A Running Total In is the accumulation of values over a certain period, like days, month or years.  It is sometimes referred to as the Year to Date analysis. A Running Total In takes one period's values, then adds a second period, then a third period...and so on, to give the a...
Text to Columns – Emails If you have a data set with text consisting of names and email addresses that are wrapped inside a parenthesis, like: John (john@email.com)   ...then you can use the Text to Columns feature in Excel to take out the email addresses and put them in a separate ...
Consolidate in Excel with the CONSOLIDATE Tool The Consolidate tool in Excel is located in the Data menu and combines values from multiple ranges into one new range. You would use this feature when you have a single text column on the left and the column has many duplicate values. First you need to select a blank cell o...
Pivot Table Count Transactions The default Value Field Setting when analyzing data with a Pivot Table is to Sum, but you can also analyze a Pivot Table with a Count. This is useful when you want to see how many sales transactions  took place within a region, a month, a year or per business unit. DOWNLOAD...