Once you filter info, entire rows are hidden if values in one or more columns don't meet up with the filtering requirements. You may filter on numeric or text values, or filter by shade for cells that have colour formatting applied to their background or text. Communities help you check https://auto-filter65207.pages10.com/5-simple-techniques-for-auto-filter-69429889