How to Create Slicers in Microsoft Excel

 

Make a Slicer in Microsoft Excel

To start the slicer-making process, first, open your spreadsheet with Microsoft Excel. Then click the table in which you want to filter data using a slicer.

While your table is selected, in Excel’s ribbon at the top, click the “Insert” tab.

On the “Insert” tab, in the “Filters” section, click “Slicer” to add a slicer.

You’ll see an “Insert Slicers” window displaying your table’s fields. Here, choose the fields which you want to filter using a slicer, then click “OK” at the bottom.

Excel will add a slicer for each selected field. To start filtering your data, select an option in one of these slicers and the data in your table will adjust accordingly.

Tip: If you’d like to apply multiple filters in a single slicer, you can select multiple options by holding down the Ctrl (Windows) or Command (Mac) key.

To reset a slicer’s filter, then in that slicer’s top-right corner, click the “Clear Filter” option.

And that’s it.

Customize a Slicer in Microsoft Excel

Slicers can be customized to use a specified color or size. You can also drag and drop slicers to place them wherever you want on your screen.

To access your slicer’s personalization options, first, choose a slicer in your spreadsheet. Then in Excel’s ribbon at the top, click the “Slicer” tab to access all customization options.

You’ll now find various options to change how your slicers look in your spreadsheet. For example, to change your slicer’s color, you can pick a new color scheme from the “Slicer Styles” section.

Similarly, to resize your slicer, you can use the “Height” and “Width” boxes at the top. Another way to resize a slicer is to click it and then drag its dot icons.

Once you’ve customized your slicers, don’t forget to save your spreadsheet to keep your changes. And you’re all set.