Firefox Extension: How to Auto Filter in Excel

How to Auto Filter in Excel
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
Reply With Quote
#2
Old 07-01-2012
QUENBY QUENBY is offline
Member

Join Date: Jun 2011
Posts: 587
Re: How to Auto Filter in Excel
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
Reply With Quote
#3
Old 07-01-2012
Leanne Leanne is offline
Member

Join Date: Jul 2011
Posts: 578
Re: How to Auto Filter in Excel
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.
Reply With Quote