Detect that none of the capabilities require absolute references, given that they only exist in a single cell, and spill their effects to neighboring cells. So, only certain rows are displayed, even though other rows which tend not to fulfill the filter ailment will not be displayed.  Make sure to https://autofilter98529.blogsidea.com/40105309/the-greatest-guide-to-auto-filter