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

2 minutes, 31 seconds Read

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 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 …
TallyPrime: Important Shortcut Key ALT + G or GO To
In this article, we will discuss the new and unique shortcut key ALT + G or GO To in the TallyPrime. With the help of the ALT + G shortcut key, you can navigate in tally anywhere. ALT + G …

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

author

EduTaxTuber Team

We are here to help for every updates related to everything...👍📙👍📗

Similar Posts

Leave a Reply