# 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="https://3062809325-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FEbkCXCUXmtUq5tcnUtZE%2Fuploads%2FdNZZaCAeUuQqgJukTp3j%2F3.8.1%20Pin%20rows%20columns.png?alt=media&#x26;token=50d4557a-f444-4155-969c-372ef33eab04" 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="https://3062809325-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FEbkCXCUXmtUq5tcnUtZE%2Fuploads%2FZ7D1vaFUPI98IUFJyddv%2F3.8.5%20pin%20row.png?alt=media&#x26;token=6ddf98d8-f8cd-4609-8b29-7ed28e40a33c" alt=""><figcaption><p>Pin rows to the top</p></figcaption></figure>

b) Computer accessories is pinned to the top.

<figure><img src="https://3062809325-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FEbkCXCUXmtUq5tcnUtZE%2Fuploads%2Fw6YFYgKG1ipYG7Ha3pg1%2F3.8.6%20pin%20row.png?alt=media&#x26;token=36112f6e-2f9e-463d-b8d2-874f8d5ff28d" 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="https://3062809325-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FEbkCXCUXmtUq5tcnUtZE%2Fuploads%2F7vx6vfIpBB7F7TtdePDu%2F3.8.7%20pin%20row.png?alt=media&#x26;token=2967e1cd-d03a-4e1c-8d53-5e27c57e1321" 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="https://3062809325-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FEbkCXCUXmtUq5tcnUtZE%2Fuploads%2FhcAEzwygrlOHUIxY4HP3%2F3.8.8%20pin%20column.png?alt=media&#x26;token=ee20b7a0-2835-4716-9614-046d239e7c07" alt=""><figcaption><p>Click on the column gripper</p></figcaption></figure>

b) Click on the 'Pin column' option.

<figure><img src="https://3062809325-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FEbkCXCUXmtUq5tcnUtZE%2Fuploads%2FFkFT8ju0RHG6vK8YbA49%2F3.8.9%20pin%20column.png?alt=media&#x26;token=f7dbe2d2-617c-4457-9117-165ef87c6cd0" alt=""><figcaption><p>Pin column option in the column gripper</p></figcaption></figure>

c) December sales gets pinned to the left.

<figure><img src="https://3062809325-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FEbkCXCUXmtUq5tcnUtZE%2Fuploads%2F6IvrYQRk7GlxZZMciZlw%2F3.8.10%20pin%20column.png?alt=media&#x26;token=dac5eb7f-a0b2-4d9d-a3fe-cec5ea8d6d59" 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="https://3062809325-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FEbkCXCUXmtUq5tcnUtZE%2Fuploads%2F4UNRGJRv2FarsXAypG2v%2F3.8.2%20Unpin%20rows.png?alt=media&#x26;token=ef594b8b-8e6d-4a8a-9942-7dc4ea2be5ff" 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="https://3062809325-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FEbkCXCUXmtUq5tcnUtZE%2Fuploads%2FJ7HNl42dwv5W1KFf9C7J%2F3.8.3%20Unpin%20column.png?alt=media&#x26;token=7a13ae5f-119d-447f-a3c7-a94023ca900c" 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="https://3062809325-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FEbkCXCUXmtUq5tcnUtZE%2Fuploads%2FQDp6NVHtydXHqJjLQLq0%2F3.8.4%20Unpin%20all.png?alt=media&#x26;token=3047d351-6e98-4618-a093-f562d8125cfe" alt=""><figcaption><p>Unpin all</p></figcaption></figure>

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