If you filter data, full rows are hidden if values in a number of columns You should not fulfill the filtering requirements. It is possible to filter on numeric or textual content values, or filter by colour for cells that have shade formatting placed on their background or textual content. https://elliotttutro.blogdun.com/34759468/not-known-facts-about-auto-filter