63 WPS Spreadsheets Keyboard Shortcuts

Photo of Devil DevilLast Updated: October 27, 2025
3 minutes read

Learn WPS Spreadsheets Shortcuts for Windows

Most used WPS Spreadsheets Shortcuts

ActionWPS Spreadsheets Shortcuts
Start a new line in the same cellAlt + Enter
Display the Microsoft Visual Basic EditorAlt + F11
Display the Macros dialog box to run, edit, or delete macrosAlt + F8
Display the Control menu for the program windowAlt + Spacebar
Move one cell up, down, left, or right in a worksheetArrow keys
Clear the content of the active cell to re-edit cell contentBackspace
Enter the current timeCtrl + ‘
Enter the current dateCtrl + ;
Display the Format Cells dialog boxCtrl + 1
Select the entire worksheetCtrl + Arrow keys
Move to the edge of the current data region in a worksheetCtrl + Arrow keys
Apply or remove bold formattingCtrl + B
Copy selected cellsCtrl + C
Uses the Fill Down command to copy the contents and format of the topmost cell of a selected range into the cells belowCtrl + D
Move to the last cell on a worksheet, in the lowest used row of the rightmost used columnCtrl + End
Fill the selected cell range with the current entryCtrl + Enter
Display the Find dialog boxCtrl + F
Display the Task Pane on the right side of the program windowCtrl + F1
Display the Go To dialog boxCtrl + G
Display the Replace dialog boxCtrl + H
Move to the beginning of a worksheetCtrl + Home
Apply or remove italic formattingCtrl + I
Display the Hyperlink dialog box to insert new hyperlinks or edit existing hyperlinksCtrl + K
Select multiple ranges of cellsCtrl + Left Mouse Click
Create a new, blank workbookCtrl + N
Display the Open dialog box to open or find a fileCtrl + O
Display the Print dialog boxCtrl + P
Switch between worksheet tabs, from right-to-leftCtrl + Page Down key
Switch between worksheet tabs, from left-to-rightCtrl + Page Up Key
Use the Fill Right command to copy the contents and format of the leftmost cell of a selected range into the cells to the rightCtrl + R
Save the active file with its current file name, location, and file formatCtrl + S
Enter the current timeCtrl + Shift + ‘
Displays the Insert dialog boxCtrl + Shift + =
Extend 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, extend the selection to the next nonblank cellCtrl + Shift + Arrow keys
Extend the selection of cells to the beginning of the worksheetCtrl + Shift + Home
Go to the previous worksheet tabCtrl + Shift + Tab
Go to the next worksheet tabCtrl + Tab
Apply or remove underliningCtrl + U
Insert the contents of the Clipboard at the insertion point and replace any selectionCtrl + V
Close the selected workbook windowCtrl + W
Cut the selected cellsCtrl + X
Repeat the last command or action, if possibleCtrl + Y
Reverse the last command or delete the last entry you typedCtrl + Z
Move one cell down in a selected cell rangeEnter
HelpF1
Edit the active cell and position the insertion point at the end of the cell contentsF2
Repeat the last action of adding or deleting the whole row/columnF4
Display the Spelling dialog box to check spelling in the active worksheet or selected rangeF7
Calculate all worksheets in all open workbooksF9
Insert chartF11
Display the Save As dialog box to save the file with a different name, type or locationF12
Move to the cell in the upper-left corner of the windowHome
Select the cells in the next screen in the same column(s)Page Down key
Select the cells in the previous screen in the same column(s)Page Up Key
Extend the selection of cells by one cell, or row/column in that directionShift + Arrow keys
Move one cell up in a selected cell rangeShift + Enter
Display context menu for a selected itemShift + F10
Extend the selection of cells to the first row of this window in this columnShift + Home
Insert the contents of the Clipboard at the insertion point and replace any selectionShift + Insert
Select the cell range from the current cells to the next screen of the same column(s)Shift + Page Down key
Select the cell range from the current cells to the previous screen of the same column(s)Shift + Page Up Key
Move to the previous cell in a worksheet, or move one cell to the left in a selected rangeShift + Tab
Move one cell to the right in a worksheetTab
Download WPS Spreadsheets Shortcuts PDF

READ NEXT:

Photo of Devil DevilLast Updated: October 27, 2025
3 minutes read
Back to top button