While sorting is helpful in quickly scanning several records to find a specific group, filters actually limit your data view to only those records that match your criterion.
The great thing about filters is that they are temporary. This means they work well when you need a quick answer and they take a relatively small amount of work but they don’t make any permanent changes to your data.
Types of Filters
Filter by Selection
Filter by Selection is one of the fastest ways to filter your list. With this option, all you need to do is highlight the filter criterion in your table or form, and then choose Filter by Selection. Your list will quickly filter based on the data that is selected.
Filter by Form
When using c Filter by Selection, you’re only able to filter one field at a time. However, when you want to filter based on several fields, you can use the Filter by Form feature.
For all other filter options, you can always use the Advanced Filter feature. With this feature, you can write expressions to filter your data based on one or more fields.