CTRL + SHIFT + L: Apply Filter in Excel

1 minute, 24 seconds Read

CTRL + SHIFT +L: Do you know what is the use of this shortcut? If you know this then write your reply in the comment box. It is related to filter in excel.

It can be difficult to find information quickly if your worksheet contains a lot of content. Excel Filter, is used to narrow down the data in your worksheet so that you only see what you need.

How do you Apply Filter in Excel?

Normally you will select the data and go to the “Home” tab under the editing section in “Sort & Filter” click on the “filter” option from the dropdown menu as shown below:

Excel filter: CTRL + SHIFT + L
Excel Filter: CTRL + SHIFT + L

Or you can go to the “Data” tab under sort & filter section click on the “filter” as below shown


this is the basic and long way to do but you should first learn the longcut and then move on the shortcut, it will help you to understand in a better way.

Learn Tally Free…

How to Record TDS Entry in Tally?

In the previous post, we saw ‘How to create TDS Nature of Payment and TDS Ledgers?’, now we will see how to record TDS entry in Tally? How to Record TDS Entry in Tally? Record TDS on Purchases For example we want to purchase software for our office use so let’s see steps to record entry: 1. First Create ‘TDS…

Press CTRL + SHIFT + L

When you select the data and press “CTRL + SHIFT + L” you will see the filter will be applied to your data as below shown:


If you follow the above step you can easily apply filter using the keyboard shortcut ” CTRL + SHIFT + L”, it will save your lot of time.

Watch the Video to apply filter

Apply filter in your data and excel filter shortcut

We hope that you like the content and if you found it useful share it with your family and friend. If content is not as per your expectation or if you want to report the above content then write a mail Contact@edutaxtuber.in

EduTaxTuber Team

EduTaxTuber Team

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

Similar Posts

Leave a Reply