Data>Filter>Auto Filter in excel 2007?

[TIJ]

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

 

[Ron de Bruin]

On the Data tab you can turn AutoFilter on and off

Or use Alt dff to Toggle

See also
http://www.rondebruin.nl/0307commands.htm

 

[Shane Devenshire]

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