hotkeys.md

sidebar_label	Hot keys list
title	Hotkeys
description	You can learn about the hotkeys in the documentation of the DHTMLX JavaScript Spreadsheet library. Browse developer guides and API reference, try out code examples and live demos, and download a free 30-day evaluation version of DHTMLX Spreadsheet.

Hot keys list

Here is a list of hotkeys that you can use while working with DHTMLX Spreadsheet.

Editing

Enter	activates editor in a cell
Ctrl (Cmd) + Enter	stops cell’s editing, leaves selection on the cell
F2	opens editor in the selected cell
Esc	closes editor in a cell without saving changes

Formatting cells

Ctrl (Cmd) + C	copies the value of a cell
Ctrl (Cmd) + V	pastes the value into a cell, replacing any selected content
Ctrl (Cmd) + X	cuts the value of a cell
Ctrl (Cmd) + Z	undoes the last action in a sheet
Ctrl (Cmd) + Y	repeats the last action in a sheet
Ctrl (Cmd) + Shift + Z	repeats the last action in a sheet
Ctrl (Cmd) + B	makes the value of a cell bold
Ctrl (Cmd) + I	makes the value of a cell italic
Ctrl (Cmd) + U	makes the value of a cell underlined
Alt + Shift + 5 (Cmd + Shift + X)	makes the value of a cell crossed out
Ctrl (Cmd) + Shift + E	centers the value of a cell horizontally
Ctrl (Cmd) + Shift + R	aligns the value of a cell to the right
Ctrl (Cmd) + Shift + L	aligns the value of a cell to the left
Ctrl (Cmd) + K	inserts a hyperlink in a cell
Delete	removes the cell content, saving the applied styles
Backspace	removes the cell content, saving the applied styles

Navigation

{{note Navigation works in case no cell is being edited.}}

Enter	activates editor in a cell. Closes editor and moves selection one cell down (in a column). If a range of cells is selected, moves selection one cell down within the bounds of a range.
Shift + Enter	moves selection one cell up (in a column). If a range of cells is selected, moves selection one cell up within the bounds of a range. Deactivated when reaches the first cell in a column.
Tab	moves selection one cell right (in a row). If a range of cells is selected, moves selection one cell right within the bounds of a range. Deactivated when reaches the rightmost cell in a row.
Tab + Shift	moves selection one cell left (in a row). If a range of cells is selected, moves selection one cell left within the bounds of a range. Deactivated when reaches the leftmost cell in a row.
Arrow keys	provide navigation around cells in a sheet
Home	moves selection to the first cell in the row
End	moves selection to the last cell in the row
Ctrl (Cmd) + Left Arrow Key	moves selection to the first cell in a row
Ctrl (Cmd) + Right Arrow Key	moves selection to the last cell in a row
Ctrl (Cmd) + Up Arrow Key	moves selection to the first cell in a column
Ctrl (Cmd) + Down Arrow Key	moves selection to the last cell in a column
Ctrl (Cmd) + Home	moves selection to the beginning of a sheet (top left-hand cell)
Ctrl (Cmd) + End	moves selection to the end of a sheet (bottom right-hand cell)
Shift + Up Arrow/Down Arrow/Left Arrow/Right Arrow Key	extends selection from the selected cell
Page Up	scrolls the sheet one screen up
Page Down	scrolls the sheet one screen down

Search

Ctrl (Cmd) + F	opens a search box in the top right corner of the spreadsheet
Ctrl (Cmd) + G	moves selection to the next found match
Ctrl (Cmd) + Shift + G	moves selection to the previous found match

Selection

Ctrl (Cmd) + A	selects all cells in a sheet
Ctrl (Cmd) + Left click	allows selecting multiple scattered cells
Left Shift + Left click	allows selecting a range of cells, where the selected cell is the first cell of the range and the clicked cell is the last cell of the range
Ctrl (Cmd) + Shift + Left click	allows selecting multiple scattered ranges of cells
Ctrl (Cmd) + Space	selects the whole column
Shift + Space	selects the whole row

Work with sheets

Shift + F11	adds a new sheet into the spreadsheet
Alt + Arrow Up/ Arrow Down	switches to the next/previous sheet