I have seen many people turning OFF and then ON Auto Filter in order just to SHOW ALL values (in Excel 2003’s terms) or CLEAR all filters (in Excel 2007 or above’s terms).  Frankly, I think many people do this … Continue reading Why do you turn off Auto Filter and then turn it on again??