I'm not entirely sure what you mean, so forgive me if this explanation is of no use to you.
You'll know when you are filterin data if you look at the row numbers to the left of the xl screen. They change to a blue colour and they hide certain rows which doesn't contain the active filter.
You can then clik on the filter arrow and select "All" to show all the data in that criteria column.
Again, apologies if this isn't the answer you were looking for, I just don't fully understand your question.