If you use a filter to your column, the only filters available for other columns are classified as the values seen in the at present filtered array. Whenever you filter details, total rows are hidden if values in one or more columns Really don't meet up with the filtering standards. https://autofilter08529.activablog.com/33234593/5-simple-techniques-for-auto-filter