WPS 테이블 일반 단축키 전체

저장

WPS Forms Shortcut Key Query

consult (a document etc)

WPS 스프레드시트 단축키 소개:

1. WPS 스프레드시트는 중국의 진산 소프트웨어(Kingsoft)에서 개발한 스프레드시트 소프트웨어로, WPS Office 오피스 제품군의 일부입니다.

2. WPS 스프레드시트는 Microsoft Excel과 매우 유사하며, 스프레드시트 생성, 편집, 서식 지정 및 분석 기능을 제공합니다.

3. WPS 스프레드시트의 단축키를 능숙하게 활용하면, WPS 스프레드시트 사용 시 많은 시간을 절약할 수 있습니다.

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