Selecting Cells

Select Cells

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

Focus the initial cell, hold the SHIFT key and select the range of cells via the ARROW keys.
Focus the initial cell, hold the SHIFT key and click the last cell in the range.
Focus the initial cell, hold the left mouse key and select the range of cells with the mouse.

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

To select all the cells in the Data Area, use the CTRL+A shortcut.

Cell values can be copied to the Clipboard as text. To copy cell values, select the required cells and press CTRL+C or CTRL+INS.

Note

To allow the selection of more than one data cell at a time, the Pivot Grid Control’s PivotGridOptionsSelection.CellSelection option should be enabled.