NOT KNOWN FACTS ABOUT AUTO FILTER

Whenever you filter, enter a reference to the copied column labels in the Duplicate to box. The copied rows will then incorporate only the columns for which you copied the labels.AutoFilter in Excel enables us to look at unique rows whilst hiding the opposite rows. When Excel AutoFilter is added on the row's header, it presents us a drop-down menu