Any time you filter information, total rows are hidden if values in one or more columns Do not satisfy the filtering standards. You could filter on numeric or textual content values, or filter by shade for cells that have coloration formatting applied to their qualifications or text. AutoFilter in Excel https://auto-filter76418.blue-blogs.com/41414080/a-review-of-auto-filter