WPS table common shortcut keys

Fav

WPS Forms Shortcut Key Query

consult (a document etc)

Introduction to WPS Spreadsheet Shortcut Keys:

1. WPS Spreadsheet is a spreadsheet application developed by Kingsoft, a Chinese software company, and is part of the WPS Office suite.

2. WPS Spreadsheet is very similar to Microsoft Excel and provides functions for creating, editing, formatting, and analyzing spreadsheets.

3. Mastering the shortcut keys in WPS Spreadsheet can save you a significant amount of time when using the software.

4. You can use this tool to search for shortcut keys corresponding to specific functions.

WPS system shortcuts

functionality	(computer) shortcut key
hand	F1
task pane	Ctrl+F1
New Blank Document	Ctrl+N
Switch to the previous worksheet of the active worksheet	Ctrl+PageUp
Switch to the next worksheet in the active worksheet	Ctrl+PageDown

Edit Cell Shortcuts

functionality	(computer) shortcut key
Move the cursor to the end of the cell content	F2
Type the same data into multiple cells.	Ctrl+Enter
Row-wrapping in cells	Alt+Enter
Go to Edit and re-edit the cell contents	Back Space
Type the current date	Ctrl+;
Type the current time	Ctrl+Shift+;

Positioning Cell Shortcuts

functionality	(computer) shortcut key
Move to the edge of the current data area	Ctrl+Arrow keys
Position to the beginning of the row of the pane where the active cell is located	Home
Move to the beginning of the worksheet	Ctrl＋Home
Move to the last cell position on the worksheet, which is in the bottom row of the rightmost column occupied by the data	Ctrl＋End

Change Selection Area Shortcut

functionality	(computer) shortcut key
Changes the currently selected cell and unselects the previously selected cell.	arrow key
Extend the current selection to neighboring rows and columns.	Shift+Direction
Extend the selected area to the last non-empty cell in the same column or row as the active cell.	Ctrl+Shift+Arrow keys
Extend the selected area to the beginning of the line	Shift+Home
Extend the selected area to the beginning of the worksheet	Ctrl+Shift+Home
Extend the selected area to the last cell used on the worksheet (lower right corner)	Ctrl+Shift+End
Selecting an entire worksheet	Ctrl+A
Select an area	Mouse Selection
Select multiple areas	Ctrl+Mouse Selection
Selecting the area between the active cell and the clicked cell	Shift + mouse click
Moves from left to right in the selected area. Moves down if cells in a single column are selected	Tab
Moves from right to left in the selected area. Moves up if cells in a single column are selected	Shift+Tab
Moves from top to bottom in the selected area. Moves down if cells in a single column are selected	Enter
Moves from the bottom up in the selected area. Moves up if cells in a single column are selected	Shift+Enter
Select the cell on the previous screen of the active cell	PageUp
Select the cell on the next screen of the active cell	PageDown
Select the area from the active cell to the corresponding cell on the previous screen	Shift+PageUp
Select the area from the active cell to the corresponding cell on the next screen.	Shift+PageDown

Keys for entering, editing, formatting and calculating data

functionality	(computer) shortcut key
Complete cell entry and select the next cell	Enter
Row breaks in cells	Alt+Enter
Fill the selected cell area with the current entry	Ctrl+Enter
Finish cell entry and select up the previous cell	Shift+Enter
Finish cell entry and select the next cell to the right	Tab
Complete cell entry and select previous cell to the left	Shift+Tab
Cancel cell entry	Esc
Move one character up, down, left or right	arrow key (on keyboard)
move to the beginning of the line	Home
Repeat the previous operation	F4 or Ctrl+Y
Creating a name from a row or column sign	Ctrl+Shift+F3
underfill	Ctrl+D
Fill Right	Ctrl+R
Define name	Ctrl+F3
Insert Hyperlink	Ctrl+K
Activate hyperlink	Enter (in a cell with a hyperlink)
Enter date	Ctrl+; (semicolon)
input time	Ctrl+Shift+: (colon)
Displays a drop-down list of the values in the current column of the list.	Alt+Down Key
Displays a drop-down list of the values in the current column of the list.	Alt+Down Key
Undo last operation	Ctrl+Z