Pinterest Pixel

Different Ways to Filter an Excel Slicer

John Michaloudis
Excel Slicers are the best thing since sliced bread!
Different Ways to Filter an Excel Slicer | MyExcelOnline Different Ways to Filter an Excel Slicer | MyExcelOnline

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 workbookFiltering-a-Slicer.xlsx

LEFT MOUSE CLICK:

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

 

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

 

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

 

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

 

 

Different Ways to Filter an Excel Slicer:

 

5 Speedy Steps To An Excel Pivot Table! (infographic)

If you like this Excel tip, please share it
Founder & Chief Inspirational Officer at

John Michaloudis is a former accountant and finance analyst at General Electric, a Microsoft MVP since 2020, an Amazon #1 bestselling author of 4 Microsoft Excel books and teacher of Microsoft Excel & Office over at his flagship MyExcelOnline Academy Online Course.

See also  Insert Subtotals to a Pivot Table

Get Video Training

Advance your Microsoft Excel & Office Skills with the MyExcelOnline Academy!

Dramatically Reduce Repetition, Stress, and Overtime!
Exponentially Increase Your Chances of a Promotion, Pay Raise or New Job!

Learn in as little as 5 minutes a day or on your schedule.

Learn More!

Share to...