ABOUT AUTO FILTER

When you filter, enter a reference towards the copied column labels within the Copy to box. The copied rows will then contain only the columns for which you copied the labels.We can use the excel shortcut keys Ctrl + Shift + L to use filters for the column headers. You can click on any header to apply it throughout the table or on precise headers t