TOP AUTO FILTER SECRETS

After you filter, enter a reference for the copied column labels in the Copy to box. The copied rows will then involve only the columns for which you copied the labels.The auto filter turns on filtering for chosen cells, although Sophisticated filters out using advanced requirements. It allows you to make the filter requirements outside the house b