=======================================
Handsontable (Excel) keyboard shortcuts
=======================================

First published at 9/8/2023 on
https://defkey.com/handsontable-excel-shortcuts

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.

Handsontable (Excel) has 50 shortcuts and we have listed all of them below.



Navigation
----------

Arrow keys              Move one cell up, down, left, or right
Ctrl + Up arrow         Move to the first cell of the current column
Ctrl + Down arrow       Move to the last cell of the current column
Ctrl + Left arrow       Move to the leftmost cell of the current row
Ctrl + Right arrow      Move to the rightmost cell of the current row
F2                      Enter the editing mode of the active cell
[A - Z]                 Enter the editing mode of the active cell, and enter the pressed key's
value into the cell
Tab                     Move to the next cell* (if there's only one column available, move one cell
down)
Shift + Tab             Move to the previous cell* (if there's only one column available, move one
cell up)
Home                    Move to the first non-frozen cell of the current row*
Page Up                 Move one screen up
Page Down               Move one screen down

* This action depends on your layout direction.



Selection
---------

Ctrl + A                Select all cells and headers
Ctrl + Shift + Up arrow Extend the selection to the first cell of the current column**
Ctrl + Shift + Down arrow Extend the selection to the last cell of the current column**
Ctrl + Shift + Left arrow Extend the selection to the leftmost cell of the current row**
Ctrl + Shift + Right arrow Extend the selection to the rightmost cell of the current row**
Shift + Arrow keys      Extend the selection by one cell
Shift + Home            Extend the selection to the first non-frozen cell of the current row*
Shift + Page Up         Extend the selection by one screen up
Shift + Page Down       Extend the selection by one screen down
Del                     Clear the contents of the selected cells
Backspace               Clear the contents of the selected cells

* This action depends on your layout direction.

** In case of multiple selection layers, only the last selection layer gets
extended.



Edition
-------

Arrow keys              Move the cursor through the text
[A - Z]                 Enter the pressed key's value into the cell
Enter                   Complete the cell entry and move to the cell below
Shift + Enter           Complete the cell entry and move to the cell above
Tab                     Complete the cell entry and move to the next cell*
Shift + Tab             Complete the cell entry and move to the previous cell*
Del                     Delete one character after the cursor*
Backspace               Delete one character before the cursor*
Home                    Move the cursor to the beginning of the text*
End                     Move the cursor to the end of the text*
Ctrl + Arrow keys       Move the cursor to the beginning or to the end of the text
Ctrl + Shift + Arrow keys Extend the selection to the beginning or to the end of the text
Page Up                 Complete the cell entry and move one screen up
Page Down               Complete the cell entry and move one screen down
Esc                     Cancel the cell entry and exit the editing mode

* This action depends on your layout direction.



Clipboard
---------

These keyboard shortcuts work when the CopyPaste plugin is enabled.

Ctrl + X                Cut the contents of the selected cells to the system clipboard
Ctrl + C                Copy the contents of the selected cells to the system clipboard
Ctrl + V                Paste from the system clipboard


Cell merging
------------

These keyboard shortcuts work when the MergeCells plugin is enabled.

Ctrl + M                Merge or unmerge the selected cells


Undo and redo
-------------

These keyboard shortcuts work when the UndoRedo plugin is enabled.

Ctrl + Z                Undo the last action
Ctrl + Y                Redo the last action
Ctrl + Shift + Z        Redo the last action


Context menu
------------

These keyboard shortcuts work in context menus. To activate them, enable
the ContextMenu plugin.

Arrow keys              Move one available menu item up, down, left, or right
Page Up                 Move to the first visible item of the context menu or submenu
Page Down               Move to the last visible item of the context menu or submenu
Esc                     Close the context menu or submenu
Enter                   Run the action of the selected menu item

Source: Handsontable docs


Last modified on (UTC): Friday, September 8, 2023
Defkey © All rights reserved.