How to use slicers in Microsoft Excel 2010 to effectively filter data

RECOMMENDED: Click here to fix Windows errors and optimize system performance

Microsoft Excel 2010 Slicers are easy-to-use visual controls that allow you to quickly and easily filter data interactively by selecting values from a list. The slicer function provides the user with a rich visualization of the pivot table, on which dynamic segmentation and filtering can be applied to display the required data. The search filter considerably reduces the time required to search for a record in the large record.

KeyTips to get a sharp edge in Excel 2010 : Alt + N + SF

Slicer is under the tab Insert in ribbon. A slicer functions as a report filter, so you can connect it to a PivotTable, PivotChart or CUBE function to filter it and create an interactive report.

February 2021 Update:

We now recommend using this tool for your error. Additionally, this tool fixes common computer errors, protects you against file loss, malware, hardware failures and optimizes your PC for maximum performance. You can fix your PC problems quickly and prevent others from happening with this software:

  • Step 1 : Download PC Repair & Optimizer Tool (Windows 10, 8, 7, XP, Vista – Microsoft Gold Certified).
  • Step 2 : Click “Start Scan” to find Windows registry issues that could be causing PC problems.
  • Step 3 : Click “Repair All” to fix all issues.


In the example below, there is a slicer in three different countries. One or more or all countries can be selected. This would reflect a filtered amount of data based on the number of countries selected.

On the other hand, selecting a tile in a slicer in Excel 2010 is easy – just one click. To select multiple tiles, use the Ctrl+Click, Shift+Click, or Click+Drag combinations.

Use slicers to create your reports invites interaction and allows you and your staff to spend less time watching and more time analyzing. Slicers also works with Excel Services 2010 and Excel Web App, allowing you to work and share on the Web.

RECOMMENDED: Click here to troubleshoot Windows errors and optimize system performance

Related Video