Wednesday, 2 March 2016

The following is the shortcut key list for Kingsoft Spreadsheets 2013. You can also check:

Shortcut keysTo do what
Alt+EnterStarts a new line in the same cell.
Alt+F11Displays the Microsoft Visual Basic Editor
Alt+F8Displays the Macros dialog box to run, edit or delete macros.
Alt+SpaceDisplays the Control menu for the program window
ARROW KEYSMove one cell up, down, left, or right in a worksheet.
BackspaceClears the content of the active cell to reedit cell content.
Ctrl+'Enters the current time.
Ctrl+;Enters the current date.
Ctrl+1Displays the Format Cells dialog box.
Ctrl+Arrow keysSelects the entire worksheet.
Ctrl+Arrow keysMoves to the edge of the current data region in a worksheet.
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+EndCTRL+END moves 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+FDisplays the Find dialog box.
Ctrl+F1Displays the Task Pane on the right side of the program window.
Ctrl+GDisplays the Go To dialog box.
Ctrl+HDisplays the Replace dialog box.
Ctrl+HomeMoves to the beginning of a worksheet.
Ctrl+IApplies or removes italic formatting.
Ctrl+KDisplays the Hyperlink dialog box to insert new hyperlinks or edit existing hyperlinks.
Ctrl+mouse pointerSelects multiple ranges of cells.
Ctrl+NCreates a new, blank workbook.
Ctrl+ODisplays the Open dialog box to open or find a file.
Ctrl+PDisplays the Print dialog box.
Ctrl+PageDownSwitches between worksheet tabs, from right-to-left.
Ctrl+PageUpSwitches between worksheet tabs, from left-to-right.
Ctrl+RUses the Fill Right command to copy the contents and format of the leftmost cell of
a selected range into the cells to the right.
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+Shift+=Displays the Insert dialog box.
Ctrl+Shift+
ARROW KEYS
Extends the selection of cells to the last nonblank cell in the same column or row as
the active cell, or if the next cell is blank, extends the selection to the next nonblank cell.
Ctrl+Shift+HomeExtends the selection of cells to the beginning of the worksheet.
Ctrl+Shift+TabGoes to previous worksheet tab.
Ctrl+TabGoes to next worksheet tab.
Ctrl+UApplies or removes underlining.
Ctrl+VInserts the contents of the Clipboard at the insertion point and replaces any selection.
Ctrl+WCloses the selected workbook window.
Ctrl+XCuts the selected cells.
Ctrl+YRepeats the last command or action, if possible.
Ctrl+ZUses the Undo command to reverse the last command or to delete the last entry you typed.
EnterMoves one cell down in a selected cell range.
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.
F7Displays the Spelling dialog box to check spelling in the active worksheet or selected range.
F9Calculates all worksheets in all open workbooks.
HomeMoves to the cell in the upper-left corner of the window.
Mouse pointerSelects one range of cells.
PageDownSelects the cells in the next screen in the same column(s).
PageUpSelects the cells in the previous screen in the same column(s).
Shift+ARROW KEYSExtends the selection of cells by one cell, or row/column.
Shift+EnterMoves one cell up in a selected cell range.
Shift+f10Displays context menu for a selected item.
Shift+HomeExtends the selection of cells to the first row of this window in this column.
Shift+InsertInserts the contents of the Clipboard at the insertion point and replaces any selection.
Shift+mouse pointerSelects the area from the active cell to the clicked cell.
Shift+PageDownSelects the cell range from the current cells to the next screen of the same column(s).
Shift+PageUpSelects the cell range from the current cells to the previous screen of the same column(s).
Shift+TabMoves to the previous cell in a worksheet, or moves one cell to the left in a selected range.
TabMoves one cell to the right in a worksheet.

No comments:

Post a Comment

Google Search Console doesn’t show data for featured snippets read by Google Assistant

You might already know that there’s no way to discern in Google Search Console which queries came in via voice search and which were typed, ...