When you filter data, total rows are hidden if values in a number of columns Really don't fulfill the filtering requirements. It is possible to filter on numeric or textual content values, or filter by coloration for cells which have colour formatting applied to their background or textual content. AutoFilter https://paxtongfbyv.ttblogs.com/13759459/not-known-factual-statements-about-auto-filter