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


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## 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, and the optional `goal` query parameter:

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

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal.

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.