# Pin rows & columns

Pinning rows and columns is very helpful when you have too many rows or columns in your report. You can use the pinning option to freeze them respectively at the top or left so that they are visible even when you scroll to another area of the report.

<figure><img src="/files/T2FEIaxY5PAKE6iP7ZOv" alt=""><figcaption><p>Pinned rows and columns</p></figcaption></figure>

### 1. Pin rows

In this example, we have Computer accessories on the second page of the report. But this is an important category that is being tracked so we want it to be easily visible on the report.&#x20;

a) Hover over the row and click on the 'Pin' icon.

<figure><img src="/files/fDnbYBdIAu2RZRlxzYFX" alt=""><figcaption><p>Pin rows to the top</p></figcaption></figure>

b) Computer accessories is pinned to the top.

<figure><img src="/files/OHXIBYaVCemYknsNhfug" alt=""><figcaption><p>Pinned to the top</p></figcaption></figure>

c) If you navigate to another page in the visual, you can see that the row is still pinned.

<figure><img src="/files/tFoQg0AzhZ5vpqvimmuh" alt=""><figcaption><p>Row is pinned across pages</p></figcaption></figure>

### 2. Pin columns

In this example, we have monthly data for sales, margin, and customers. We would like to focus on last month's sales.

a) To do this, we can pin December sales. Hover over the column and click on the gripper.

<figure><img src="/files/WfZf71ahjO7ErRT0xKWg" alt=""><figcaption><p>Click on the column gripper</p></figcaption></figure>

b) Click on the 'Pin column' option.

<figure><img src="/files/4DNtNhWOiWxeONSImFCf" alt=""><figcaption><p>Pin column option in the column gripper</p></figcaption></figure>

c) December sales gets pinned to the left.

<figure><img src="/files/aKVAjSfYWLKVtumuszxg" alt=""><figcaption><p>Column pinned to the left</p></figcaption></figure>

### 3. Unpin

a) To unpin an individual row, click on the pinned icon in either the pinned section or the original row as shown below.

<figure><img src="/files/hKfkkQTI1BDibH4IxC7W" alt=""><figcaption><p>Unpin row</p></figcaption></figure>

b) To unpin an individual column, you can click on the pinned icon in the pinned section. Or, click on the column gripper and the un-pin column option.&#x20;

<figure><img src="/files/OZ2G9ouuNiOypexzum3h" alt=""><figcaption><p>Unpin column</p></figcaption></figure>

c) When there are multiple pinned rows and columns, you can quickly un-pin the rows and columns by using the corresponding ‘un-pin all’ option from the row/column gripper.

<figure><img src="/files/YsRysiTFJX2IGDizk5sC" alt=""><figcaption><p>Unpin all</p></figcaption></figure>

In the next section, you can find a list of the available [keyboard shortcuts](/working-with-inforiver/3.-basic-interactions/actions/keyboard-shortcuts.md).


---

# 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.inforiver.com/working-with-inforiver/3.-basic-interactions/pin-rows-and-columns.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.
