Removing a spreadsheet filter

You use the Edit Spreadsheet Filters window to remove a spreadsheet filter.

  1. On the ribbon, click the Filters button "" to open the Edit Spreadsheet Filters window.
  2. On the grid in the Edit Spreadsheet Filters window, select the row containing the filter you want to remove, and then click [Remove].

    Estimating dims the line on the grid.

    Tip: The [Restore] button becomes available after you remove a filter. You can restore a filter only until you save your changes by selecting [OK] or you close the window.

  3. Click [OK}.