Whenever you filter data, total rows are hidden if values in one or more columns Will not meet up with the filtering standards. You could filter on numeric or text values, or filter by shade for cells which have shade formatting placed on their background or text. Auto filter in https://auto-filter53074.targetblogs.com/34565036/helping-the-others-realize-the-advantages-of-auto-filter