Whenever you filter data, full 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 color for cells which have coloration formatting applied to their track record or text. https://autofilter47925.blazingblog.com/34111151/the-basic-principles-of-auto-filter