Once you filter data, total rows are hidden if values in one or more columns Really don't fulfill the filtering conditions. You could filter on numeric or text values, or filter by color for cells that have colour formatting applied to their qualifications or textual content. Filter by selecting values https://autofilter79022.onesmablog.com/a-review-of-auto-filter-74707993