How To Insert Slicer In Excel

To insert a slicer in Excel, go to the “Design” tab in the Excel ribbon, click on the “Insert Slicer” button, select the desired fields to include in the slicer, and confirm the selection.

Excel is a powerful tool that offers a wide range of features to help professionals in their data analysis and decision-making processes. One such feature is the ability to insert slicers, which can greatly enhance the overall usability and efficiency of your Excel workbooks. Slicers provide an easy and intuitive way to filter and interact with data, allowing you to slice and dice information with just a few clicks. In this blog post, we will explore how to insert slicers in Excel and take advantage of this handy tool to streamline your data analysis. Whether you are a beginner or an experienced Excel user, this guide will walk you through the steps to utilize slicers effectively and maximize the potential of your data. So, let’s dive in and uncover the world of slicers in Excel!

How To Insert Slicer In Excel: Step-by-Step


Step 1: Select Your Data,

After opening your Excel spreadsheet, select the specific data you want the slicer to filter by clicking and dragging your cursor over it.

Next Step

Step 2: Insert the Pivot Table,

After selecting your data, create a new Pivot Table by clicking on “Insert” in the top menu bar, followed by selecting “Pivot Table”. This will generate a table based on your chosen data.

Next Step

Step 3: Confirm Your Selection,

A prompt will appear, giving you the option to confirm your data selection and choose the desired location for the Pivot Table. Simply click on “OK” to proceed with the selection and placement process.

Next Step

Step 4: Create your Pivot Table,

Once you have accessed the Pivot Table Fields pane, simply check the boxes next to the desired data to be included in the summary. By doing so, a comprehensive summary of the selected data will be generated.

Next Step

Step 5: Insert the Slicer,

By clicking on any cell in the Pivot Table, you can activate the Pivot Table Tools tab in the top menu. From there, accessing the “Analyse” or “Options” tab will reveal the ‘Insert Slicer’ or ‘Slicer’ button in the ‘Sort & Filter’ group.


In conclusion, learning how to insert slicers in Excel can greatly improve your data analysis and visualization skills. Slicers provide an intuitive and user-friendly way to filter and manipulate data, making it easier to identify patterns, trends, and insights. Whether you are working with large datasets or creating dynamic reports, slicers offer a powerful tool to enhance your Excel experience. By following the simple steps outlined in this blog post, you can start leveraging the power of slicers and take your Excel proficiency to the next level. So why wait? Start using slicers in Excel today and unlock the full potential of your data.

Table of Contents