Handsontable (Excel) keyboard shortcuts

Handsontable (Excel)

Zeynel -
8 months ago
- Shortcuts
0

Move one cell up, down, left, or right

0
Ctrl +

Move to the first cell of the current column

0
Ctrl +

Move to the last cell of the current column

0
Ctrl +

Move to the leftmost cell of the current row

0
Ctrl +

Move to the rightmost cell of the current row

0
F2

Enter the editing mode of the active cell

0
A - Z

Enter the editing mode of the active cell, and enter the pressed key's value into the cell

0
Tab

Move to the next cell* (if there's only one column available, move one cell down)

0
↑  Shift + Tab

Move to the previous cell* (if there's only one column available, move one cell up)

0
Home

Move to the first non-frozen cell of the current row*

0
Page Up

Move one screen up

0
Page Down

Move one screen down

* This action depends on your layout direction.

Advertisement

0
Ctrl + A

Select all cells and headers

0
Ctrl + ↑  Shift +

Extend the selection to the first cell of the current column**

0
Ctrl + ↑  Shift +

Extend the selection to the last cell of the current column**

0
Ctrl + ↑  Shift +

Extend the selection to the leftmost cell of the current row**

0
Ctrl + ↑  Shift +

Extend the selection to the rightmost cell of the current row**

0
↑  Shift +

Extend the selection by one cell

0
↑  Shift + Home

Extend the selection to the first non-frozen cell of the current row*

0
Shift + Page Up

Extend the selection by one screen up

0
Shift + Page Down

Extend the selection by one screen down

0
Del

Clear the contents of the selected cells

0
or Backspace
* This action depends on your layout direction.
** In case of multiple selection layers, only the last selection layer gets extended.
0

Move the cursor through the text

0
A - Z

Enter the pressed key's value into the cell

0
⤶ Enter

Complete the cell entry and move to the cell below

0
↑  Shift + ⤶ Enter

Complete the cell entry and move to the cell above

0
Tab

Complete the cell entry and move to the next cell*

0
↑  Shift + Tab

Complete the cell entry and move to the previous cell*

0
Del

Delete one character after the cursor*

0
Backspace

Delete one character before the cursor*

0
Home

Move the cursor to the beginning of the text*

0
End

Move the cursor to the end of the text*

0
Ctrl +

Move the cursor to the beginning or to the end of the text

0
Ctrl + ↑  Shift +

Extend the selection to the beginning or to the end of the text

0
Page Up

Complete the cell entry and move one screen up

0
Page Down

Complete the cell entry and move one screen down

0
Esc

Cancel the cell entry and exit the editing mode

* This action depends on your layout direction.
These keyboard shortcuts work when the CopyPaste plugin is enabled.
0
Ctrl + X

Cut the contents of the selected cells to the system clipboard

0
Ctrl + C

Copy the contents of the selected cells to the system clipboard

0
Ctrl + V

Paste from the system clipboard

These keyboard shortcuts work when the MergeCells plugin is enabled.
0
Ctrl + M

Merge or unmerge the selected cells

These keyboard shortcuts work when the UndoRedo plugin is enabled.
0
Ctrl + Z

Undo the last action

0
Ctrl + Y

Redo the last action

0
or Ctrl + ↑  Shift + Z
These keyboard shortcuts work in context menus. To activate them, enable the ContextMenu plugin.
0

Move one available menu item up, down, left, or right

0
Page Up

Move to the first visible item of the context menu or submenu

0
Page Down

Move to the last visible item of the context menu or submenu

0
Esc

Close the context menu or submenu

0
⤶ Enter

Run the action of the selected menu item


Share this page on:
Is this page helpful?
0 0

Program information

Program name: Handsontable (Excel) Handsontable (Excel) (Developer tools)

Handsontable is a "JavaScript grid" with spreadsheet features. It is a front-end component that combines data grid features with spreadsheet user interface. The software is used to build modern business web applications.

Web page: handsontable.com

How easy to press shortcuts: 87%

More information >>

Updated: Updated program information. (2 updates.) 9/8/2023 2:20:50 PM New program added.
9/8/2023 2:22:34 PM Updated program information.

Shortcut count: 50

Platform detected: Windows or Linux


User operations

Add Handsontable (Excel) to favorites

Add to favorites

Advertisement


What is your favorite Handsontable (Excel) hotkey? Do you have any useful tips for it? Let other users know below.


 
No comments yet. Ask, or type the first one!