Clearing a Filter There are two methods for clearing a filter depending on how the filter was created or applied. To clear a filter applied by typing in the blank row • Click in a column heading and choose (All). To clear a custom filter • Click Filters then choose Clear Filter.