56 Shortcuts for Kingsoft Spreadsheets 2016 (Windows)  [edit]

minimize Hide all  maximize Show all

minusplus1. Navigation Shortcuts
Arrow Keys Movement in Cells
Ctrl+Home Move to Beginning of Worksheet
Ctrl+PgDn Switches between Worksheet Tabs(Right to Left)
Ctrl+{PgUp Switches between Worksheet from Left to Right
Ctrl+Tab Go to Next Tab
Ctrl+Shift+Tab Go to Previous Tab
Enter Moves One Cell down in Selected Cell Range
Shift+Enter Moves One Cell Up in Selected Cell Range
Home Moves to Cell in Upper Left Corner of Window
PgDn Select Cell in Next Screen in Same Column
PgUp Select Cell in Previous Screen in Same Column
Tab Move one cell to Right
Shift+Tab Move one cell to Left

▲ up

minusplus2. Selection Shortcuts
Ctrl+Arrow Keys Select All Worksheet
Shift+PgDn Select Cell Range from Current Cells to Next Screen of Same Column
Shift+PgUp Select Cell Range from Current Cells to Previous Screen of Same Column

▲ up

minusplus3. Display Various Objects
Alt+F11 Display MS Visual Basic Editor
F7 Display Spelling Check Dialog Box
Alt+F8 Display Macros Dialog Box to Run,Edit or Delete Macros
Alt+Space Display Control Menu from Program Window
Ctrl+1 Display Format Cells Dialog Box
Ctrl+F1 Display Task Pane on Right Side of Program Window
Ctrl+G Display Go to Dialog Box
Ctrl+H Display Replace Dialog Box
Ctrl+F Go to Find Dialog Box
Ctrl+P Display Print Dialog Box
Ctrl+Shift+= Display Insert Dialog Box
Shift+F10 Display Context Menu of Selected Item
Ctrl+O Display Open Dialog Box

▲ up

minusplus4. Other Shortcuts
Alt+Enter Starts New Line in Same Cell
Backspace Clears the content of the active cell to reedit cell content
Ctrl+' Enters the current time
Ctrl+; Enters the current date
Ctrl+B Applies or removes bold formatting
Ctrl+C Copies the selected cells
Ctrl+D Uses the Fill Down command to copy the contents and format of the topmost cell of a selected range into the cells below
Ctrl+End Moves to the last cell on a worksheet, in the lowest used row of the rightmost used column
Ctrl+Enter Fills the selected cell range with the current entry
Ctrl+I Applies or removes italic formatting
Ctrl+N Create New workbook
Ctrl+K Displays the Hyperlink dialog box to insert new hyperlinks or edit existing hyperlinks
Ctrl+S Saves 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+U Applies or removes underlining
Ctrl+V Paste
Ctrl+W Closes the selected workbook window
Ctrl+X Cuts the selected cells
Ctrl+Y Repeats the last command or action, if possible
Ctrl+Z Undo
F1 Help
F11 Insert chart
F12 Displays the Save As dialog box to save the file with a different name, type or location
F2 Edits the active cell and positions the insertion point at the end of the cell contents
F4 Repeats the last action of adding or deleting the Whole Row/Column

▲ up

 

Sources: KingSoft Support


Uploaded by rank17, updated on 9/20/2017 by bernd