You can use the Advanced Filter to create more powerful filters, such as filtering for unique records and using operators such as OR.
Remove a filter from a column
Click the Filter icon button next to the column heading, and then click Clear Filter from <“Column Name”>.
Remove all the filters in a worksheet
Click DATA > Clear.