Any time you filter data, whole rows are hidden if values in one or more columns Never meet up with the filtering conditions. You are able to filter on numeric or text values, or filter by color for cells that have colour formatting placed on their history or textual content. https://autofilter08536.techionblog.com/34122549/5-tips-about-auto-filter-you-can-use-today