Advanced Navigation
Spread provides multiple ways to navigate within the sheet and the control. Besides allowing you to set how the Tab and Enter keys are interpreted by your application, Spread supports the following navigation keys:
Key | Action |
---|---|
up arrow | Moves active cell up one row |
down arrow | Moves active cell down one row |
right arrow | Moves active cell right one column |
left arrow | Moves active cell left one column |
Shift+arrow key | Extends selection in direction of arrow key |
Page Up | Moves active cell one page up |
Page Down | Moves active cell one page down |
Ctrl+Page Up | Moves active cell one page left for a single sheet. Moves the active sheet one sheet to the left with multiple sheets |
Ctrl+Page Down | Moves active cell one page right for a single sheet. Moves the active sheet one sheet to the right with multiple sheets |
Home | Moves active cell to first cell in row |
End | Moves active cell to last cell in row that contains data |
Ctrl+Home | Moves active cell to first row, first column |
Ctrl+End | Moves active cell to last row and column that contain data |
Tab | If the ProcessTab property is set to True or the SSB_PROCESSTAB option for the SSSetBool function is set to True, moves active cell to next cell to the right (or at end of row moves to beginning of next row) |
Shift+Tab | If the ProcessTab property is set to True or the SSB_PROCESSTAB option for the SSSetBool function is set to True, moves active cell to next cell to the left (or at beginning of row moves up to end of row above) |
Shift+space | Selects current row |
Ctrl+space | Selects current column |
Shift+Ctrl+space | Selects entire sheet |
Ctrl+X or Shift+Del | Cuts current selection or active cell's data to Clipboard |
Ctrl+V or Shift+Ins | Pastes Clipboard contents into active cell |
Ctrl+C or Ctrl+Ins | Copies current selection or active cell's data to Clipboard |
Enter | Depends on setting of the EditEnterAction property or SSSetEditEnterAction function |
Esc | If sheet is in edit mode, previous cell value replaces new value and edit mode is turned off |
F2 | If edit mode is on, cell value is cleared |
F3 | If edit mode is on in a date or time cell, current date or time is placed in cell |
F4 | If edit mode is on in a date cell, sheet displays a pop-up calendar to let you choose a date |
For information about specifying how the control handles the Tab and Enter keys, see Using the Tab Key to Move Between Cells and Using the Enter Key to Move Between Cells.
If you prefer, you can change or turn off the F2, F3, or F4 keys. For instructions for changing the action key settings, see Changing or Turning Off the Action Keys.