Any time you filter knowledge, entire rows are concealed if values in one or more columns don't satisfy the filtering criteria. You could filter on numeric or text values, or filter by color for cells which have colour formatting applied to their background or textual content. Microsoft provides a verified https://finnrdnuc.mdkblog.com/39938529/a-secret-weapon-for-auto-filter