Excel Filters

[Shaun]

i am using excel 2003. when i bring up a sheet that already has filters on it
and using the dropdown select (ALL) it seems to filter certain rows in my
sheet. the rows all have data in each cell the same as all the other rows. i
thought that when you selected (ALL) it showed every line without filtering.

[baxybaxy]

shaun

it should do. if you have loads of data, it just seems to bomb sometimes (memory?). i have this issue all the time and unfortunately have no fix for it

[CLR]

Only if that were the only column being filtered. To clear the entire
Autofilter, just do Data > Filter > AutoFilter.......it toggles it off and on.

Vaya con Dios,
Chuck, CABGx3



"Shaun" wrote:

> i am using excel 2003. when i bring up a sheet that already has filters on it
> and using the dropdown select (ALL) it seems to filter certain rows in my
> sheet. the rows all have data in each cell the same as all the other rows. i
> thought that when you selected (ALL) it showed every line without filtering.