Whenever you use a filter to a column, the sole filters available for other columns would be the values visible in the at the moment filtered selection. When you filter information, overall rows are hidden if values in one or more columns Do not meet up with the filtering standards. https://auto-filter23197.blogsidea.com/40510781/top-auto-filter-secrets