TOP AUTO FILTER SECRETS

When you filter, enter a reference into the copied column labels from the Copy to box. The copied rows will then incorporate only the columns for which you copied the labels.AutoFilter in Excel will allow us to look at unique rows although hiding the other rows. When Excel AutoFilter is included on the row's header, it provides us a drop-down menu