When you filter data, complete rows are hidden if values in a number of columns You should not meet the filtering criteria. It is possible to filter on numeric or text values, or filter by coloration for cells which have coloration formatting placed on their qualifications or textual content. AutoFilter https://auto-filter31852.bloggactivo.com/33367673/the-greatest-guide-to-auto-filter