Shortcuts Kingsoft Spreadsheets for Windows

55 shortcuts2,921 views

Navigation Shortcuts

	Windows	Action
	`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

	Windows	Action
	`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

	Windows	Action
	`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

	Windows	Action
	`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