DETAILS, FICTION AND AUTO FILTER

Any time you filter, enter a reference to your copied column labels from the Duplicate to box. The copied rows will then incorporate only the columns for which you copied the labels.We could make use of the excel shortcut keys Ctrl + Shift + L to apply filters towards the column headers. You may click any header to apply it all through the table or