I think it is just an excel quirk...

if you click away from the filtered worksheet it changes from the result to filter mode...but if you refresh the filter it comes back

Thus I don't think you can change it other than refreshing the filter

Posted By: Maillot Jaune, Oct 26, 10:53:30