Any time you filter data, overall rows are hidden if values in a number of columns You should not meet the filtering requirements. It is possible to filter on numeric or textual content values, or filter by shade for cells which have colour formatting applied to their history or textual https://autofilter70122.digitollblog.com/33909236/the-2-minute-rule-for-auto-filter