WPS Office keyboard shortcuts 

WPS Office    

Zeynel -
7 years ago
- Shortcuts
0
Tab

Moves one cell to the right in a worksheet

0
⤶ Enter

Moves one cell down in a selected cell range

0
F1

Help

3
Ctrl + C

Copies the selected cells

0
Ctrl + S

Saves the active file with its current file name, location and file format

1
F2

Edits the active cell and positions the insertion point at the end of the cell contents

1
Ctrl + Z

Uses the Undo command to reverse the last command or to delete the last entry you typed

0
Ctrl + V

Inserts the contents of the Clipboard at the insertion point and replaces any selection

2

Selects one range of cells

0
Ctrl + F

Displays the Find dialog box

0
Ctrl + X

Cuts the selected cells

‎−1
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

1
Ctrl + N

Creates a new, blank workbook

0
Ctrl + O

Displays the Open dialog box to open or find a file

1
Ctrl + P

Displays the Print dialog box

0
Ctrl + I

Applies or removes italic formatting

0
Ctrl + R

Uses the Fill Right command to copy the contents and format of the leftmost cell of a selected range into the cells to the right

‎−1
F4

Repeats the last action of adding or deleting the whole row/column

0
Ctrl + Y

Repeats the last command or action, if possible

0
Ctrl + B

Applies or removes bold formatting

0
F9

Calculates all worksheets in all open workbooks

0
Home

Moves to the cell in the upper-left corner of the window

0
F7

Displays the Spelling dialog box to check spelling in the active worksheet or selected range

1
Ctrl + G

Displays the Go To dialog box

0
Backspace

Clears the content of the active cell to reedit cell content

0
F11

Insert chart

‎−1

Move one cell up, down, left, or right in a worksheet.

0
Ctrl + U

Applies or removes underlining

‎−1
Ctrl + W

Closes the selected workbook window

0
Page Down

Selects the cells in the next screen in the same column(s)

0
Page Up

Selects the cells in the previous screen in the same column(s).

0
Ctrl + H

Displays the Replace dialog box

0
Ctrl + K

Displays the Hyperlink dialog box to insert new hyperlinks or edit existing hyperlinks

0
F12

Displays the Save As dialog box to save the file with a different name, type or location

0
Ctrl + ⤶ Enter

Fills the selected cell range with the current entry

0
↑  Shift + Tab

Moves to the previous cell in a worksheet, or moves one cell to the left in a selected range

0
Ctrl + 1

Displays the Format Cells dialog box

0
Ctrl + Tab

Goes to next worksheet tab

0
↑  Shift + ⤶ Enter

Moves one cell up in a selected cell range

0
↑  Shift +

Selects the area from the active cell to the clicked cell

1
Alt + ⤶ Enter

Starts a new line in the same cell

0
Ctrl + Home

Moves to the beginning of a worksheet

0
Ctrl +

Selects multiple ranges of cells

0
Ctrl + End

Moves to the last cell on a worksheet, in the lowest used row of the rightmost used column

0
Ctrl + ↑  Shift + Tab

Goes to previous worksheet tab

0
Ctrl + Page Down

Switches between worksheet tabs, from right-to-left

2
Ctrl + Page Up

Switches between worksheet tabs, from left-to-right

0
↑  Shift + F10

Displays context menu for a selected item

0
↑  Shift +

Extends the selection of cells by one cell, or row/column

0
Ctrl + F1

Displays the Task Pane on the right side of the program window

0
↑  Shift + Insert

Inserts the contents of the Clipboard at the insertion point and replaces any selection

0
↑  Shift + Home

Extends the selection of cells to the first row of this window in this column

0
Shift + Page Up

Selects the cell range from the current cells to the previous screen of the same column(s)

0
Shift + Page Down

Selects the cell range from the current cells to the next screen of the same column(s)

0
Ctrl + ↑  Shift + Home

Extends the selection of cells to the beginning of the worksheet.

‎−2
Ctrl +

Selects the entire worksheet

0
Ctrl +

Moves to the edge of the current data region in a worksheet

‎−2
Alt + F8

Displays the Macros dialog box to run, edit or delete macros.

1
Alt + Space

Displays the Control menu for the program window

Advertisement

1
Ctrl + ;

Enters the current date.

‎−2
Ctrl + '

Enters the current time.

‎−5
Alt + F11

Displays the Microsoft Visual Basic Editor

0
Ctrl + ↑  Shift + =

Displays the Insert dialog box

‎−1
Ctrl + ↑  Shift +

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

0
Ctrl + ↑  Shift + '

Enters the current time

‎−1
or Ctrl + ↑  Shift + ;

Advertisement


Share this page on:
Is this page helpful?
0 0

Program information

Program name: WPS Office WPS Office (Productivity)

Web page: wps.com

Last update: 1398/12/24 19:04 UTC

How easy to press shortcuts: 85%

More information >>

Updated: Updated program information. (3 updates.) 1398/12/24 19:03:36 Added some shortcuts.
1398/12/24 19:04:19 Added some shortcuts.
1398/12/24 19:05:03 Updated program information.

Shortcut count: 66

Platform detected: Windows or Linux

Similar programs



User operations

Add WPS Office to your list of favorites

Advertisement


What is your favorite WPS Office hotkey? Do you have any useful tips for it? Let other users know below.


Only registered users can post links.
 
No comments yet. Ask, or type the first one!

Latest articles