A REVIEW OF AUTO FILTER

Be aware: Whenever you utilize the Locate dialog box to go looking filtered data, only the information which is shown is searched; info that's not displayed is not really searched. To go looking all the information, obvious all filters.The info consists of 4 blank rows higher than the checklist range that could be utilised for a criteria selection