Any time you filter information, complete rows are hidden if values in a number of columns You should not satisfy the filtering criteria. You are able to filter on numeric or text values, or filter by color for cells that have coloration formatting applied to their history or text. AutoFilter https://emiliolcoak.dm-blog.com/34114025/a-review-of-auto-filter