Quick Filters

Introduction

Filters are essentially tools for narrowing down a large spreadsheet into a subset of records that are relevant for browsing or editing in a particular task.

Users that perform a large number of small editing tasks may find that they're actually spending more time setting up filters and views than doing cell editing. For these users, saving a few clicks with every filter can result in a drastically-better user experience.

Tablomat supports keyboard and mouse shortcuts to make data filtering as frictionless as humanly possible.

Ctrl + Left Click

Holding Ctrl and left-clicking any cell will add a filter for the clicked cell value.

For example, ctrl-clicking the cell containing the word "Salomon" on the following sheet...

will instantly add a filter "Vendor is Salomon", resulting in the following view of data ...

Ctrl + Shift + Left Click

This shortcut adds a filter that excludes the clicked value from the current view.

For example, applying this shortcut to a cell that contains "Salomon" will add the following filter ...

which will exclude all rows where the "Vendor" value is "Salomon".

In practice, this shortcut can be cascaded to exclude all irrelevant rows.