Google Sheets keyboard shortcuts for Mac
60 shortcuts · Updated
These are the default Google Sheets keyboard shortcuts on macOS, taken from Google's official shortcuts reference. Sheets is a web app, so they work the same in Chrome, Safari, or any browser on your Mac. Press Cmd+/ inside any spreadsheet to pull up the full searchable list at any time.
Nothing matches - try fewer letters, or an action word like "close" or "split".
Or stop looking them up. Super Shortcuts puts the Google Sheets commands you actually use one hyper key away: hold it, see every command for the app you're in, release a key to run it. No memorizing - the cheat sheet is the shortcut.
Get Super ShortcutsCommon actions11
| Shortcut | Action |
|---|---|
| Command D⌘D | Fill down |
| Command R⌘R | Fill right |
| Command Return⌘↩ | Fill the selected range |
| Command Shift V⌘⇧V | Paste values only |
| Command F⌘F | Find |
| Command Shift H⌘⇧H | Find and replace |
| Command Z⌘Z | Undo |
| Command Shift Z⌘⇧Z | Redo |
| Shift Fn F11⇧fnF11 | Insert a new sheet |
| Option /⌥/ | Search the menus (tool finder) |
| Command /⌘/ | Show the full keyboard shortcuts list |
Selection3
| Shortcut | Action |
|---|---|
| Shift Space⇧Space | Select the row |
| Control Space⌃Space | Select the column |
| Command A⌘A | Select all |
Navigation9
| Shortcut | Action |
|---|---|
| Fn Left Arrowfn← | Move to the beginning of the row |
| Fn Right Arrowfn→ | Move to the end of the row |
| Command Fn Left Arrow⌘fn← | Move to the beginning of the sheet |
| Command Fn Right Arrow⌘fn→ | Move to the end of the sheet |
| Option Down Arrow⌥↓ | Move to the next sheet |
| Option Up Arrow⌥↑ | Move to the previous sheet |
| Option Shift K⌥⇧K | Display the list of sheets |
| Command Delete⌘⌫ | Scroll back to the active cell |
| Option Return⌥↩ | Open the hyperlink in the cell |
Rows & columns14
| Shortcut | Action |
|---|---|
| Control Option I, then R, then R⌃⌥IRR | Insert rows above |
| Control Option I, then R, then B⌃⌥IRB | Insert rows below |
| Control Option I, then C, then C⌃⌥ICC | Insert columns to the left |
| Control Option I, then C, then O⌃⌥ICO | Insert columns to the right |
| Control Option E, then D, then D⌃⌥EDD | Delete the selected rows |
| Control Option E, then D, then E⌃⌥EDE | Delete the selected columns |
| Command Option 9⌘⌥9 | Hide the row |
| Command Shift 9⌘⇧9 | Unhide the row |
| Command Option 0⌘⌥0 | Hide the column |
| Command Shift 0⌘⇧0 | Unhide the column |
| Option Shift Right Arrow⌥⇧→ | Group the selected rows or columns |
| Option Shift Left Arrow⌥⇧← | Ungroup the selected rows or columns |
| Option Shift Down Arrow⌥⇧↓ | Expand grouped rows or columns |
| Option Shift Up Arrow⌥⇧↑ | Collapse grouped rows or columns |
Formatting14
| Shortcut | Action |
|---|---|
| Command B⌘B | Bold |
| Command I⌘I | Italic |
| Command U⌘U | Underline |
| Command Shift X⌘⇧X | Strikethrough |
| Command Shift L⌘⇧L | Left align |
| Command Shift E⌘⇧E | Center align |
| Command Shift R⌘⇧R | Right align |
| Command K⌘K | Insert a link |
| Command ;⌘; | Insert the current date |
| Command Shift ;⌘⇧; | Insert the current time |
| Control Shift 3⌃⇧3 | Format as date |
| Control Shift 4⌃⇧4 | Format as currency |
| Control Shift 5⌃⇧5 | Format as percentage |
| Command \⌘\ | Clear formatting |
Formulas4
| Shortcut | Action |
|---|---|
| Control ~⌃~ | Show all formulas |
| Command Shift Return⌘⇧↩ | Insert an array formula |
| Fn F4fnF4 | Toggle absolute and relative references |
| Shift Fn F1⇧fnF1 | Show or hide formula help |
Notes & comments5
| Shortcut | Action |
|---|---|
| Shift F2⇧F2 | Insert or edit a note |
| Command Option M⌘⌥M | Insert or edit a comment |
| Command Option Shift A⌘⌥⇧A | Open the comment thread |
| Control Command N, then Control Command C⌃⌘N⌃⌘C | Move to the next comment (hold Ctrl+Cmd, press N then C) |
| Control Command P, then Control Command C⌃⌘P⌃⌘C | Move to the previous comment (hold Ctrl+Cmd, press P then C) |
Curated from the official Google Sheets keyboard shortcuts (Google Help, Mac). Defaults only - shortcuts you've remapped will differ.
Frequently asked questions
How do I see all keyboard shortcuts in Google Sheets?
Press ⌘/ inside any spreadsheet to open a searchable overlay with every Google Sheets shortcut. The same list lives under Help → Keyboard shortcuts, where you can also enable compatible spreadsheet shortcuts from other apps.
Can I customize keyboard shortcuts in Google Sheets?
No - Sheets shortcuts are fixed. You can however turn on compatible shortcuts (in the ⌘/ overlay) to make Sheets accept familiar bindings from desktop spreadsheet apps like Excel.
Which Google Sheets shortcuts should I learn first?
Row and column selection (⇧Space and ⌃Space) plus fill down (⌘D) are the biggest time savers - together they replace most of the click-and-drag work. Add paste values only (⌘⇧V) to strip formulas and formatting when moving data around.