Author: Oscar Cronquist Article last updated on November 05, 2018

Slicers let you control data displayed in a chart, simply click on a button to quickly filter data.

How to add a slicer

You need to convert your data into an Excel defined table before you can add a slicer.

  1. Select a cell in your data set, this is needed so Excel knows which data you want to convert.
  2. Press and hold CTRL then press T, release all keys.
  3. A dialog box appears.
  4. Click "OK" button.

Now finally we can add a slicer.

  1. Go to tab "Insert" on the ribbon.
  2. Click a cell in the Excel defined table.
  3. Click the "Slicer" button on the ribbon.
  4. Another dialog box appears, select the checkboxes corresponding to the values you want to filer.
  5. Click "OK" button.