View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.newusers
Shane Devenshire[_2_] Shane Devenshire[_2_] is offline
external usenet poster
 
Posts: 3,346
Default 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