This content has been marked as final. Show 2 replies
To apply a filter to select worksheets:
- On the Filters shelf, right-click the field and select Apply to Worksheets > Selected Worksheets.
- In the Apply Filter to Worksheets dialog box, select the worksheets that you want to apply the filter. If any of the sheets already contain a filter on the same field, the dialog box will provide details about the filter. If you select the sheet, the current filter will override any existing filter selections.