Once you filter data, total rows are hidden if values in a number of columns You should not fulfill the filtering requirements. You may filter on numeric or textual content values, or filter by colour for cells which have shade formatting placed on their history or text. Decide on all https://autofilter86418.pointblog.net/the-smart-trick-of-auto-filter-that-no-one-is-discussing-77921401