Excel Tables are very useful in managing and analyzing data in tabular format. An Excel Table provides the data in a special structure, which comes with filtering, formatting, and sizing, and can also auto populate formulas dynamically. An Excel Table contains down-arrows near headers of each column by default, that can be used to filter down the table results. In this guide, we're going to show you tips for Excel Table Slicer.

What is a slicer?

A slicer is essentially a customizable filter that can narrow down results, and indicates which values are filtered and which are not. Although slicers were introduced along with Pivot Tables, Excel Table can use them as well.

How to add

  1. Click on a cell in your table
  2. Open the Design tab
  3. Click Insert Slicer
  4. Mark the column names you want to filter
  5. Click OK

How to use

Click on the items (buttons) in the slicer panels. Each individual click changes the filter value. Additionally, you can use Ctrl and Shift buttons to make multiple selections.

If you use two or more slicers, each slicer will show any existing filters. For example, in the screenshot below II is selected in the slicer named Generation. The slicer named Type displays unavailable items as light blue to indicate user. If you click on a light version item, the table doesn't show any rows because filters conflict between each other.

Styling Slicers

To customization options:

  1. Click on the slicer you want to modify
  2. Activate the Design tab (in 2016 and later) or Options tab (in 2010 and 2013) in the Ribbon

Aside from generic object properties like width, height, or alignment; you can change slicer's name, color scheme, order of the items or how many columns it has.