DataFilterAuto Filter in excel 2007?
Hi,
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 autofilters.
4. Choose the command Home, Sort & Filter, Filter
5. You can add all of these commands to the QAT.
If this helps, please click the Yes button.
Cheers,
Shane Devenshire
"TIJ" wrote:
I have Excel 2003, but oversee a large group that has Excel 2007 (just got it).
I can't find simple instructions on how to Auto Filter. Please help
|