คู่มือฉบับสมบูรณ์เกี่ยวกับคีย์ลัดที่ใช้บ่อยในโปรแกรมตารางคำนวณ WPS

Fav

WPS Forms Shortcut Key Query

consult (a document etc)

บทนำเกี่ยวกับคีย์ลัดของโปรแกรมตารางคำนวณ WPS:

1. WPS Spreadsheet เป็นแอปพลิเคชันสเปรดชีตที่พัฒนาโดย Kingsoft ซึ่งเป็นบริษัทซอฟต์แวร์จากประเทศจีน และเป็นส่วนหนึ่งของชุดโปรแกรม WPS Office

2. WPS Spreadsheet มีความคล้ายคลึงกับ Microsoft Excel อย่างมาก โดยมีฟังก์ชันสำหรับการสร้าง แก้ไข จัดรูปแบบ และวิเคราะห์สเปรดชีต

3. การเชี่ยวชาญการใช้คีย์ลัดใน WPS Spreadsheet สามารถช่วยประหยัดเวลาของคุณได้มากเมื่อใช้ซอฟต์แวร์นี้

4. คุณสามารถใช้เครื่องมือนี้เพื่อค้นหาคีย์ลัดที่สอดคล้องกับฟังก์ชันเฉพาะได้

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