Course Content

Course Content

Description

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.

FAQs

Recommended Courses

Share With Friend

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

Download The Apps

Code Scan or Download the app
Google Play Store
297K+ Downloads
4.5 Rating
10K+ Reviews
  • 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