THE GREATEST GUIDE TO AUTO FILTER

Choosing the information selection is important mainly because Excel really should know which details you’re dealing with. You should definitely involve any headers or titles, as these will come to be the filter buttons.So, only distinct rows are exhibited, although other rows which don't satisfy the filter affliction are usually not displayed.