WPS table shortcuts

wps table shortcut key query

query

WPS table shortcuts Introduction

About WPS form shortcuts:

1. WPS Form is a spreadsheet software developed by Chinese company Kingsoft, which is part of the WPS Office suite.

2. WPS tables are very similar to Microsoft Excel, providing the ability to create, edit, format and analyze spreadsheets.

3, skilled grasp of the shortcut keys in the WPS form, you can use the WPS form software, save a lot of time.

4, you can use this tool to search for the corresponding shortcut keys.

wps system shortcut keys

function	shortcut key
help	F1
task pane	Ctrl+F1
create a new blank document	Ctrl+N
switch to the previous worksheet of the activity worksheet	Ctrl+PageUp
switch to the next worksheet of the active worksheet	Ctrl+PageDown

edit cell shortcut keys

function	shortcut key
move the cursor to the end of the cell content	F2
type the same data into multiple cells	Ctrl+Enter
line break operation in a cell	Alt+Enter
go to edit and re-edit the cell content	back space
type the current date	Ctrl+;
type the current time	Ctrl+Shift+;

locate cell shortcut keys

function	shortcut key
move to the edge of the current data area	ctrl+arrow keys
position to the beginning of the row in the pane where the active cell is located	Home
move to the beginning of the worksheet	Ctrl＋Home
move to the last cell position of the worksheet, which is located in the bottom row of the rightmost column occupied by the data	Ctrl＋End

change the selection area shortcut key

function	shortcut key
change the currently selected cell and cancel the original selected cell	direction keys
extend the currently selected region to adjacent 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+directory keys
extend the selected area to the beginning of the row	Shift+Home
extend the selected area to the beginning of the worksheet	Ctrl+Shift+Home
extend the selected area to the last used cell on the worksheet (bottom right corner)	Ctrl+Shift+End
select the entire worksheet	Ctrl+A
select an area	mouse selection
select multiple areas	ctrl+mouse selection
select the area from the active cell to the clicked cell	shift+mouse click
move from left to right in the selected area. if a cell in a single column is selected, move down	Tab
move from right to left in the selected area. if a cell in a single column is selected, move upward	Shift+Tab
move from top to bottom in the selected area. if a cell in a single column is selected, move down	Enter
move from bottom to top in the selected area. if a cell in a single column is selected, move upward	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 input, edit, format and calculate data

function	shortcut key
complete cell input and select the next cell	Enter
wrap lines in a cell	Alt+Enter
fill the selected cell area with the current input item	Ctrl+Enter
complete cell input and select the previous cell upwards	Shift+Enter
complete cell input and select the next cell to the right	Tab
complete cell input and select the previous cell to the left	Shift+Tab
cancel cell input	Esc
move one character up, down, left or right	arrow keys
move to the beginning of the line	Home
repeat the last operation	f4 or ctrl+y
create a name from the row and column flags	Ctrl+Shift+F3
fill down	Ctrl+D
fill to the right	Ctrl+R
define a name	Ctrl+F3
insert hyperlink	Ctrl+K
activate hyperlink	enter (in a cell with a hyperlink)
enter date	ctrl+; (semi-colon)
enter time	ctrl+shift+: (colon)
show the value in the current column of the list drop-down list	alt+down arrow key
show the value in the current column of the list drop-down list	alt+down arrow key
undo the last operation	Ctrl+Z

WPS table shortcuts

wps table shortcut key query

WPS table shortcuts Introduction

Internet Business Promoter

Least common multiple calculator

Prime number (prime number) online calculation generation

Chinese emperors query

Chinese idiom fill in the blank

Online coin toss

Japanese traditional Color

CSS Ground Glass Effect Generator

CSS with triangular bubble frame online generation

Children's Sleep Calculator

FTP login tool

Zero Coupon Treasury Yield Calculator

META Detection of Web pages

Picture to SVG

Traffic Sign pictures

World Festival Inquiry

JS code confusion

Screen online detection tool

Female self-assessment

Speed converter

Text to binary conversion tool

UUID Generator

HTTP status Query Tool

Periodic Table

Regular expression complete

introduce

Attention

Contact Us