Excel Slicers beyond PivotTables into Tables


Office for Mere Mortals
Your beginners guide to the secrets of Microsoft Office
Invalid email address
Tips and help for Word, Excel, PowerPoint and Outlook from Microsoft Office experts.  Give it a try. You can unsubscribe at any time.  Office for Mere Mortals has been running for over 20 years, we've never, ever revealed or sold subscriber details.  Privacy policy

Slicers are a better and easier way to filter lists and it’s available in Excel Tables as well as PivotTables.

From Office 2013 Slicers appeared in the Tables tab, before that Slicers were only for PivotTables.

excel slicers beyond pivottables into tables 16267 - Excel Slicers beyond PivotTables into Tables

Which is great because it makes filtering an Excel table a lot more obvious.

excel slicers beyond pivottables into tables 16268 - Excel Slicers beyond PivotTables into Tables

Making a Table Slicer is tooo easy.  Click in your Table then click Insert Slicer and choose which columns/fields you want slicers for.

excel slicers beyond pivottables into tables 16269 - Excel Slicers beyond PivotTables into Tables

Now the slicer will appear with all the fields selected.

excel slicers beyond pivottables into tables 16270 - Excel Slicers beyond PivotTables into Tables

Select one or more buttons on the Slicer to narrow down what appears in the table.

excel slicers beyond pivottables into tables 16271 - Excel Slicers beyond PivotTables into Tables

It’s the same as the pull down in the header, but a lot more obvious and easier to change.

excel slicers beyond pivottables into tables microsoft excel 16272 - Excel Slicers beyond PivotTables into Tables

Table Slicers have all the features of PivotTable Slicers Click in the Slicer and a Slicer Tools tab appears with all manner of Slicer design options.

excel slicers beyond pivottables into tables 16273 - Excel Slicers beyond PivotTables into Tables

Where are Timelines?

Microsoft, we don’t want to seem ungrateful but if you’re going to add Slicers to Excel Tables – why not Timelines?

Timelines are the date/time version of Slicers which are available in PivotTables, but not, so far, for Tables.

subs profile e1563205311409 - Excel Slicers beyond PivotTables into Tables
Latest news & secrets of Microsoft Office

Microsoft Office experts give you tips and help for Word, Excel, PowerPoint and Outlook.

Give it a try. You can unsubscribe at any time.  Office Watch has been running for over 20 years, we've never, ever revealed or sold subscriber details.  Privacy policy
Invalid email address