Jump to: Navigation Shortcuts, Selection Shortcuts, Display Various Objects, Other 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 |
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 |
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 |
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 |
Created by rank17 on 5/29/2017. Last updated by admin on 12/26/2020
Advertising for Consideration:
Ads for Consideration:
Please kindly review and accept Terms of Use and Cookie & Policy Policy
6 Comments for 'Kingsoft Spreadsheets 2016' [post comment in main thread]
Comment #6 by Jaimanoj May 19, 2022 at 02:36 am Reply
Need Keyboard shortcut to select entire row
Comment #5 by dddd Dec 25, 2020 at 11:40 pm Reply
Need shortcut for wrap text
Comment #4 by Arunsanthosh Aug 26, 2020 at 09:56 am Reply
How to apply filter by shortcut Ctrl+Shift+L not working
Comment #3 by syam Jan 8, 2018 at 06:56 am Reply
how to compressing 10 images one time to do any have ?? short cut key
Reply #1 kammi Jun 24, 2021 at 11:18 pm
Alt>D>F>F
Comment #2 by Govinda Maltare Nov 23, 2017 at 01:06 am Reply
how i can use menu options without using mouse or using keyboard only?
Comment #1 by GANDHI Aug 14, 2017 at 04:42 am Reply
Is there any key board short cut to move between opened workbooks?
Reply #1 ABC Aug 14, 2017 at 12:40 pm
Ctrl+Tab may be