> For the complete documentation index, see [llms.txt](https://docs.tablomat.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.tablomat.com/learn/advanced-navigation/quick-filters.md).

# 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...

<figure><img src="/files/YhuVeZYt5t14GrYqzmGf" alt=""><figcaption></figcaption></figure>

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

<figure><img src="/files/nKG0XhZvvfe5QHm5GkEP" alt=""><figcaption></figcaption></figure>

#### `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 ...

<figure><img src="/files/uurO4DFjnXAawGoVfXY7" alt=""><figcaption></figcaption></figure>

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

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