To Filter Extracted Data in Columns

Click Insert tab Linking & Extraction panel Extract Data. Find
In the Data Extraction wizard on the Refine Data page, right-click a column label and choose Filter Options.
Select a predefined filter from the drop-down list.
From the drop-down list on the left, select a value.
In the Filter Across These Values field, clear any values so that they are not included.

Was this information helpful?

Yes
No