Exceljet filter

1. What are the 3 ways to add filter in Excel?

What are the 3 ways to add filter in Excel?

In Excel, you can create three kinds of filters: by values, by a format, or by criteria. But each of these filter types is mutually exclusive. For example, you can filter by cell color or by a list of numbers, but not by both. You can filter by icon or by a custom filter, but not by both.