Once you filter facts, whole rows are hidden if values in one or more columns Really don't fulfill the filtering criteria. You can filter on numeric or text values, or filter by color for cells which have colour formatting placed on their background or text. Microsoft has a verified list https://auto-filter53186.frewwebs.com/34616432/5-simple-techniques-for-auto-filter