Once you filter info, full rows are hidden if values in one or more columns Will not meet the filtering criteria. You could filter on numeric or text values, or filter by color for cells which have color formatting applied to their track record or text. Auto filter in Excel https://auto-filter65207.shoutmyblog.com/33256229/an-unbiased-view-of-auto-filter