AUTO FILTER OPTIONS

When you filter, enter a reference towards the copied column labels inside the Copy to box. The copied rows will then include things like just the columns for which you copied the labels.AutoFilter in Excel allows us to watch certain rows when hiding one other rows. When Excel AutoFilter is added towards the row's header, it provides us a drop-down