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


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.tablomat.com/learn/advanced-navigation/quick-filters.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.