Removing a filter in Microsoft Excel 2019

  1. Click on the icon to the right of DIVISION.
  2. Select Clear Filter from “DIVISION” from the drop-down list, andmake sure that Select All is ticked todisplay all the DIVISION column andnot just Parklandsasillustrated in the following screenshot:
ms office 826
  1. Click on the Clear icon located onthe drop-down list of the Sort &Filter group. This option will remove all filters, and sorts fromthe selected list.

Leave a Comment