Take note: Once you use Locate to search filtered details, only the information that is definitely displayed is searched; knowledge that isn't shown is not searched. To search all the data, very clear all filters. Note: You cannot take out filters from unique columns. Filters are possibly on for a complete variety, https://autofilter08539.activosblog.com/33070123/the-basic-principles-of-auto-filter