Be aware: Whenever you use Locate to search filtered data, only the information that may be shown is searched; information that isn't exhibited is not really searched. To look all the information, clear all filters. Be aware: You can't remove filters from individual columns. Filters are both on for a whole selection, https://daltonnaktc.wssblogs.com/34038936/a-review-of-auto-filter