Skip to content

Add Slicers to Your Table

If you’ve worked with Excel tables before, you are probably familiar with the ability to filter the table using the filter button near the top.

Filters are amazing and can go a long way in making it easy to analyze your table data. However, there is an even faster way you can filter your table data.

Introducing the Table Slicer

A slicer in Excel is essentially a box with buttons that you can use to filter data.

Slicers are typically taught and referred to when working with pivot tables, but they can work with your normal tables too.

Slicers are nice because you can move them around and position them anywhere you want on your worksheet. On top of that, once you click one of the buttons, the slicer will immediately filter the data of whatever table it’s connected with.

How to Add a Slicer

Now that you know how useful a slicer can be, how do you add one to your Excel table?

You can add a slicer to a table by following the steps listed below.

First, select any cell in the table to which you want to add a slicer.

Second, in the Excel ribbon, go to Insert and then click on Slicer.

Third, select which column you want a slicer for and then click on Ok. You can now move and position the slicer wherever you’d like.

How to Customize Your Slicer

Another nifty feature of slicers is that you can customize and change their appearance.

To customize a slicer, select that slicer and click on the Slicer tab in the ribbon.

Then, under slicer styles, you can select a new style for your slicer, or you can even create your own.

As you can see, Slicers offer some pretty nifty advantages when working with tables. So the next time you need a quick and efficient way to filter your table, use a slicer.

This Post Has One Comment

  1. This is so cool! I knew you could do this with pivot tables, but not with just normal tables. I also didn’t know you could customize the look! This is going to be something fun to play around with and use!

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Back To Top