Different Ways to Filter an Excel Slicer | MyExcelOnline

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:

Different Ways to Filter an Excel Slicer | MyExcelOnline

DOWNLOAD EXCEL WORKBOOK

LEFT MOUSE CLICK:

You can select items from the Slicer by using your left mouse button;Different Ways to Filter an Excel Slicer | MyExcelOnline

 

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;

Different Ways to Filter an Excel Slicer | MyExcelOnline

 

CTRL KEYBOARD:

You can select multiple items by holding down the CTRL key on your keyboard and selecting the Slicer items with your left mouse button;

Different Ways to Filter an Excel Slicer | MyExcelOnline

 

SHIFT KEYBOARD:

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 | MyExcelOnline

 

 

Different Ways to Filter an Excel Slicer:

 

HELPFUL RESOURCE:

Different Ways to Filter an Excel Slicer | MyExcelOnline

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

Different Ways to Filter an Excel Slicer | MyExcelOnline