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

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" <(E-Mail Removed)> wrote in message newsCAD1A38-EC91-4CAC-B090-(E-Mail Removed)...
>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

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