After you filter info, complete rows are hidden if values in a number of columns You should not meet up with the filtering criteria. You can filter on numeric or text values, or filter by colour for cells which have colour formatting placed on their track record or textual content. https://auto-filter19630.thezenweb.com/auto-filter-for-dummies-72117850