Selecting Cells
- 2 minutes to read
The ExpressPivotGrid control allows end-users to select multiple data cells using the mouse or the available keyboard shortcuts. The data, which is displayed by the selected cells, can be copied to the clipboard and pasted into other applications (e.g. MS Excel, MS Word, etc.)
Selecting Data Cells
| Action | Effect |
|---|---|
| Pressing the Shift+Arrow key combination or dragging the mouse. | Enables end-users to select a continuous range of data cells. When such actions are carried out, any previous cell selection is cleared. |
| Clicking cells or dragging the mouse while holding down the Ctrl key. | Adds the specified range of data cells into the selection. This allows end-users to select non-contiguous ranges within the data area. |
| Clicking column/row headers. | Selects all data cells corresponding to the column or row header being clicked. Clicking headers while holding down the Ctrl key adds corresponding data cells into the selection. |
| Pressing the Ctrl+A key combination. | Selects all data cells within the data area. This clears the current selection and creates a new cell region with the Left and Top properties set to 0 and the Right and Bottom properties set to MaxInt. |
Copying Selected Records to the Clipboard
| Action | Effect |
|---|---|
| Pressing the Ctrl+C or Ctrl+Ins key combination. | Copies the selected data cells to the clipboard as text. |
Note
Use the pivot grid’s OptionsSelection.MultiSelect property to allow more than one data cell to be selected at one time. To specify which data cells can be selected by end-users, use the pivot grid’s OptionsSelection.IncludeCells property.