WPS Spreadsheets keyboard shortcuts

WPS Spreadsheets

Zeynel -
4 months ago
- Shortcuts
0
Alt + ⤶ Enter

Start a new line in the same cell

0
Alt + F11

Display the Microsoft Visual Basic Editor

0
Alt + F8

Display the Macros dialog box to run, edit or delete macros

0
Alt + Space

Display the Control menu for the program window

0

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

0
Backspace

Clear the content of the active cell to re-edit cell content

-1
Ctrl + '

Enter the current time

0
Ctrl + ;

Enter the current date

0
Ctrl + 1

Display the Format Cells dialog box

0
Ctrl +

Select the entire worksheet

0
Ctrl +

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

0
Ctrl + B

Apply or remove bold formatting

0
Ctrl + C

Copy selected cells

0
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

0
Ctrl + End

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

0
Ctrl + ⤶ Enter

Fill the selected cell range with the current entry

0
Ctrl + F

Display the Find dialog box

0
Ctrl + F1

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

0
Ctrl + G

Display the Go To dialog box

0
Ctrl + H

Display the Replace dialog box

0
Ctrl + Home

Move to the beginning of a worksheet

0
Ctrl + I

Apply or remove italic formatting

0
Ctrl + K

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

0
Ctrl +

Select multiple ranges of cells

0
Ctrl + N

Create a new, blank workbook

0
Ctrl + O

Display the Open dialog box to open or find a file

0
Ctrl + P

Display the Print dialog box

0
Ctrl + Page Down

Switch between worksheet tabs, from right-to-left

0
Ctrl + Page Up

Switch between worksheet tabs, from left-to-right

0
Ctrl + R

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

0
Ctrl + S

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

0
Ctrl + ↑  Shift + '

Enter the current time

0
or Ctrl + ↑  Shift + ;
0
Ctrl + ↑  Shift + =

Displays the Insert dialog box

0
Ctrl + ↑  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 cell

0
Ctrl + ↑  Shift + Home

Extend the selection of cells to the beginning of the worksheet

0
Ctrl + ↑  Shift + Tab

Go to previous worksheet tab

0
Ctrl + Tab

Go to next worksheet tab

0
Ctrl + U

Apply or remove underlining

0
Ctrl + V

Insert the contents of the Clipboard at the insertion point and replace any selection

0
Ctrl + W

Close the selected workbook window

0
Ctrl + X

Cut the selected cells

0
Ctrl + Y

Repeat the last command or action, if possible

0
Ctrl + Z

Reverse the last command or to delete the last entry you typed

0
⤶ Enter

Move one cell down in a selected cell range

0
F1

Help

0
F2

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

0
F4

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

0
F7

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

0
F9

Calculate all worksheets in all open workbooks

0
F11

Insert chart

0
F12

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

0
Home

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

0
Page Down

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

0
Page Up

Select the cells in the previous screen in the same column(s)

0
↑  Shift +

Extend the selection of cells by one cell, or row/column in that direction

0
↑  Shift + ⤶ Enter

Move one cell up in a selected cell range

0
↑  Shift + F10

Display context menu for a selected item

0
↑  Shift + Home

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

Advertisement

0
↑  Shift + Insert

Insert the contents of the Clipboard at the insertion point and replace any selection

0
↑  Shift +

Select the area from the active cell to the clicked cell

0
Shift + Page Down

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

0
Shift + Page Up

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

0
↑  Shift + Tab

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

0
Tab

Move one cell to the right in a worksheet

Source: WPS Help Center

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

Advertisement

Program information

Program name: WPS Spreadsheets WPS Spreadsheets (Productivity)

WPS Spreadsheet is a free Excel editor for effortless sheet creation, editing, saving, and sharing. WPS Spreadsheet supports 17 file formats, including .xls, .xlsx, .xlsm, .xlt, .csv, .txt, .pdf and more.

Web page: wps.com/office/spreadsheet

How easy to press shortcuts: 85%

More information >>

Updated: Updated program information. (2 updates.) 12/20/2023 9:14:45 AM New program added.
12/20/2023 9:17:01 AM Updated program information.

Shortcut count: 65

Platform detected: Windows or Linux


User operations

Add WPS Spreadsheets to favorites

Add to favorites

Advertisement


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


 
No comments yet. Ask, or type the first one!