Excel Slicers are the best thing since sliced bread!
They are a new feature from Excel 2010 onward and Mac for Excel 2016 and are visual buttons that shows you what items have been filtered or selected in a Pivot Table.
There are several ways that you can filter an Excel Slicer. Download our workbook so you can practice:
Table of Contents
LEFT MOUSE CLICK:
DRAG LEFT MOUSE BUTTON:
You can select an array of items by clicking the left mouse button and doing a dragging motion downwards/upwards within the Slicer;
You can select multiple items by holding down the CTRL key on your keyboard and selecting the Slicer items with your left mouse button;
Select a Slicer item, hold down the SHIFT key on your keyboard and then select another Slicer item. This will select a range of items!
Different Ways to Filter an Excel Slicer: