Google Sheets keyboard shortcuts
Google Sheets borrows many Excel shortcuts, so moving between the two is easy, but a handful differ: strikethrough, sheet switching and find-and-replace on a Mac all use other keys. Because Sheets runs in a browser, a few combos can be intercepted by the browser itself; Google lets you turn on compatible spreadsheet shortcuts in Help > Keyboard shortcuts.
Most-used Google Sheets shortcuts
- Select columnCtrlSpace
- Select rowShiftSpace
- BoldCtrlB
- StrikethroughAltShift5
- Move to next sheetCtrlShiftPageDown
- Move to previous sheetCtrlShiftPageUp
- Insert or edit a noteShiftF2
- Insert a commentCtrlAltM
Practise Google Sheets shortcuts
Read the action, press the real keys. Combos your browser reserves switch to multiple choice. Misses come back sooner in your daily review.
Google Sheets shortcut cheat sheet
30 shortcutsTap an action to copy its keys
Common
| Action | Windows | Mac |
|---|---|---|
| Select column | CtrlSpace | ⌃controlSpace |
| Select row | ShiftSpace | ⇧shiftSpace |
| Select all | CtrlA | ⌘cmdA |
| Find | CtrlF | ⌘cmdF |
| Find and replace | CtrlH | ⌘cmd⇧shiftH |
| Fill range | CtrlEnter | ⌘cmd↩return |
| Fill down | CtrlD | ⌘cmdD |
| Fill right | CtrlR | ⌘cmdR |
| Paste values only | CtrlShiftV | ⌘cmd⇧shiftV |
| Show list of shortcuts | Ctrl/ | ⌘cmd/ |
| Insert link | CtrlK | ⌘cmdK |
| Insert date | Ctrl; | ⌘cmd; |
| Insert time | CtrlShift; | ⌘cmd⇧shift; |
| Search the menus | Alt/ | ⌥option/ |
Format
| Action | Windows | Mac |
|---|---|---|
| Bold | CtrlB | ⌘cmdB |
| Strikethrough | AltShift5 | ⌘cmd⇧shiftX |
| Center align | CtrlShiftE | ⌘cmd⇧shiftE |
| Format as currency | CtrlShift4 | ⌃control⇧shift4 |
| Format as percent | CtrlShift5 | ⌃control⇧shift5 |
| Apply outer border | AltShift7 | ⌥option⇧shift7 |
| Clear formatting | Ctrl\ | ⌘cmd\ |
Navigate
| Action | Windows | Mac |
|---|---|---|
| Move to next sheet | CtrlShiftPageDown | ⌥option↓ |
| Move to previous sheet | CtrlShiftPageUp | ⌥option↑ |
| Jump to beginning of sheet | CtrlHome | ⌘cmdHome |
| Jump to end of sheet | CtrlEnd | ⌘cmdEnd |
Rows & formulas
| Action | Windows | Mac |
|---|---|---|
| Insert or edit a note | ShiftF2 | ⇧shiftF2 |
| Insert a comment | CtrlAltM | ⌘cmd⌥optionM |
| Show all formulas | Ctrl` | ⌃control` |
| Toggle absolute/relative references | F4 | F4 |
| Insert new sheet | ShiftF11 | ⇧shiftF11 |
Source: Google Docs Editors Help: Keyboard shortcuts for Google Sheets. Defaults for the current version as documented by Google; custom keymaps and non-US keyboard layouts can differ.
Can't find it? Ask about Google Sheets
Type a task in plain words and get the shortcut for Windows, with a note if the app lacks one.
Quick answers
Google Sheets shortcut questions
What is the strikethrough shortcut in Google Sheets?
Alt+Shift+5 on Windows and ChromeOS, Cmd+Shift+X on a Mac.
Do Excel shortcuts work in Google Sheets?
Many do out of the box (Ctrl+D, Ctrl+R, Ctrl+Space). Turning on "Enable compatible spreadsheet shortcuts" in the Sheets shortcut dialog adds more Excel-style keys.
Also practise: Windows · Mac · Google Docs · Gmail · Chrome