Whenever you filter information, whole rows are hidden if values in a number of columns don't meet the filtering conditions. You could filter on numeric or text values, or filter by shade for cells which have colour formatting placed on their history or text. Choose all the data you want https://titusgcwrh.blogdal.com/34547683/auto-filter-for-dummies