How to Create Slicers in Microsoft Excel - - Windows Tips and Tricks with Geek

Friday, February 25, 2022

How to Create Slicers in Microsoft Excel

 Microsoft Excel logo on a green background.

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.

Select the "Insert" tab at the top.

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

Choose "Slicer" on the "Insert" tab.

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.

Select fields and click "OK."

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.

Filter data with slicers in Excel.

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

Select "Clear Filter" at the top-right corner of a slicer.

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.

Access the "Slicer" tab.

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.

Choose a color from "Slicer Styles."

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.

Drag the corners to resize the slicer.

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

No comments:

Post a Comment