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.
Want more?
Precisa de mais ajuda?
Quer mais opções?
Explore subscription benefits, browse training courses, learn how to secure your device, and more.
Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.
