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

• Share on Facebook
• Share on Twitter
• Share on Pinterest
• Share on LinkedIn
• Share via Email
• Share on Tumblr
• Share on Reddit

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

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

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

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

---

Also read other articles @ EduTaxTuber

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