> For the complete documentation index, see [llms.txt](https://docs.phocassoftware.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.phocassoftware.com/flex-modes/work-with-the-grid.md).

# Work with the grid

Sort and select values, freeze property columns, work with multiple pages, and access additional information and actions.

<figure><img src="/files/uxHZhjCEYkHGZBvkgNER" alt=""><figcaption><p>Key tools and information you can use when working with the grid</p></figcaption></figure>

### 1. Sort data

When in a dimension view, you can sort the grid by a column to change the order in which the data displays.

Click a column heading to sort the data by that column. Click the heading again to switch between ascending and descending order.

An arrow next to the column heading identifies the column the grid is currently sorted by and indicates the sort direction.

Your sort selection remains when you switch dimensions and is cleared when you reset your analysis.

### 2. Use internal links

When in a dimension view, some values in the grid display as blue links when internal links have been [configured by your administrator](/administration/designer/modify-a-database.md#add-shortcut-links).

Click a blue link to view the available options, then select the item you want to open. For example, you might open a customer scorecard or CRM record, or create a CRM activity.&#x20;

<div align="left"><figure><img src="/files/WHhk7BxM9hEquOrS7oU8" alt="" width="158"><figcaption><p>Internal links</p></figcaption></figure></div>

### 3. Collapse the dimensions panel

Collapse the dimensions panel to give the grid more space and view more data at once.

Click the **Collapse dimensions** button at the bottom of the panel. Click it again to show the panel.

### 4. Freeze property columns

When in a dimension view, freeze the property columns to keep them visible as you scroll horizontally across the grid. This helps maintain context (such as **Code**, **Name**, or **Country**) during your analysis.&#x20;

Click the **Freeze properties** ![](/files/fV9MEdcGZ8ttywfGMNty) button in the bottom-left corner of the grid. All selected property columns are frozen together.&#x20;

Click it again to return to the default scrolling behaviour.

<div align="left"><figure><img src="/files/vH9fBWiXSgcuc09YoJrI" alt=""><figcaption><p>Frozen property columns remain in view as you scroll horizontally</p></figcaption></figure></div>

### 5. Work with multiple pages

When the grid contains more than 100 rows, the data displays across multiple pages.

#### Move between pages

Use the pagination buttons in the bottom-left corner of the grid to move between pages.

#### Show all records

Click the **Show all** <img src="/files/wayQjvw6jJ78J8JOgLPe" alt="" data-size="line"> button to display all rows on one page and scroll through them. Click it again to return to the paginated view.

![Switching between the Show all and Paginated views](/files/m3fpU8JFQ7AeIVtOMZF0)

### 6. View calculations for selected values

Select multiple values in the grid to see their **Average**, **Count**, and **Sum** at the bottom of the grid.

### 7. View the record count

The record count in the bottom-right corner of the grid shows the total number of records in your current analysis, including those on other pages.

### 8. Access additional actions

Right-click a cell in the grid to view the additional actions available for that data. The available actions depend on the selected cell and your current analysis.

<div align="left"><figure><img src="/files/sAEQpftrrsH4B0TcHpFW" alt="" width="191"><figcaption><p>Right-click context menu</p></figcaption></figure></div>

### 9. Use keyboard shortcuts

Use keyboard shortcuts to work more quickly with data in the grid.

<table data-search="false"><thead><tr><th width="234.453125">Keys</th><th>Action</th></tr></thead><tbody><tr><td><code>Ctrl/Cmd+K</code></td><td>Toggle the command palette</td></tr><tr><td><code>Ctrl+B</code></td><td>Show or hide the dimension panel</td></tr><tr><td><code>F</code></td><td>Focus on the selection (drill-down into selected rows)</td></tr><tr><td><code>↑</code> <code>↓</code> <code>←</code> <code>→</code></td><td>Move the cell selection</td></tr><tr><td><code>Ctrl/Cmd + Arrow</code></td><td>Jump to the first or last row or column</td></tr><tr><td><code>Home</code> / <code>End</code></td><td>Jump to the first or last column</td></tr><tr><td><code>Enter</code></td><td>Move down one row</td></tr><tr><td><code>Shift+Enter</code></td><td>Move up one row</td></tr><tr><td><code>Tab</code></td><td>Move right one column</td></tr><tr><td><code>Shift+Tab</code></td><td>Move left one column</td></tr><tr><td><code>Shift + Arrow</code></td><td>Extend selection</td></tr><tr><td><code>Ctrl/Cmd + Shift + Arrow</code></td><td>Extend selection to edge</td></tr><tr><td><code>Shift+Home</code> / <code>Shift+End</code></td><td>Extend selection to first or last column</td></tr><tr><td><code>Escape</code></td><td>Clear the selection</td></tr><tr><td><code>Ctrl/Cmd+C</code> or <code>Ctrl+Insert</code></td><td>Copy selected cells</td></tr></tbody></table>


---

# 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.phocassoftware.com/flex-modes/work-with-the-grid.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.