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.

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


--
baxybaxy
------------------------------------------------------------------------
baxybaxy's Profile: http://www.excelforum.com/member.php...o&userid=35824
View this thread: http://www.excelforum.com/showthread...hreadid=556078

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.