Quick Way to Insert Slicers in Excel Worksheets

Bottom Line:  Learn a quick time-saving tip for inserting slicers and see the advantages of this way over other methods.

Skill Level: Intermediate

Watch the Tutorial

Watch on YouTube & Subscribe to our Channel

Insert Slicers Quickly

There are several ways to insert a slicer into your Excel worksheet, but my preferred way is through the built-in Pivot Table fields list.

What is a slicer?

A slicer is a tool that allows us to filter a report by simply clicking any of the items listed in the slicer. It's basically a custom menu of filtering buttons, and can be used for charts, tables, or Pivot Tables.

What is a slicer?

My Preferred Method

The best method (IMHO) for inserting a slicer is to use the pivot table fields list in the right-hand task pane. By right-clicking on any field in the list, you will bring up a menu that includes the option to Add as Slicer.

Add slicer by right clicking in the fields list

I like this method because the fields list has a search box, so you can easily find the field you want a slicer for. This is super useful when you have a really long list of fields to look through.

Search box in Pivot Table Fields list

Other Ways to Add Slicers

A couple of other ways to add slicers to your worksheet include:

Using the Insert Tab

You can go to the Insert tab and select the Slicer button on the Ribbon.

Slicer button on Insert tab

This option doesn't have a search box, so you have to scroll through the list to find the fields you want.

Using the PivotTable Analyze Tab

You can also bring up the same fields list by going to the PivotTable Analyze tab. (In some versions this is called the PivotTable Options tab.) Then choose the Insert Slicer button. You have to start with any cell in the Pivot Table selected in order to access that tab.

Slicer button on Analyze tab

Again, there is no search feature using this method. One advantage of using the Insert Slicers window is that you can select multiple fields for simultaneously inserting several slicers.

More About Slicers

If learning more about using slicers interests you, I recommend these three posts.

I hope this quick tip is helpful for you! Leave a comment below with any questions or feedback you might have.

  • Thank you Jon,
    Enjoy your wonderful work.
    Just wondering if you have anything on working with dates prior to 1900? Cheers Delville

  • Search
    Generic filters
    Exact matches only

    JOIN US & LEARN EXCEL

    Learn 10 great Excel techniques that will wow your boss and make your co-workers say, "how did you do that??"
    Plus weekly updates to help you learn Excel.

    Download the eBook

    Excel Shortcuts List

    keyboard shortcuts list banner

    Learn over 270 Excel keyboard & mouse shortcuts for Windows & Mac.

    Excel Shortcuts List

    Join Our Weekly Newsletter

    The Excel Pro Tips Newsletter is packed with tips & techniques to help you master Excel.

    Join Our Free Newsletter

    About Me

    Jon Acampora Profile

    Hello and welcome! My name is Jon Acampora and I'm here to help you learn Excel.

    This blog is updated frequently with Excel and VBA tutorials & tools to help improve your Excel skills and save time with your everyday tasks. Subscribe above to stay updated. More about me...

    MVP_Horizontal_BlueOnly

    Free Excel Training Webinar Modern Power Tools

    >