---
title: "Selecting and Copying Pivot Report Cells"
slug: "selecting-and-copying-pivot-report-cells"
updated: 2026-11-10T16:25:08Z
published: 2026-11-10T16:25:08Z
canonical: "docs.avontus.com/selecting-and-copying-pivot-report-cells"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://docs.avontus.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Selecting and Copying Pivot Report Cells

In addition to [exporting a pivot report](/v1/docs/exporting-a-pivot-report), you can select, copy and paste data from the pivot grid into other programs, including Excel and Word.

## Selecting Cells

You can select a continuous range of cells, multiple cells that are not within a continuous range and all cells in the data area of any pivot report.

### Continuous Range

To select a continuous range of cells, do one of the following:

- Click the initial cell, hold the SHIFT key and use the arrow keys to select the range of cells.
- Click the initial cell, hold the SHIFT key and click the last cell in the range.
- Click the initial cell, hold the left mouse key drag and the cursor over the appropriate cells to select the range of cell

### ![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/182aede9-b7c5-4440-81c5-dfdb95ca6edc.png)

### Non-Continuous Cells

To select multiple cells that are not within a continuous range, hold the CTRL key and click the cells, one by one.

![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/7ef92ab4-d8e5-4805-8867-7bb7f4dd4814.png)

### All Cells

To select all the cells in the data area, click CTRL+A.

![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/42703933-bbee-497d-a5a0-bc2bc81e28be.png)

## Copying Cell Values to the Clipboard

Copy cell values by selecting the required cells and pressing CTRL+C or CTRL+INS. Then, access the program of your choice (Excel, Word, Notepad, etc.) and use CTRL+V to paste the copied data (You can also right-click your mouse and select **Paste** from the menu that appears).

![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/1b6fa602-1f71-4361-98ad-12ba656f0689.png)