* This action depends on your layout direction.
|
Advertisement
* This action depends on your layout direction.
|
|||
** In case of multiple selection layers, only the last selection layer gets extended.
|
* This action depends on your layout direction.
|
These keyboard shortcuts work when the CopyPaste plugin is enabled.
|
These keyboard shortcuts work when the MergeCells plugin is enabled.
|
These keyboard shortcuts work when the UndoRedo plugin is enabled.
|
These keyboard shortcuts work in context menus. To activate them, enable the ContextMenu plugin.
|
|||
Source: Handsontable docs
|
|||
|
Clear the contents of the selected cells |
||
|
Delete one character before the cursor* |
||
|
Close the context menu or submenu |
||
|
Cancel the cell entry and exit the editing mode |
||
|
Move the cursor to the end of the text* |
||
|
Move the cursor to the beginning of the text* |
||
|
Move to the first non-frozen cell of the current row* |
||
|
Copy the contents of the selected cells to the system clipboard |
||
|
Cut the contents of the selected cells to the system clipboard |
||
|
Delete one character after the cursor* |
||
|
Clear the contents of the selected cells |
||
|
Paste from the system clipboard |
||
|
Redo the last action |
||
|
Select all cells and headers |
||
|
Undo the last action |
||
|
Move to the first cell of the current column |
||
|
Move to the last cell of the current column |
||
|
Merge or unmerge the selected cells |
||
|
Complete the cell entry and move to the cell above |
||
|
Move to the leftmost cell of the current row |
||
|
Move to the rightmost cell of the current row |
||
|
Enter the editing mode of the active cell |
||
|
Move to the next cell* (if there's only one column available, move one cell down) |
||
|
Complete the cell entry and move to the next cell* |
||
|
Complete the cell entry and move to the cell below |
||
|
Run the action of the selected menu item |
||
|
Extend the selection to the last cell of the current column** |
||
|
Extend the selection to the first cell of the current column** |
||
|
Move to the previous cell* (if there's only one column available, move one cell up) |
||
|
Complete the cell entry and move to the previous cell* |
||
|
Extend the selection to the first non-frozen cell of the current row* |
||
|
Extend the selection by one screen up |
||
|
Redo the last action |
||
|
Complete the cell entry and move one screen up |
||
|
Move to the first visible item of the context menu or submenu |
||
|
Move one screen up |
||
|
Move one screen down |
||
|
Move to the last visible item of the context menu or submenu |
||
|
Complete the cell entry and move one screen down |
||
|
Move one available menu item up, down, left, or right |
||
|
Move one cell up, down, left, or right |
||
|
Move the cursor through the text |
||
|
Extend the selection by one cell |
||
|
Move the cursor to the beginning or to the end of the text |
||
Advertisement |
|||
|
Extend the selection to the leftmost cell of the current row** |
||
|
Extend the selection to the rightmost cell of the current row** |
||
|
Extend the selection by one screen down |
||
|
Extend the selection to the beginning or to the end of the text |
||
|
Enter the pressed key's value into the cell |
||
|
Enter the editing mode of the active cell, and enter the pressed key's value into the cell |
What is your favorite Handsontable (Excel) hotkey? Do you have any useful tips for it? Let other users know below.
1104982
497575
410897
364747
306151
276541
20 hours ago
20 hours ago Updated!
24 hours ago Updated!
2 days ago Updated!
2 days ago
2 days ago
Latest articles