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

Conditionally Formatting A Drop Down List In a previous post I showed you how to Create a Drop Down List in a Table.    We are now going to take this concept one level further and apply some conditional formatting to the drop down data validation list.This is useful if you want to highlight when a job is completed, c...
Turn Text Dates To Excel Dates With Text To Column... Whenever you import data from your company's server, ERP system or any other source for that matter, the Dates usually come in a TEXT format.I will show you a cool trick where you can turn the TEXT Date to a values Date that Excel can read and work with.DOWNLOAD EXCEL WOR...
Fix Excel Hyperlinks to a Named Range Hyperlinks in Excel must be one of the funkiest features that I love playing around with!They allow you to create interactive buttons within Excel (without the need to create a Macro) and you can make them take you to any cell or range within your Excel worksheet.One shor...
Convert Values to Dates Using Flash Fill In Excel  Flash Fill in Excel is a new feature that was introduced in Excel 2013.Flash Fill allows you to combine, extract, move & transform data that belongs in one column, into a new column.One of the cool uses of Flash Fill is convert your values into Excel dates a...