DataFilterAuto Filter in excel 2007?
 

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

DataFilterAuto Filter in excel 2007?
 

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


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"TIJ" wrote in message ...
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

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