Auto Filter defaults in Excel 2007

[hayati]

Hi there,

I was wondering if there is a way to change the default in Excecl 2007 so that when you make an auto filter on a column header instead of having everything ticked it showes up as unticked? Similar to how it was in the previous version.

Thanks,
Matt

 

[Colin Legg]

Hi there,

I was wondering if there is a way to change the default in Excecl 2007 so that when you make an auto filter on a column header instead of having everything ticked it showes up as unticked? Similar to how it was in the previous version.

Thanks,
Matt

I don't think so, Matt. As I'm sure you know, you just have to untick the "Select All" tickbox at the top of the list and it will untick them all. (I only have XL 2010 in front of me, but I assume this option is available in XL 2007).

 

[hayati]

Colin,

Thanks, and indeed the unticking off select all works but its just an extra setp that is annoying. its just that we deal with large sheets and use filters to drill down into the specific data we need to look at. It just seems like there should be a way to eliminate that extra step. It didn't do that in the previous version, so you could simply just select the contract number you are looking at without unselecting all of them...

not sure why they decided to change that?

 

[hayati]

The more I google this the more I see others asking about the same thing as well, still couldnt find any answers that change the default so Select All isn't selected by default