Once you filter info, whole rows are concealed if values in a number of columns Will not meet the filtering requirements. You could filter on numeric or text values, or filter by colour for cells which have color formatting applied to their background or text. Make use of personalized AutoFilter https://auto-filter20741.prublogger.com/33241666/about-auto-filter