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.


Insert Slicer in Excel is a powerful tool that will help you create your own slicers. It helps you take information from a Pivot Table and create a slicer. Slicers are floating toolbars that give you quick access to the most useful information in your PivotTable. To create a slicer, select the PivotTable fields for which you want to create a slicer, then click "Insert Slicers" on the Analyze tab. Insert Slicers allows you to quickly filter and view data in a pivot table. Just click the Insert Slicers button, select the fields for which you want to create a slicer, and then click Save.

Excel has a lot of tools that can help you analyze data and prepare data-rich spreadsheets. One of those tools is a slicer. A slicer is a tool that allows you to select rows from a dataset for analysis. Excel calls it "slicing" or "dragging." You can use slicers to sort, filter, and highlight information from your spreadsheet quickly.The main benefit of a slicer is that it can help you find the content you are looking for from a large amount of data. With this tool, you can see what content is popular and relevant in any niche or topic. Whether your product is in fashion or food, there is a good chance that people in your target audience will be interested in the products and information that they offer. This is exactly what a slicer will help you discover.

Many Excel users are wondering about this question due to the advent of Microsoft Office 365. This has pushed many users to explore alternatives to Pivot Table. However, there are some limitations that you should be aware of before trying this. Pivot tables are built by aggregating data in rows and columns or filtering out data in rows and columns. It is not possible to use it on the slicer options of Excel because it does not have a slicer option. This means that you cannot filter data on any table except for the ones that have slicers, which mostly include financials and pivot tables. Microsoft Excel includes a tool that can slice data in several ways. The slicer is a way to visualize data in sequential blocks.A slicer works by creating a horizontal line for each value in your spreadsheet. Then, you enter the values for your data on the left side of your spreadsheet and place them under each line to give it meaning. You can use conditional formatting on these values to show shading or change their color depending on what you want to see for your category, month, or year.

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
297K+ Downloads
App Download Section Circle 1
4.5 Rating
App Download Section Circle 2
10K+ 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