Once you filter data, entire rows are hidden if values in a number of columns Really don't satisfy the filtering standards. You may filter on numeric or textual content values, or filter by shade for cells which have colour formatting placed on their qualifications or textual content. Bear in mind https://spencerirwbg.thekatyblog.com/32825077/5-simple-statements-about-auto-filter-explained