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.
Copy Cell Values to the Clipboard
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.
- To allow the selection of more than one data cell at a time, the Pivot Grid Control’s PivotGridOptionsSelection.CellSelection option should be enabled.