If you filter info, overall rows are concealed if values in a number of columns Do not meet up with the filtering criteria. You are able to filter on numeric or text values, or filter by coloration for cells which have colour formatting applied to their track record or text. https://auto-filter71480.blazingblog.com/34110396/auto-filter-fundamentals-explained