Whenever you filter data, entire rows are hidden if values in one or more columns don't fulfill the filtering criteria. You could filter on numeric or textual content values, or filter by colour for cells that have coloration formatting applied to their qualifications or text. Microsoft provides a confirmed listing https://manuelfebyv.prublogger.com/33240943/auto-filter-for-dummies