When you filter data, whole rows are concealed if values in a number of columns Really don't satisfy the filtering conditions. You may filter on numeric or text values, or filter by color for cells that have shade formatting placed on their history or textual content. Auto filter in Excel https://gregorysjxjt.blogofchange.com/34688600/considerations-to-know-about-auto-filter