Shortcuts Kingsoft Spreadsheets for Windows

55 shortcuts2,922 views
Open Trainer

Navigation Shortcuts

WindowsAction
Arrow KeysMovement in Cells
Ctrl+HomeMove to Beginning of Worksheet
Ctrl+PgDnSwitches between Worksheet Tabs(Right to Left)
Ctrl+{PgUpSwitches between Worksheet from Left to Right
Ctrl+TabGo to Next Tab
Ctrl+Shift+TabGo to Previous Tab
EnterMoves One Cell down in Selected Cell Range
Shift+EnterMoves One Cell Up in Selected Cell Range
HomeMoves to Cell in Upper Left Corner of Window
PgDnSelect Cell in Next Screen in Same Column
PgUpSelect Cell in Previous Screen in Same Column
TabMove one cell to Right
Shift+TabMove one cell to Left

Selection Shortcuts

WindowsAction
Ctrl+Arrow KeysSelect All Worksheet
Shift+PgDnSelect Cell Range from Current Cells to Next Screen of Same Column
Shift+PgUpSelect Cell Range from Current Cells to Previous Screen of Same Column

Display Various Objects

WindowsAction
Alt+F11Display MS Visual Basic Editor
F7Display Spelling Check Dialog Box
Alt+F8Display Macros Dialog Box to Run,Edit or Delete Macros
Alt+SpaceDisplay Control Menu from Program Window
Ctrl+1Display Format Cells Dialog Box
Ctrl+F1Display Task Pane on Right Side of Program Window
Ctrl+GDisplay Go to Dialog Box
Ctrl+HDisplay Replace Dialog Box
Ctrl+FGo to Find Dialog Box
Ctrl+PDisplay Print Dialog Box
Ctrl+Shift+=Display Insert Dialog Box
Shift+F10Display Context Menu of Selected Item
Ctrl+ODisplay Open Dialog Box

Other Shortcuts

WindowsAction
Alt+EnterStarts New Line in Same Cell
BackspaceClears the content of the active cell to reedit cell content
Ctrl+'Enters the current time
Ctrl+;Enters the current date
Ctrl+BApplies or removes bold formatting
Ctrl+CCopies the selected cells
Ctrl+DUses the Fill Down command to copy the contents and format of the topmost cell of a selected range into the cells below
Ctrl+EndMoves to the last cell on a worksheet, in the lowest used row of the rightmost used column
Ctrl+EnterFills the selected cell range with the current entry
Ctrl+IApplies or removes italic formatting
Ctrl+NCreate New workbook
Ctrl+KDisplays the Hyperlink dialog box to insert new hyperlinks or edit existing hyperlinks
Ctrl+SSaves the active file with its current file name, location, and file format
Ctrl+Shift+'Enters the current time
Ctrl+Shift+;Enters the current time
Ctrl+UApplies or removes underlining
Ctrl+VPaste
Ctrl+WCloses the selected workbook window
Ctrl+XCuts the selected cells
Ctrl+YRepeats the last command or action, if possible
Ctrl+ZUndo
F1Help
F11Insert chart
F12Displays the Save As dialog box to save the file with a different name, type or location
F2Edits the active cell and positions the insertion point at the end of the cell contents
F4Repeats the last action of adding or deleting the Whole Row/Column