Tổng hợp các phím tắt thường dùng trong WPS Spreadsheet

Fav

WPS Forms Shortcut Key Query

consult (a document etc)

Giới thiệu về các phím tắt trong WPS Spreadsheet:

1. WPS Spreadsheet là phần mềm bảng tính được phát triển bởi công ty Kingsoft của Trung Quốc, là một phần của bộ phần mềm văn phòng WPS Office.

2. WPS Spreadsheet rất giống với Microsoft Excel, cung cấp các chức năng tạo, chỉnh sửa, định dạng và phân tích bảng tính.

3. Việc thành thạo các phím tắt trong WPS Spreadsheet sẽ giúp bạn tiết kiệm rất nhiều thời gian khi sử dụng phần mềm này.

4. Bạn có thể sử dụng công cụ này để tìm kiếm các phím tắt tương ứng với các chức năng.

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