Any time you filter details, whole rows are hidden if values in one or more columns Really don't fulfill the filtering criteria. You'll be able to filter on numeric or textual content values, or filter by colour for cells that have color formatting placed on their background or textual content. https://rylanyyuso.mdkblog.com/39939016/little-known-facts-about-auto-filter