LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Excel 2007 Auto Filter Default Select All

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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Select All Auto Filter Milodie66 Excel Discussion (Misc queries) 0 March 18th 09 03:57 PM
DataFilterAuto Filter in excel 2007? TIJ New Users to Excel 2 November 13th 08 03:28 AM
Excel 2007 Auto Filter Filter Django Excel Discussion (Misc queries) 2 September 9th 08 10:52 PM
Auto Filter in EXCEL 2007 Pramod Mehta Excel Discussion (Misc queries) 4 April 18th 07 05:04 PM
Is it possible to use auto filter to select more than 2 criteria? hello_lpc Excel Discussion (Misc queries) 2 July 12th 06 02:52 PM


All times are GMT +1. The time now is 09:56 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"