Any time you filter details, complete rows are hidden if values in a number of columns You should not meet the filtering requirements. It is possible to filter on numeric or textual content values, or filter by color for cells that have color formatting placed on their background or textual https://autofilter86417.webbuzzfeed.com/34590438/about-auto-filter