However, instead of drop-down menus, they provide large friendly buttons that are always visible.

If we wanted to filter the entire pivot table by region, we know from an earlier video that we could just add region as a Report Filter, and use it to filter as needed.

Then click the Insert Slicer button and select a field from the field list.

Note that the pivot table immediately filters on that item and the Region drop-down displays the filter icon.

If we check the filter settings for region, you can see that the slicer had the same effect as manually filtering.

You can also use the shift key to enable all items between two buttons.

If we add Region as a column label, then filter on that field, the slicer responds as well.

Lets add Category as a row label above Product, then add another slicer for Category.

We can remove both category and region from the pivot table, and the slicer continues to function normally.

My heart sank when I looked at a multi-line cell realised I needed each line in a separate column.

Worked a charm. Yes, I could have done it other ways but all of them would have been so much longer.

I sorted your method out in less time than it took me to send you this email.

Slicer For Mac Excel 2011