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.
We can create a slicer in MS Excel by following these steps:
Have a friend to whom you would want to share this course?