# Select and focus on data

In a financial statement, you can select:

* Rows, such as a range of accounts and/or groups.
* Snippets of data, such as a list of account names and their values.

You can then quickly view the average, count and sum (where applicable) of the selected data or copy the selected data for use elsewhere, such as a Microsoft Excel worksheet. In the case of selected rows, you can proceed to focus on the data in the Analytics grid.

By default, row selection is cumulative. You will be familiar with this behavior if you use the Analytics grid. To override this behavior (select only one row at a time), press and hold down the **Ctrl** key while you make your selection.

## Select rows <a href="#selectandfocusondatainafinancialstatement-selectrows" id="selectandfocusondatainafinancialstatement-selectrows"></a>

To display the **Select** (checkbox) button, hover over the left side of a row.

* To select one or more rows: Click the **Select** button.
* To select multiple consecutive rows quickly, either:
  * Click the first **Select** button, hold and drag your mouse up or down the other rows, then release your mouse.
  * Select the first row, hold down the **Shift** key, select the last row, then release the **Shift** key.
* To select all rows: Click the **Select all** button in the top left corner of the grid.

When you select one or more rows, those rows turn blue and the blue **Selection** button displays in top left corner of the grid.

<div align="left"><figure><img src="/files/dV7fzTCuoIZesyNpq9Nq" alt="" width="380"><figcaption></figcaption></figure></div>

### Deselect rows <a href="#selectandfocusondatainafinancialstatement-deselectrows" id="selectandfocusondatainafinancialstatement-deselectrows"></a>

When you deselect a row it returns to white. To deselect one or more selected rows, or all rows, use one of the above selection methods, as applicable.

You can click the **Reset** button to deselect all rows but that action will also reset any other settings you have applied to the grid.

### Identify selected rows <a href="#selectandfocusondatainafinancialstatement-identifyselectedrows" id="selectandfocusondatainafinancialstatement-identifyselectedrows"></a>

When you select one or more rows in a group, then collapse that group so the selected rows are no longer visible, the breadcrumb icon displays on the checkbox of that group row to indicate that it has some selected rows. This indicator is particularly useful if you are editing a dashboard widget in which multiple rows are selected.

<div align="left"><figure><img src="/files/pgLOGENc1Ek3PXsTwLMI" alt="" width="340"><figcaption></figcaption></figure></div>

## Select snippets of data <a href="#selectandfocusondatainafinancialstatement-selectsnippetsofdata" id="selectandfocusondatainafinancialstatement-selectsnippetsofdata"></a>

You can select one or more cells in the grid. Your selection can include a mix of cell contents, such as a code, name or value. When you select a cell it turns blue and information displays at the bottom of the grid (see next section).

* To select one cell: Click the cell.
* To select multiple, consecutive cells, either:
  * Click and drag your mouse over the cells.
  * Click the first cell, press and hold the **Shift** key, click the last cell, then release the **Shift** key.
* To select multiple, non-consecutive rows: Select the first cell, hold down the **Ctrl** key, select the other cell(s), then release the **Ctrl** key.

### View average, count and sum of selected data <a href="#selectandfocusondatainafinancialstatement-viewaverage-countandsumofselecteddata" id="selectandfocusondatainafinancialstatement-viewaverage-countandsumofselecteddata"></a>

Your administrator may turn off permission to view count, sum and average via your profile setting.

When you select one or more rows or cells in the grid, the following information displays in a status bar at the bottom of the grid:

* **Average** of the numerical values in the selection (if applicable).
* **Count** of cells in the selection.
* **Sum** of the numerical values in the selection (if applicable).

<div align="left"><figure><img src="/files/2qAPwrNIj3GUJhiKWLN6" alt="" width="550"><figcaption></figcaption></figure></div>

<div align="left"><figure><img src="/files/4ZZkf82fKOyIPMduIaIY" alt="" width="550"><figcaption></figcaption></figure></div>

## Focus on data <a href="#selectandfocusondatainafinancialstatement-focusondata" id="selectandfocusondatainafinancialstatement-focusondata"></a>

To analyze specific accounts and/or groups (categories) in a financial statement more easily, you can focus on rows in a Financial Statement.

Select the required rows, then click the **Focus** button to move into the Analytics grid, where you can drill down and analyze the details.

<div align="left"><figure><img src="/files/XUzw4tcHCjVNJyFbEdeF" alt="" width="371"><figcaption></figcaption></figure></div>

{% hint style="success" %}
[Learn how to drill down into your data in Analytics.](/analytics/drill-down-into-your-data-view-transactions.md)
{% endhint %}


---

# 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/financial-statements/using-statements/select-and-focus-on-data-financial-statements.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.