How to use Excel Filter on Text Number Date - Filter by Color AutoFilter Shortcuts

Filter or AutoFilter in Excel provides a number of advanced tools that can help you filter specific data types such as text, numbers and dates exactly the way you want.

Let's have a closer look at each option and see how you can create a filter most suited for your data type. Create filter by Ctrl+Shift+L shortcut from keyboard.

In the filter drop down you will find one menu Text Filters and within this menu you will find some sub-menus also like Equals, Does not Equals, Contains, Does not Contains etc., as shown in the below image. These filters are advanced level filtering method and if you need specific filtered data, you can use these filter options. I shall discuss most of it.
These videos are supportive to Blog "Excel Solutions : Basic and Advanced", advanced-excel-solved.blogspot.com, please visit for more information and ready references.
If you want to know more about Microsoft Excel Magical Tricks and download my working excel files then please follow my Blog and comment, ask your questions & problems. Feel free to comment and click likes. Please Share Like and Comment in my Videos. Thank you ...