How to Apply Filter in Excel | Excel Tips & Tricks

Applying filter in excel data helps you to display records that meet certain criteria. In this video i have shown how to use filter in excel using shortcut keys
------------------------------------------------------------------------
𝗝𝗼𝗶𝗻 𝗺𝗲 𝗼𝗻 𝗦𝗼𝗰𝗶𝗮𝗹 𝗠𝗲𝗱𝗶𝗮:🔥
-------------------------------------------------------------------------
🔆Instagram :
/ itjunction4all
🔆 Twitter:
/ sunilkr5672
-------------------------------------------------------------------------
#ExcelFilter #ExcelTricks #ExcelTips #Sunil #ITJunctionAll

[@Traveller687]

Thank u sir, i was in my office doing work in excel, my sir asked me apply filter in data and went in his cabin. I came to washroom and found ur video

[@ItJunction4all]

You are welcome! I am glad that my video is helpful for you ❣️

[@ItJunction4all]

You are welcome! I am glad that my video is helpful for you ❣️

[@Ankita6335]

Yeah true🤣🤣

[@vibhishnagul]

This was too quick . Thanks for the valuable content.

[@ItJunction4all]

You are welcome 🤗

[@AnkitKamli]

Thanks for good information, but is it possible to use filters in merged cells?
And also, is it possible to undo or completely remove ascending descending orders and vice versa from a row?

[@choudhuryrahul575]

Great & many many thanx. Post more videos like this & especially on vlookup & hlookup with shortcut keys.

[@ItJunction4all]

Thank you 😍 Sure will do that.

[@rskmgmt3662]

thank you sir it helped alot

[@ItJunction4all]

You are welcome!

[@Chloedahel]

This save my job hhahah thank you

[@ItJunction4all]

You are welcome 🙂

[@SankhlaGaming]

Sir filter k andar jo cheej filter lagai h use pahle jaisa karne k liye kya shortcut hoga without remove filter

[@ItJunction4all]

Hi Sankhla...I am not aware of that shortcut.

[@SankhlaGaming]

@@ItJunction4all but I know Alt+H+S+C

[@SankhlaGaming]

@@ItJunction4all thanks you sir for reply

[@anishabegum4095]

Thank you so much brother

[@ItJunction4all]

You are welcome !

[@benkehoe4878]

Thank u so much short and to the point!! Just what I needed

[@ItJunction4all]

You're welcome!

[@moinsyed6453]

Excellent 👍

[@ItJunction4all]

Thank you 😊

[@chazzycake3603]

Thank you!

[@ItJunction4all]

You are welcome 🤗

[@jamesperry3837]

Thanks! That's a useful tip.
*R U using Windows 365 ?*

[@ItJunction4all]

You are welcome! No I m not using windows 365

[@jamesperry3837]

@@ItJunction4all wat version of Excel R U using sir ?

[@ItJunction4all]

@@jamesperry3837 I am using Microsoft Office Professional Plus 2016

[@jamesperry3837]

Thank you!

[@bhawarrathore887]

it's best tips 👍👍

[@ItJunction4all]

Many many thanks... Plz subscribe my channel for future video updates

[@uniqueeducationalchannel9731]

Thanks Sir 😊

[@ItJunction4all]

You are welcome 🤗

[@fresherkaexperience8086]

Thanks

[@ItJunction4all]

You're very welcome!

[@stardust9207]

Thank you

[@ItJunction4all]

You are welcome 🙂

[@hemajagan4398]

Alt+D+ F+ F is also appling Filter

[@ItJunction4all]

Thanks Hema Jagan for letting us know alternate short cut for applying filter

[@PRAMOD23442]

Thanksgiving for more details

[@ryadav5032]

Sir filter ko bar bar open krna pdhta hai.... Uska short cut key kaise bnaye?

[@chandrashekharprasad9869]

Good tips

[@ItJunction4all]

Thanks !

[@kishoresameena9032]

In Excel file how to change a text mode for typing

[@ItJunction4all]

I didn't understand your question

[@snehlata2305]

👌

[@ItJunction4all]

Thanks

[@dhananjaypawase8643]

In hp laptop same is not applicable pls tell me

[@ItJunction4all]

In all laptop...this should work

[@spiderman__xd_8140]

Thx

[@ItJunction4all]

Welcome !

[@idaaaaaaaaa]

if you want to change for eg: LDR145too a running numbers from LDR1 to LDR145?is there a way to custom filter that?

[@ItJunction4all]

I didn't understand your question. Can you please elaborate more ?

[@idaaaaaaaaa]

@@ItJunction4all in the excel only numbers can be like in the running number from for example(1-20)..But if the number are connected with alphabet like= LDR123 i can’t make the numbers running in the correct order..Because in my info given is not in the right order so i have to change it in a faster way right? how do i adjust the numbers in the correct order? im sorry idk how to explain😭

[@champion_liban]

Why do we apply filter in excel?

[@ItJunction4all]

When data is filtered, only rows that meet the filter criteria will display and other rows will be hidden.

[@abhayshankar5690]

How to get search option in filter.. Please tell

[@ItJunction4all]

After applying filter, click on applied column filter. You will get option of search.

[@sagarjagtap45]

Alt+D+F+F

[@ItJunction4all]

You mean this is another way by which we can apply filter in Excel

[@sagarjagtap45]

@@ItJunction4all yes

[@SaketR0y]

Thanks

[@ItJunction4all]

You are welcome

[@anitagiri_]

👌

[@ItJunction4all]

Thanks Anita Giri !

[@A7mad1989]

Thanks

[@ItJunction4all]

You are welcome 😍

[@omarjamaabdilahi9204]

Thanks

[@ItJunction4all]

Welcome OMAR JAMA ABDILAHI !