Kingsoft Spreadsheets Shortcut Keys Download PDF
Kingsoft Spreadsheets Shortcut Keys
A spreadsheet is an interactive pc utility for employer, evaluation and storage of information in tabular form.Spreadsheets are evolved as automated simulations of paper accounting worksheets. this system operates on data entered in cells of a desk. every cell might also comprise both numeric or textual content records, or the consequences of formulas that robotically calculate and display a price based at the contents of other cells. A spreadsheet may additionally talk to one such electronic document.
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