[]
        
(Showing Draft Content)

Keyboard Navigation Shortcuts

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

PageUp

navigationPageUp

Ctrl+PageUp

NavigationPreviousSheet

Ctrl+PageDown

NavigationNextSheet

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: The Ctrl+PageUp and Ctrl+PageDown keyboard shortcuts only work when there is no conflict with the host environment.

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 context 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