Google Sheets keyboard shortcuts
Google · 62 shortcuts62 Google Sheets shortcuts grouped by task, with Windows and Mac keys side by side. Click any row for the full answer page.
Essentials
| Action | Windows | Mac |
|---|---|---|
| Select column | Ctrl+SpaceCtrlSpace | Ctrl+Space⌃Space |
| Select row | Shift+SpaceShiftSpace | Shift+Space⇧Space |
| Select all | Ctrl+ACtrlA | Cmd+A⌘A |
| Undo | Ctrl+ZCtrlZ | Cmd+Z⌘Z |
| Redo | Ctrl+YCtrlY | Cmd+Y⌘Y |
| Find | Ctrl+FCtrlF | Cmd+F⌘F |
| Find and replace | Ctrl+HCtrlH | Cmd+Shift+H⌘⇧H |
| Fill range | Ctrl+EnterCtrl↵ | Cmd+Enter⌘↵ |
| Fill down | Ctrl+DCtrlD | Cmd+D⌘D |
| Fill right | Ctrl+RCtrlR | Cmd+R⌘R |
| Save | Ctrl+SCtrlS | Cmd+S⌘S |
| Open | Ctrl+OCtrlO | Cmd+O⌘O |
| Ctrl+PCtrlP | Cmd+P⌘P | |
| Copy | Ctrl+CCtrlC | Cmd+C⌘C |
| Cut | Ctrl+XCtrlX | Cmd+X⌘X |
| Paste | Ctrl+VCtrlV | Cmd+V⌘V |
| Paste values only | Ctrl+Shift+VCtrlShiftV | Cmd+Shift+V⌘⇧V |
| Show common shortcuts | Ctrl+/Ctrl/ | Cmd+/⌘/ |
| Insert new sheet | Shift+F11ShiftF11 | Shift+Fn+F11⇧FnF11 |
Formatting
| Action | Windows | Mac |
|---|---|---|
| Bold | Ctrl+BCtrlB | Cmd+B⌘B |
| Italic | Ctrl+ICtrlI | Cmd+I⌘I |
| Underline | Ctrl+UCtrlU | Cmd+U⌘U |
| Strikethrough | Alt+Shift+5AltShift5 | Cmd+Shift+X⌘⇧X |
| Center align | Ctrl+Shift+ECtrlShiftE | Cmd+Shift+E⌘⇧E |
| Left align | Ctrl+Shift+LCtrlShiftL | Cmd+Shift+L⌘⇧L |
| Right align | Ctrl+Shift+RCtrlShiftR | Cmd+Shift+R⌘⇧R |
| Apply top border | Alt+Shift+1AltShift1 | Option+Shift+1⌥⇧1 |
| Apply bottom border | Alt+Shift+3AltShift3 | Option+Shift+3⌥⇧3 |
| Remove borders | Alt+Shift+6AltShift6 | Option+Shift+6⌥⇧6 |
| Insert link | Ctrl+KCtrlK | Cmd+K⌘K |
| Insert date | Ctrl+;Ctrl; | Cmd+;⌘; |
| Insert time | Ctrl+Shift+;CtrlShift; | Cmd+Shift+;⌘⇧; |
| Format as currency | Ctrl+Shift+4CtrlShift4 | Ctrl+Shift+4⌃⇧4 |
| Format as percentage | Ctrl+Shift+5CtrlShift5 | Ctrl+Shift+5⌃⇧5 |
| Format as date | Ctrl+Shift+3CtrlShift3 | Ctrl+Shift+3⌃⇧3 |
| Clear formatting | Ctrl+\Ctrl\ | Cmd+\⌘\ |
Cells & rows
| Action | Windows | Mac |
|---|---|---|
| Insert rows above | Ctrl+Alt+=CtrlAlt= | Cmd+Option+=⌘⌥= |
| Delete rows | Ctrl+Alt+-CtrlAlt- | Cmd+Option+-⌘⌥- |
| Hide row | Ctrl+Alt+9CtrlAlt9 | Cmd+Option+9⌘⌥9 |
| Unhide row | Ctrl+Shift+9CtrlShift9 | Cmd+Shift+9⌘⇧9 |
| Hide column | Ctrl+Alt+0CtrlAlt0 | Cmd+Option+0⌘⌥0 |
| Unhide column | Ctrl+Shift+0CtrlShift0 | Cmd+Shift+0⌘⇧0 |
| Group rows or columns | Alt+Shift+RightAltShift→ | Option+Shift+Right⌥⇧→ |
| Ungroup rows or columns | Alt+Shift+LeftAltShift← | Option+Shift+Left⌥⇧← |
| Insert or edit note | Shift+F2ShiftF2 | Shift+F2⇧F2 |
| Insert or edit comment | Ctrl+Alt+MCtrlAltM | Cmd+Option+M⌘⌥M |
Navigation
| Action | Windows | Mac |
|---|---|---|
| Move to beginning of row | HomeHome | Fn+LeftFn← |
| Move to beginning of sheet | Ctrl+HomeCtrlHome | Cmd+Fn+Left⌘Fn← |
| Move to end of row | EndEnd | Fn+RightFn→ |
| Move to end of sheet | Ctrl+EndCtrlEnd | Cmd+Fn+Right⌘Fn→ |
| Move to next sheet | Alt+DownAlt↓ | Option+Down⌥↓ |
| Move to previous sheet | Alt+UpAlt↑ | Option+Up⌥↑ |
| Open hyperlink | Alt+EnterAlt↵ | Option+Enter⌥↵ |
| Open Explore | Ctrl+Alt+Shift+ICtrlAltShiftI | Cmd+Option+Shift+I⌘⌥⇧I |
| Open revision history | Ctrl+Alt+Shift+HCtrlAltShiftH | Cmd+Option+Shift+H⌘⌥⇧H |
Formulas
| Action | Windows | Mac |
|---|---|---|
| Show all formulas | Ctrl+~Ctrl~ | Ctrl+~⌃~ |
| Insert array formula | Ctrl+Shift+EnterCtrlShift↵ | Cmd+Shift+Enter⌘⇧↵ |
| Toggle absolute/relative references | F4F4 | Fn+F4FnF4 |
| Toggle formula result previews | F9F9 | Fn+F9FnF9 |
| Show/hide formula help | Shift+F1ShiftF1 | Shift+Fn+F1⇧FnF1 |
| Full/compact formula help | F1F1 | Fn+F1FnF1 |
| Toggle formula range selection | F2F2 | F2F2 |
Ask your agent
Prompt
Make me a one-page Google Sheets cheat sheet from the 62 shortcuts at https://keyflowhub.com/shortcuts/google-sheets, ordered by what I'm most likely to use, and point out any that clash with my current keybindings.
Paste into Claude Code and it will do the rest.
Questions
Windows: Ctrl + Z. Mac: Cmd + Z.
Windows: Ctrl + Y. Mac: Cmd + Y.
Windows: Ctrl + S. Mac: Cmd + S.
Windows: Ctrl + F. Mac: Cmd + F.
Sources: support.google.com