However, clearing the autoFilter and reapplying through Excel, or ctrl+c/v the data into a fresh location then applying the filter does not crash Excel.

Have you found this content useful? Use the button above to save it to your profile. In his second tutorial of this two-part series, David Carter shows how to use AutoFilter and pivot tables to ...

How to use And and Or operators with Excel’s Advanced Filter Your email has been sent Editor’s Note: This article was originally published in July 2010 and the video tutorial for this article ...