Selecting Cells

Select Cells

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

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

pivotgrid_solidselection

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

pivotgrid_multiselection

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

Copy Cells' Values to the Clipboard

Cells' values can be copied to the clipboard as text. To copy cells' values, select the required cells and press CTRL+C or CTRL+INS.