Excel Filters

S

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.
 
B

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
 
C

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
 
Top