# Select and analyze data

{% hint style="info" %}
User permission: Budgets & Forecasts
{% endhint %}

Selecting rows or cells of data lets you perform actions such as analyze aggregated metrics, copy the data for use elsewhere, or apply bulk changes more efficiently.

### Select rows

When you select rows, the **Row count** updates in the status bar at the bottom of the grid.

There are several ways to select rows in the grid:

* **Select a single row**: Click its checkbox on the left side of the grid.
* **Select a range of individual rows**: Press and hold the **Ctrl** key while clicking the row check boxes.
* **Select multiple consecutive rows**: Use one of these methods:
  * Click and drag your mouse across the rows you want to include.
  * Select the first row's check box, press and hold the **Shift** key, click the last row's checkbox, and then release the **Shift** key.
* **Select rows in bulk**: Click the **Row** menu and choose from the available options, such as all baseline rows or all rows with a specific workflow status. 

<figure><img src="/files/xrPxkiHj68I5nz6qqC0d" alt=""><figcaption></figcaption></figure>

### Select cells

When you select one or more cells in the grid, the status bar at the bottom displays aggregated information about your selection, including:

* **Average** of the selected cells (for numerical data).
* **Count** of selected cells.
* **Sum** of selected cells (for numerical data).

You can get further metrics using the **Analyze selection** feature available in the **Cell** menu.&#x20;

There are several ways to select cells in the grid.&#x20;

* **Select one cell**: Click that cell.
* **Select multiple consecutive cells**: Click and drag your mouse across the cells you want to include.
* **Select all cells in a row or column**: Click one of the cells in that row or column, then right-click the cell (or click the **Cell** menu) to open the **Cell selection** menu and choose from the available options.

<figure><img src="/files/wQYNURm2NQWKjrkazlxg" alt=""><figcaption></figcaption></figure>


---

# 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.phocassoftware.com/budgets-and-forecasts/contributor/review-the-budget-or-forecast/select-and-analyze-data.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.