30 Advanced Excel Tips for 2026

Excel Champs / Excel Basics / Excel Slicer – A Complete Guide to Filter Data with Slicers
By Puneet Gogia (Microsoft MVP)

Excel Slicer – A Complete Guide to Filter Data with Slicers

30+ Advanced Excel Tips for 2026

No spam. Only Excel Stuff. God Promise. 😊

One of the best ways to quickly analyze data in Excel is to use filters, and the best way to filter data is to use SLICER, period.

Slicer makes your data filtering experience a whole lot better. It’s fast, powerful, and easy to use. That’s why it is a part of our ADVANCED EXCEL SKILLS, and today in this tutorial, we will be exploring it in detail.

What is an Excel Slicer

An Excel Slicer is a bunch of buttons that you can use to filter data from a column. Unlike a standard filter, it shows you all the available items that you can use to filter as buttons. You can connect it with a table or a pivot table and customize it the way you want (Color, Font, Buttons, etc.).

Insert Slicer with a Table in Excel

To insert a SLICER in an Excel Table, use the following steps (slicers for tables need Excel 2013 or later; for pivot tables, Excel 2010 or later).

  1. First of all, press CTRL+T to convert the data (DOWNLOAD) into an Excel table, or you can also go to the Insert tab and click on Table.
  2. After that, select any of the cells from the table and then go to → Insert Tab → Slicer (click on the slicer button).
    Select any cell from the table
  3. Once you click on the button, you get a dialog box with all the column names to select from to insert a slicer.
    you have dialogue box with all the headers
  4. In the end, tick the column that you want to use as a filter (you can also tick more than one column, and Excel inserts one slicer for each) and click OK.
    tick mark the column that you want to use

Insert a Slicer with a Pivot Table

  • Click anywhere on the pivot table.
    insert a slicer with a pivot table
  • After that, go to → Insert → Slicer (or PivotTable Analyze → Insert Slicer).
    go to insert slicer
  • Select the column that you want to use in the slicer. Here we have selected zone.
    select the column that you want to use in the slicer
  • In the end, click OK.
    in the end click ok

Related: How to Link/Connect a Single Slicer with Multiple Pivot Tables in Excel

How to use Slicer in Excel

Now we will learn how to use the Slicers since we know how to insert one. We will discuss three important things now.

1. Select a Single Slicer item

This is quite simple. As soon as you insert a slicer, you click on any button to filter your data. Let’s try to understand it with a very simple example.

Here we have inserted a slicer of Zone. The blue highlighted buttons (East, North, South & West) are all selected. Therefore, you can see the data of all four regions in the pivot.

inserted a slicer of one

Now we need to filter our data for the North Zone only. Click on the North button. The data in the pivot table will automatically be filtered. As soon as you click on the North button, all the other buttons will be dimmed.

filter out data for the north zone

2. Select Multiple Items

Now, what if we need to select the data for two or more regions? Let’s say we need to filter the data for the East and West Zone. This is very easy. You just need to press Ctrl and click on the buttons you need to filter. You can also click the Multi-Select button on the slicer header (or press Alt + S) and then click the buttons one by one without holding Ctrl.

Like here we will press Ctrl and click on East & West.

filter the data for east and west zone

You can also select two or more consecutive buttons by simply clicking and dragging. Here we could have used this method if we had to select the data for East & North, North & South, or South & West.

3. Clear Selected Items

The last and most important thing is removing the filters. Once you remove all the filters, all of your data will be visible and all the buttons will be highlighted. You can do this with a single click on the Clear Filter button at the top right of the slicer (or press Alt + C when the slicer is selected).

Formatting a Slicer

Since now we know how to work with slicers, let us start with formatting.

When it comes to useful presentable reports, format plays an important role. A well-organized, eye-catching, and good-looking report will attract more audiences than others. So, it is crucial to organize and format the reports and Slicers.

1. Remove Headers

Many times, we run short of space in our reports, especially when we are making a dashboard. Do not worry if your slicer takes up more space. We can cut it short in many ways, one of which is removing the headers.

Here in our example, we know that North, East, West & South are the Zones, so we don’t necessarily need the Header “Zone”. Let us remove the header and save some space.

Select the Slicer → Right-click → Slicer Settings.

select the slicer right click slicer settings

Untick the box against “Display Header”.

untick-the-box against display header

The header is removed, and we could save some space.

the header is removed

2. Change the Font

The next thing you need to know is how to change the font of a slicer.

  • To start with, select the slicer and find the style that best suits your requirements in the Slicer Styles gallery on the Slicer tab.
  • Now, right-click that style and click on Duplicate.
    right click and click on the duplicate
  • Here the “Modify Slicer Style” dialog box will open, with a “Slicer Element” list.
    here a dialogue box slicer elements will open
  • If you closed it, right-click on the duplicate slicer style (under Custom in the gallery) and click Modify.
  • Now select “Whole Slicer” in the list and click Format.
    click on the whole slicer
  • Customize the font, borders, and fill as per your requirements.
  • Apply the new style to your slicer by clicking it under Custom in the Slicer Styles gallery.
  • Hit OK.

