Once you filter data, total rows are concealed if values in one or more columns Do not meet the filtering conditions. You'll be able to filter on numeric or textual content values, or filter by color for cells that have color formatting applied to their history or textual content. AutoFilter https://raymonddcbyv.blogoscience.com/40367947/little-known-facts-about-auto-filter