If you filter data, total rows are concealed if values in a number of columns Really don't meet up with the filtering criteria. You'll be able to filter on numeric or text values, or filter by colour for cells which have shade formatting applied to their qualifications or textual content. https://autofilter71379.snack-blog.com/34062092/5-tips-about-auto-filter-you-can-use-today