After you filter facts, entire rows are hidden if values in one or more columns Will not satisfy the filtering standards. You could filter on numeric or textual content values, or filter by colour for cells which have colour formatting placed on their background or textual content. AutoFilter in Excel https://autofilter35667.blogs100.com/34584254/everything-about-auto-filter