You can select data in a financial statement, such as a list of account names and their values. You can then quickly analyze the average, count and sum (where applicable) of that selected data. You can also copy the selected data for use elsewhere, such as a Microsoft Excel worksheet, removing the next to export the whole statement.
Select data
Expand the rows that contain the data. Click the first data item (account/group/cell), then use one of these options to select the other items:
Drag your mouse over the items you want to include in the selection.
Press and hold the Shift key, click the last item you want to include in the selection, then release the Shift key.
Press and hold the Ctrl key, click the other item(s) you want to include in the selection, then release the Ctrl key.
View average, count and sum
When you select a range of data, the following information displays in a status bar at the bottom of the grid:
Average of the selected cells (if they contain numerical data).
Count of selected items or cells.
Sum of selected cells (if they contain numerical data).
Copy data
To copy the selected data, right-click an item in the selection, then click Copy. Paste the selection into the required external destinationapplication.
