Hi

DataFilterShow All will remove all filters from the data
DataFilterAutofilter will remove the Autofilter that has been applied - it
is a toggle which switched the condition on or off.

--
Regards
Roger Govier

"solve my problem" <solve my wrote in
message ...
how to deactivate filterkeys in ms excel