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?
Need more help?
Want more options?
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.
