How to change slicer to horizontal in excel

Excel Slicers are a professional way to enable users to easily and intuitively interact with your reports, filtering data in PivotTables, Pivot Charts, Excel Tables and CUBE functions.

How to change slicer font size in excel

They're available in Excel 2010 onwards for PivotTables, and for Excel Tables from Excel 2013. In this comprehensive tutorial I cover EVERYTHING you need to know about Excel Slicers.

Watch the Excel Slicers Video

Download the Workbook and Cheat Sheet

What are Excel Slicers?

Now I know you can already filter using the PivotTable or Excel Table filter tools, but Slicers are better for two reasons:

1. They can control the filtering of multiple PivotTables/Charts (but only one Table)
2. They look professional and are more intuitive to use

Have a go yourself using the interactive workbook below.

Warning: don’t go silly and choose too many areas though, or the PivotChart might implode…..

what am I thinking? That’s like a red rag to a bull, of course you’re going to try it now that I mention it but at least I warned you!

Data used in char