Data range in Filter

when I do data filter, I want to see the data selected by the filter. Sometimes data filter does not select the data after a SPACE. We assume that filter is on Whole data but actually it is upto SPACE, Does anyone knows how to find data selected in Filter.

Regards

filter - text filters - contains

Sorry

I want to identify the date range which is filter, Like in Pivot you can change the data range.