Hot Keys List
Editing
Enter - activates editor in a cell.
Ctrl + 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.
Work with cell content
Ctrl+C - copies the value of a cell.
Ctrl+V - pastes the value into a cell, replacing any selected content.
Ctrl+X - cuts the value of a cell.
Ctrl+Z - undoes the last action in a sheet.
Ctrl+Y - repeats the last action in a sheet.
Ctrl+Shift+Z - repeats the last action in a sheet.
Ctrl+B - makes the value of a cell bold.
Ctrl+I - makes the value of a cell italic.
Ctrl+U - makes the value of a cell underlined.
Ctrl+A - selects all cells in a sheet.
Delete - removes the cell content, saving the applied styles.
Backspace - removes the cell content, saving the applied styles.
Navigation
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 + Left Arrow Key - moves selection to the first cell in a row.
Ctrl + Right Arrow Key - moves selection to the last cell in a row.
Ctrl + Up Arrow Key - moves selection to the first cell in a column.
Ctrl + Down Arrow Key - moves selection to the last cell in a column.
Ctrl + Home - moves selection to the beginning of a sheet (top left-hand cell).
Ctrl + 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.
Selection
Ctrl + Left mouse button click - allows selecting multiple scattered cells.
Left Shift + Left mouse button 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.
Last updated