THE SMART TRICK OF AUTO FILTER THAT NOBODY IS DISCUSSING

If you filter, enter a reference towards the copied column labels inside the Copy to box. The copied rows will then consist of just the columns for which you copied the labels.We could utilize the excel shortcut keys Ctrl + Shift + L to apply filters for the column headers. You may click on any header to use it all over the table or on certain head