Any time you filter details, overall rows are hidden if values in a number of columns You should not satisfy the filtering criteria. You can filter on numeric or textual content values, or filter by shade for cells which have colour formatting placed on their track record or textual content. https://cashxyqjx.bloggosite.com/41011731/auto-filter-for-dummies