How to handle large filter options

1. How do I filter data faster in Excel?
2. Should filters be on left or right?

How do I filter data faster in Excel?

Selecting values from a list and searching are the quickest ways to filter. When you click the arrow in a column that has filtering enabled, all values in that column appear in a list. To select by values, in the list, clear the (Select All) check box.

Should filters be on left or right?

4. Filter bars better showcase filters. By making the filters more prominent on the page and by making them available as the user scrolls a filter bar does a better job of showcasing filters. Presenting filters left to right also makes it very easy for users to quickly see what options are available.