THE FACT ABOUT AUTO FILTER THAT NO ONE IS SUGGESTING

If you filter, enter a reference for the copied column labels within the Duplicate to box. The copied rows will then include things like only the columns for which you copied the labels.Merge Filters: You could apply numerous filters to distinct columns simultaneously. This aids you narrow down your information much more efficiently.To uncover rows