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:

DOWNLOAD EXCEL WORKBOOK

LEFT MOUSE CLICK:

You can select items from the Slicer by using your left mouse button;

 

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;

 

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;

 

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:

Filtering a Slicer

HELPFUL RESOURCE:

If you like this Excel tip, please share itEmail this to someone

email

Pin on Pinterest

Pinterest

Share on Facebook

Facebook

Tweet about this on Twitter

Twitter

Share on LinkedIn

Linkedin

Share on Google+

Google+

Related Posts

5 Speedy Steps To An Excel Pivot Table! (infograph... G'day All, In this free downloadable Excel Pivot Table Cheat Sheet/Infographic, I show you how easy it is to create an Excel Pivot Table in 5 Speedy Steps...Enjoy and please comment below if you have any Excel or Pivot Table questions, I'm here to help you 🙂 DOWNLOAD ...
Pivot Table Number Formatting You can easily format your Pivot Table values simply by Right Clicking on a value and choosing Number Format.  Then you can choose from the many different formats, like Number, Currency, Percentage or Custom. DOWNLOAD EXCEL WORKBOOK   STEP 1: Right click in the Pi...
Show the Difference From Previous Month with Direc... Using a Pivot Table you can show the variance from your previous month's sales very easily... See how to Show The Difference From Previous Months With Excel Pivot Tables here Now that we have the Pivot Table report above, we can show the variances per month using an up/...
Color Scales in a Pivot Table Color Scales are new in Excel 2010 and they highlight the smallest and largest data points within your Pivot Table. It works like a heat map, in that it gives the highest number a shade of color and the lowest number a different shade of color, so your numbers can stand out at...