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 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