Movement within worksheets
| Action | |
|---|---|
| Move one cell up, down, left, or right | |
| Move one cell to the right | |
| Move one cell to the left | |
| Move to the end of the row | |
| Go to last cell in data region | |
| Move to the beginning of the row | |
| Move to the beginning of the worksheet | |
| Go to left-most / right-most cell in current row | |
| Go to bottom-most / to-most cell in current column | |
| Move to next / move to previousworksheet | |
| Move one screen to the right / one screen to the left | |
| Scroll to the active cell when multiple cells are selected | |
| Switch sheets |
Movement within a selected range
| Action | |
|---|---|
| Move from top to bottom within the selected range | |
| Move from bottom to top within the selected range | |
| Move from left to right within the selected range. If cells in a single column are selected, move down. | |
| Move from right to left within the selected range. If cells in a single column are selected, move up. |
Entering/editing data
| Action | |
|---|---|
| Select the all / entire worksheet | |
| Bold the contents of the selected cell | |
| Copy the contents of the selected cell | |
| Find words or phrases within the spreadsheet | |
| Italicize the contents of the selected cell | |
| Copy the content of the selected cell right (used in combo with Shift + arrow) | |
| Save | |
| Underline the contents of the selected cell | |
| Paste the contents of the selected cell | |
| Cut the contents of the selected cell | |
| Redo the last action | |
| Undo the last action. | |
| Complete a cell entry and select the cell below | |
| Complete a cell entry and select the previous cell above | |
| Start a new line in the same cell | |
| Insert line break in a cell | |
| Complete a cell entry and select the next cell to the right | |
| Complete a cell entry and select the previous cell to the left | |
| Edit the active cell and position the insertion point at the end of the cell contents | |
| Edit comment | |
| Cancel cell entry | |
| Edit the active cell and then clear it, or delete the preceding character in the active cell as you edit cell contents | |
| Delete the character to the right of the insertion point, or delete the selection | |
| Select the entire column | |
| Select the entire row | |
| Manual select | |
| Make a copy of the document | |
| Strikethrough formatting for the contents of the cell | |
| Apply border outline to selected cells | |
| Remove border outline from selected cells | |
| Apply or remove top border from the selected cells | |
| Apply or remove bottom border from the selected cells | |
| Apply or remove right border from the selected cells | |
| Apply or remove left border from the selected cells |
Miscellaneous Shortcuts
| Action | |
|---|---|
| Wrap current formula in an ArrayFormula | |
| Insert current date into cell | |
| Insert current time into cell | |
| Open keyboard shortcuts help | |
| View all formulas |
