Excel 2007 Auto Filter Default Select All


J

James Sender

I have upgraded from Excel 2003 to Excel 2007 and have a question about the
AutoFilter function. In 2003, when you filtered a column, you would choose
from the drop down menu which criteria you want to filter by or if you wanted
to Select All. In 2007, Select All is checked by default. Is there any way to
turn the Select All by default off? Its annoying when I have to filter
several columns to have to deselect it for every one first.
 
Ad

Advertisements

E

Excel Nut

You don't need to unselect every item in the list. Uncheck Select All
and all items will be unselected. Then select just the items you need.

Francis Hayes (The Excel Addict)
www.TheExcelAddict.com
 
Ad

Advertisements

P

Peo Sjoblom

I believe the OP meant all columns that are filtered not all items

--


Regards,


Peo Sjoblom
 

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