HELPING THE OTHERS REALIZE THE ADVANTAGES OF 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 just the columns for which you copied the labels.We can utilize the excel shortcut keys Ctrl + Shift + L to use filters for the column headers. You can click on any header to use it all through the desk or on distinct