SpreadJS 14
Features / Keyboard Actions / Keyboard Navigation Shortcuts
In This Topic
    Keyboard Navigation Shortcuts
    In This Topic

    You can change the active cell or select cells with the mouse or keyboard keys. You can also use keyboard keys to make changes to the cell data.

    The end user can use the following default, keyboard keys:

    KEY ACTION
    Ctrl+Z undo
    Ctrl+Y redo
    Ctrl + Down navigationBottom
    Down navigationDown
    End navigationEnd
    Ctrl+Right navigationEnd
    Ctrl+Home goToSheetBeginning
    Home navigationHome
    Ctrl+Left navigationHome2
    Ctrl+End goToSheetBottomRight
    Left navigationLeft
    Tab moveToNextCell
    PageDown navigationPageDown
    Ctrl+PageUp NavigationPreviousSheet
    Ctrl+PageDown NavigationNextSheet
    PageUp navigationPageUp
    Shift+Tab moveToPreviousCell
    Right navigationRight
    Ctrl+Up navigationTop
    Up navigationUp
    Delete clear
    Back clearAndEditing
    Enter commitInputNavigationDown
    Shift+Enter commitInputNavigationUp
    ESC cancelInput
    Shift+Left selectionLeft
    Shift+Right selectionRight
    Shift+Up selectionUp
    Shift+Down selectionDown
    Shift+Home selectionHome
    Ctrl+Shift+Left selectionHome
    Shift+End selectionEnd
    Ctrl+Shift+Right selectionEnd
    Shift+PageUp selectionPageUp
    Shift+PageDown selectionPageDown
    Ctrl+Shift+Up selectionTop
    Ctrl+Shift+Down selectionBottom
    Ctrl+Shift+Home selectionFirst
    Ctrl+Shift+End selectionLast
    Ctrl+C Copy
    Ctrl+X Cut
    Ctrl+V Paste
    Alt+Enter InputNewLine

    Note: Additional information about copy and paste actions using keyboard shortcuts.

    • SpreadJS does not have direct access to the system clipboard.
    • When using Ctrl+C to copy in SpreadJS, it will perform both outside copy and internal copy.
    • When using Ctrl+V to paste in SpreadJS, it will decide whether to do outside paste or internal paste.
    • When using the content menu or the command manager, SpreadJS always does internal copy and internal paste because it cannot access the system clipboard.

    Additional Keyboard Shortcuts

    SpreadJS supports some additional keyboard shortcut commands. These shortcuts can be included in your project as an extension by downloading and using the Keyboard Shortcuts project available here. You can also add custom shortcuts based on this project.

    KEY ACTION
    Shift + Space selectEntireRow
    Ctrl + Space selectEntireColumn
    Ctrl + "-" deleteEntireRowOrColumn
    Ctrl + 9 hideSelectRows
    Ctrl + [ goToPrecedent
    Ctrl + ] goToDependent
    Ctrl + ; setDate
    Alt + = insertSumFunction
    Alt + Shift + Right Arrow groupSelectRange
    Alt + Shift + Left Arrow ungroupSelectRange
    Alt + ; selectVisibleCells
    Ctrl + D CopyCellDown
    Ctrl + R CopyCellRight
    Ctrl + Shift + "+" InsertRowsOrColumns
    Ctrl + A SelectAll
    Ctrl + B setCellBold
    Ctrl + I setCellItalicize
    Ctrl + U setCellUnderline
    Ctrl + Shift + % setNumberToPrecent