3. Remove Borders

Removing borders is as easy as changing the font. First, repeat the steps you did in changing the font.

  • Select the duplicate slicer style → Modify → Format → Border.
    remove borders
  • Since we want to remove borders, click on “None”.
    remove borders so click on none
  • Now hit OK.
    now hit ok

4. Remove Items with No Data

Sometimes you might find some items which are not highlighted since they do not contain any data. For example, here when I select the product “Choco”, the East and South zone buttons are not active. This means that there are no sales of “Choco” in these two zones.

remove items with no data

It is always advised to hide such buttons. Let us see how to do it.

  • First, right-click the slicer and select Slicer settings.
  • Now you will see the “Slicer settings” window.
  • Tick the box against “Hide items with no data”.
    tick the box against hide item with no data
  • Here we go.
    here we go

5. Customize Columns and Buttons

Most of the time, the slicer may not fit into your dashboard or report due to its column-type structure. Hold on!! If this is the case, then you need to know that you can organize the distribution of the buttons in a slicer.

Select the slicer → Slicer (Top Ribbon) →Buttons

customize columns and buttons

Here, increase the number of columns as per your requirement. I have increased the columns to 3, and my slicer now has three columns and is horizontally spread.

slicer now has three columns and horizontally spread

Tip: You can also adjust the height and width of the buttons from the same tab.

adjust the height and width of the buttons

6. Customize Size

If you do not want to spend more time formatting the buttons or are not interested in playing with the columns and button sizes, all you need to do is adjust the dimensions of the slicer using the Size option.

customize size

You can also use the mouse, but you need good control over it. To avoid all this mess, simply select the slicer → Slicer (Top Ribbon) → Size. Here you can adjust the height and width of the Slicer as a whole. You do not need to play with each element.

7. Rename a Slicer

What if you want to rename a Slicer or put a small description in your Slicer header?

rename a slicer

You can do this with a single click. Select the slicer → Slicer (Top Ribbon) → Slicer Caption

select the slicer caption

8. Align Slicers

The next important thing that you need to learn is alignment. When you have multiple slicers, it is always advised to align them for a better presentation. Select all the slicers → Slicer (Top Ribbon) → Arrange → Align

select the slicer s arrange assign

Here you have several options that are useful when you have more than one slicer (Distribute Horizontally and Distribute Vertically need at least three). Most of the time when you insert the slicers, they are cascaded over each other.

cascaded over each other

They are not distributed well. To arrange them well in your report or dashboard we have a quick fix called Align.

Align: This option helps you to line up all your slicers to the left, center, right, top, middle, or bottom. You need to decide where you want to place your slicers.

  • First, select all the slicers.
    select all the slicers
  • After that click on Align Top.
    click on align top
  • All the slicers will have a common start point from the top.
  • Now select the rightmost slicer and drag it to the right side. Here you need to think of the approximate space all your slicers will be needing.
  • Here again, select all the slicers and click on distribute horizontally. Sometimes you might have to click this multiple times to adjust the spaces between the slicers.
    select the most right slicer

Similarly, you can distribute your slicer vertically.

Snap to Grid and Snap to Shape: In case you are running short of time and have multiple shapes In your report or dashboard, all you need to do is select all the slicers and turn on Snap to Shape (or Snap to Grid) under Arrange → Align. They are two separate options, and you can turn on one or both.

  1. Snap to shape helps you to adjust your shape to the other shapes in your report or dashboard.
  2. Snap to grid adjusts your slicer or shapes to the cell gridlines of the worksheet.

Connect One Slicer to Multiple Pivot Tables

A slicer can filter more than one pivot table at once, as long as the pivot tables use the same data source. Select the slicer, go to Slicer → Report Connections, and tick the pivot tables you want it to control. You can find all the steps in this tutorial.

Slicer vs Filter

  • What you see: a slicer shows every item as a button and what’s filtered at a glance, while a filter drop-down hides the selection inside the menu.
  • Conditions: a filter can do “greater than”, “contains” or date ranges; a slicer only selects items (use a Timeline for date ranges in a pivot table).
  • Where it works: slicers work with Excel tables and pivot tables, not with a normal range.

Frequently Asked Questions

Why is the Slicer button greyed out?

The active cell isn’t inside a table or a pivot table, or the workbook is in the old .xls format. Click inside the table, or save the file as .xlsx and try again.

How do I delete a slicer?

Select the slicer and press Delete. Clear its filter first (Alt + C) if you want the data to show all items again.

Can I stop users from moving a slicer?

Yes. Right-click the slicer → Size and Properties, and under Position and Layout, tick “Disable resizing and moving”.

Puneet Gogia

Written by

Puneet Gogia

Microsoft MVP — Excel · Founder, Excel Champs

Twelve years of teaching Excel, and a decade before that using it as a data analyst. Every tutorial here is written from a file I actually built.

3M+ readers helped
1,000+ tutorials written
Since 2015 teaching Excel

Leave a Comment