Action | Keyboard Shortcut |
Go to Cell | Ctrl + G |
Move from cell to cell | Up, Down, Left, Right |
Move to the next filled or empty cell | Ctrl + (Up, Down, Left, Right) |
Move to the next filled or empty cell and select cells | Ctrl + Shift + (Up, Down, Left, Right) |
Select a cell | Shift + (Up, Down, Left, Right) |
Select cells from the current one up to the beginning of the row | Shift + Home |
Select cells from the current one to the end of row | Shift + End |
Select rows | Alt + Shift + (Up, Down) |
Select rows to the next filled or empty cell | Ctrl + Alt + Shift + (Up, Down) |
Select columns | Alt + Shift + (Left, Right) |
Select columns up to the next filled or empty cell | Ctrl + Alt + Shift + (Left, Right) |
Select cells from the current one up to the beginning of the document | Ctrl + Shift + Home |
Select cells from the current one to the end of the document | Ctrl + Shift + End |
Merge cells (lines / columns) | Ctrl + M |
Scroll up one page | PgUp |
Scroll down one page | PgDn |
Scroll page to left | Alt + PgUp |
Scroll page to right | Alt + PgDn |
Edit cell contents | Enter |
Toggle edit mode/cell entry | F2 |
Go to the beginning of the line | Home |
Go to the end of the line | End |
Go to the beginning of the text | Ctrl + Home |
Go to the end of the text | Ctrl + End |
Set a name to the current area | Ctrl + Shift + N |
Expand group | Ctrl + Num+ |
Collapse group | Ctrl + Num- |
Expand groups and all subordinate | Ctrl + Alt + Num+ |
Collapse groups and all subordinate | Ctrl + Alt + Num- |
Spreadsheet Document in a Form
Action | Keyboard Shortcut |
Select value from a cell | F4 |
Clear a value from the cell (for a composite data type cell a predefined data type is cleared) | Shift+F4 |