Data>Filter>Auto Filter in excel 2007?

T

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
 
S

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top