yes... is there a way to change all the filter columns to ALL... rather than
turn the auto filter off and back on... or changing the filterd columns back
to ALL.

"jenn" wrote:

is there a way to reset the auto filter so that the filter is still ON but
nothing is filtered out? Normally I go to DataFilterAuto filter to turn it
off and then go turn it on again