Any time you filter information, entire rows are concealed if values in one or more columns Will not satisfy the filtering conditions. You can filter on numeric or text values, or filter by shade for cells that have colour formatting applied to their background or text. Auto filter in Excel https://auto-filter29740.blog2freedom.com/34096499/detailed-notes-on-auto-filter