Spread 8.0 Documentation
Advanced Navigation
Support Options
User's Guide > Introduction to Spread > The fpSpread Control > Features > Advanced Navigation

Glossary Item Box

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.

© 2002-2014 ComponentOne, a division of GrapeCity. All Rights Reserved.