Course Content

Course Content

Adding Slicers in MS Excel

How to add Slicers in MS Excel

Now we will understand the important feature of pivot table that is Slicers.

Suppose if we add any particular category in our filter section, then in our pivot table on top there will be one category added, and then when we try to select multiple category we do not get it in proper understandable way.

If we want to check properly that what is being shown in pivot table, then we use Slicer.

Slices is located in analyze column of pivot table tools. We can see an option of 'Insert Slicer', when we click it, it will ask us that for what things we want slicer to add. Then when we select the things which we want, we will see the slicers of them appeared on our screen.

Slicers has one main drawback that is they cover a lot of area on our screen. So for that we can arrange our slicers size according to our need.

Now whatever data we want to see we can select them accordingly from slicers.

To remove slicers we can use 'clear filter' button on the top left corner of the slicers.

To completely remove slices from screen free will first ensure that no filter is ON, and then select the particular slicer and press 'Delete' key from our keyboard.


A slicer is a type of filter that can be applied to data in Excel. It allows the user to easily sort and filter data without having to use complex formulas or VBA code.


  • Slicers can help you find information quickly
  • They allow you to compare different datasets
  • They save time by automatically filtering your dataset for you

Slicers are a type of filter that allow users to quickly and easily filter data in Excel. They are very useful when you need to filter a large amount of data by one or two criteria which may be difficult to find on the spreadsheet.

We can create a slicer in MS Excel by following these steps:

  • Select the data you want to slice from the table, and then go to Insert > Slicer.
  • Drag the fields you want to see in your slicer into the white box on top of the screen.
  • Click Ok.

Slicers make filtering data in a pivot table a breeze. Click the Insert Slicer command (and then select Insert Slicer in Excel 2007/2010) on the PivotTable Tools Analyze tab (PivotTable Tools Options tab in Excel 2007/2010), in the Filter group (Sort & Filter group in Excel 2007/2010).

Recommended Courses

Share With Friend

Have a friend to whom you would want to share this course?

Download LearnVern App

App Preview Image
App QR Code Image
Code Scan or Download the app
Google Play Store
Apple App Store
598K+ Downloads
App Download Section Circle 1
4.57 Avg. Ratings
App Download Section Circle 2
15K+ Reviews
App Download Section Circle 3
  • Learn anywhere on the go
  • Get regular updates about your enrolled or new courses
  • Share content with your friends
  • Evaluate your progress through practice tests
  • No internet connection needed
  • Enroll for the webinar and join at the time of the webinar from anywhere