Use keyboard shortcuts in Google Sheets to navigate, format and use formulas.
Note: some shortcuts might not work for all languages or keyboards.
If you use an external keyboard with your iPhone or iPad, you can use the shortcuts below. This works with most kinds of external keyboards.
| Action | Shortcut |
|---|---|
| Bold | ⌘ + B |
| Underline | ⌘ + U |
| Italicise | ⌘ + i |
| Find and replace | ⌘ + F |
| Strikethrough | ⌘ + Shift + X |
| Undo | ⌘ + z |
| Redo | Shift + Z |
| Select column | Ctrl + Space |
| Select row | Shift + Space |
| Select all | ⌘ + A |
| ⌘ + P | |
| Copy | ⌘ + C |
| Cut | X |
| Paste | ⌘ + V |
| Centre align | ⌘ + Shift + E |
| Left align | ⌘ + Shift + L |
| Right align | ⌘ + Shift + R |
| Insert rows above | ⌘ + Option + = (with rows selected) |
| Insert columns to the left | ⌘ + Option + = (with columns selected) |
| Move selection by cell | Up/Down/Left/Right arrow |
| Expand selection by cell | Shift + Up/Down/Left/Right arrow |
| Move to the edge of the current data region | ⌘ + Up/Down/Left/Right arrow |
| Expand the selection of cells to the edge of the current data region if the next cell is filled. Otherwise, expand the selected cell to the next empty cell in the specified direction. | ⌘ + Shift + Up/Down/Left/Right arrow |
| Delete content from cell | Backspace/Delete |