How to Auto Filter in Excel

[Lanka Boy]

While working with excel I was trying to make the Auto Filter to be work in excel, but however I can’t able to do that in Excel, I have read the entire manual and make the use of the Help option to know about this Auto Filter but not get the proper solution, I can't find simple instructions on how to Auto Filter. Please help

[QUENBY]

According to my information you just have to make the use of the Data Tab, on the Data tab you can turn AutoFilter on and off. This is the simple way to make the working of Auto Filter in Excel

[Leanne]

This is simple in Excel to make the use of the Auto Filter, so for that you just have to follow these simple steps that you have to make use.
1. The shortcut key to toggle auto filter on and off is Shift+Ctr+L

2. Choose the command Data, AutoFilter

3. Choose the command Home, Format as Table, and pick a table - you automatically get auto filters.

4. Choose the command Home, Sort & Filter, Filter

5. You can add all of these commands to the QAT.

So I think these will be the best to make this thing happen in Excels.