Home » Excel Tutorials » Learn Excel – How to Use Slicers to Filter data in Excel?

Learn Excel – How to Use Slicers to Filter data in Excel?

In the previous post, we saw ‘How to Total the Data in an Excel Table?’, now we will learn about how to use slicers to filter data in the Excel table?

Where to Find The Slicers Option?

This option will be activated after you click on it anywhere in the table- to find this option click on the ‘Design’ tab [the design tab will be visible only when you click on the table] after that under the Tools group click on the option ‘Insert Slicer’.

Note: Click on the image

Excel insert slicer option in table, excel

OR

Click anywhere on the table and click on the ‘Insert’ tab under the filters group click on the ‘Slicer’ option

Note: Click on the image

Excel insert slicers via insert tab in excel table, slicers

Slicer is like a button with the help of that you can filter data.


Create a slicer to filter data

Using the same example, let’s create a slicer filter

1.Click anywhere in the table

2. The design tab will be activated, click on the design tab under the tools group click on the Insert Slicer or click on the Insert tab under the filters group click on the ‘Slicer’ option.

In the Insert Slicers dialog box, select the check boxes for the fields you want to display, then select OK.

Note: Click on the image

Insert slicer, excel, learn excel,- EduTaxTuber

Notes: 

  • If you want to select more than one item, hold Ctrl, and then select the items that you want to show.
  • To clear a slicer’s filters, select Clear Filter in the slicer.

Insert Slicer Using Shortcut Key

To insert slicer using shortcut key click anywhere in the table and press ‘ALT + N + SF’ [Shortcut key may be different just follow the key after pressing ‘ALT’ key].

Note: Click on the image

Insert slicers in excel table using shortcut key- EduTaxTuber

Also read other articles @ EduTaxTuber

How to Apply Filter in TallyPrime: CTRL + F
How to Apply Filter in Tally Prime: CTRL + F: In previous article we learned about "How To Create Multiple Ledgers in Tally Prime?" Now we will explore about how we can apply filter in Tally, and If you want to …
How To Create Multiple Ledgers in Tally Prime?
In this article, we will discuss that how we can create multiple ledgers in Tally Prime. If we create multiple ledgers then we can save our time on the other hand If we create a single ledger then it will …

If you want to make the lower case, The Excel LOWER function Converts all uppercase letters in a text string to lowercase. It ignores space, numbers, and punctuation. Visit this link – Excel LOWER Function.

The Excel PROPER function Capitalizes the first letter in a text string and any other letters in the text that follow any character other than a letter. It Converts all other letters to lowercase letters. Visit this link – Excel PROPER Function

Create TDS Nature of Payment

From the gateway of Tally press “C” then select “TDS Nature of Payments” under the Statutory Masters and press Enter. OR Press “ALT + G” select Create Master press Enter and select “TDS Nature of Payment” under the Statutory Masters and hit the enter button.

How To Check PM- Kisan Samman Nidhi Yojna Beneficiary Status

In this article we will see in detail how to check “PM- Kisan Samman Nidhi Yojna” beneficiary status i.e. whether money is received or not. You can check it Online. You can check in three ways i.e using 1. Aadhar Number, 2. Bank Account Number, and 3. Mobile Number.…. Read More

For Latest Updates & Learning Join Our YouTube Channel: Join Now

Leave a Reply

Scroll to Top