Google Sheets Keyboard Shortcuts
Work faster in Google Sheets — Mac and Windows keys side by side, ready to copy.
| Action | Mac | Windows | |
|---|---|---|---|
| Insert current date | ⌘; | Ctrl+; | |
| Insert current time | ⌘⇧; | Ctrl+Shift+; | |
| Select column / row | ⌃Space / ⇧Space | Ctrl+Space / Shift+Space | |
| Move to edge of data | ⌘Arrow | Ctrl+Arrow | |
| Fill down / right | ⌘D / ⌘R | Ctrl+D / Ctrl+R | |
| Format as currency | ⌃⇧4 | Ctrl+Shift+4 | |
| Format as percent | ⌃⇧5 | Ctrl+Shift+5 | |
| Insert rows above | (menu) | Ctrl+Alt+= (with row selected) | |
| Bold / italic / underline | ⌘B / ⌘I / ⌘U | Ctrl+B / Ctrl+I / Ctrl+U | |
| Show all shortcuts | ⌘/ | Ctrl+/ | |
| Strikethrough | ⌘⇧X | Alt+Shift+5 | |
| Add / edit note | ⇧F2 | Shift+F2 |
The one shortcut that unlocks the rest
Press Ctrl+/ (⌘/ on Mac) anywhere in Sheets to open the full shortcut overlay — a searchable list of every default binding. Learn that one and you can look up the rest without leaving the sheet.
Navigate big sheets
Ctrl+Arrow jumps to the edge of the current block of data; add Shift to select on the way. Ctrl+Backspace scrolls back to the active cell after you've wandered off.
FAQ
How do I see all Google Sheets keyboard shortcuts?
Press Ctrl+/ on Windows or ⌘/ on the Mac to open the built-in shortcut list, which is searchable.
Do Google Sheets shortcuts match Excel?
Many overlap (Ctrl+B, Ctrl+Arrow, Ctrl+D) but some differ — currency and percent formatting use different combos, and Sheets adds its own like Ctrl+/.
How do I insert today's date in Google Sheets?
Press Ctrl+; (⌘; on Mac) for the date, or Ctrl+Shift+; for the current time. These insert static values, not the volatile TODAY() formula.