Comparison · Updated
Excel vs Google Sheets Keyboard Shortcuts: Every Key Compared
Moving between Excel and Google Sheets? Every documented shortcut of both, side by side for Mac and Windows: which keys match, which differ, and which exist in only one.
By ShortcutPosters Editorial Team · from 3 official sources
Excel and Google Sheets share a lot of muscle memory — moving around a sheet, selecting ranges, formatting — but not all of it. This is every shortcut each one documents, joined on the key.
Every documented key, side by side
Each row is a key combination. "Different action" means both apps document it for something different — the keys your hands will get wrong after the switch.
- 15Same key, same action
- 2Same key, different action
- 31Google Sheets only
- 25Microsoft Excel only
| Key |  Microsoft Excel |  Google Sheets | Difference |
|---|---|---|---|
| ⌘A | Select Entire Worksheet | Select allSelection | Different action |
| ⌃⇧5 | Percent Format | Format as percentageFormatting | Different action |
| ⌃␣ | Select Entire Column | Select columnSelection | Same |
| ⇧␣ | Select Entire Row | Select rowSelection | Same |
| ⌘X | Cut | CutEditing | Same |
| ⌘C | Copy | CopyEditing | Same |
| ⌘V | Paste | PasteEditing | Same |
| ⌘Z | Undo | UndoEditing | Same |
| ⌘Y | Redo | RedoEditing | Same |
| ⌘D | Fill Down | Fill downEditing | Same |
| ⌘R | Fill Right | Fill rightEditing | Same |
| ⌘B | Bold | BoldFormatting | Same |
| ⌘I | Italic | ItalicFormatting | Same |
| ⌘U | Underline | UnderlineFormatting | Same |
| ⌃⇧4 | Currency Format | Format as currencyFormatting | Same |
| ⌘P | PrintEditing | Same | |
| ⌘F | Find | FindEditing | Same |
| Fn← | — | Move to beginning of rowNavigation | |
| Fn→ | — | Move to end of rowNavigation | |
| ⌘Fn← | — | Move to beginning of sheetNavigation | |
| ⌘Fn→ | — | Move to end of sheetNavigation | |
| ⌥↓ | — | Next sheetNavigation | |
| ⌥↑ | — | Previous sheetNavigation | |
| ⌥↵ | — | Open hyperlinkNavigation | |
| ⌘⇧V | — | Paste values onlyEditing | |
| ⌘⇧H | — | Find and replaceEditing | |
| ⌘↵ | — | Fill rangeEditing | |
| ⌘K | — | Insert linkEditing | |
| ⌘; | — | Insert dateEditing | |
| ⌘⇧; | — | Insert timeEditing | |
| ⌘⌥M | — | Insert/edit commentEditing | |
| ⇧F2 | — | Insert/edit noteEditing | |
| ⌘⇧X | — | StrikethroughFormatting | |
| ⌘⇧E | — | Center alignFormatting | |
| ⌘⇧L | — | Left alignFormatting | |
| ⌘⇧R | — | Right alignFormatting | |
| ⌘\ | — | Clear formattingFormatting | |
| ⌃⇧3 | — | Format as dateFormatting | |
| ⌥⇧7 | — | Apply outer borderFormatting | |
| ⌘⌥= | — | Insert rows aboveRows & Columns | |
| ⌘⌥− | — | Delete rowsRows & Columns | |
| ⌘⌥9 | — | Hide rowRows & Columns | |
| ⌘⇧9 | — | Unhide rowRows & Columns | |
| ⌘⌥0 | — | Hide columnRows & Columns | |
| ⌘⇧0 | — | Unhide columnRows & Columns | |
| ⌃` | — | Show all formulasFormulas | |
| ⌘⇧↵ | — | Insert array formulaFormulas | |
| FnF4 | — | Toggle absolute/relative referenceFormulas | |
| ⌘→ | Move to Edge of Data Region | — | |
| ⌃↖ | Go to Cell A1 | — | |
| ⌃↘ | Go to Last Used Cell | — | |
| ⌃⇟ | Next Worksheet | — | |
| ⌃⇞ | Previous Worksheet | — | |
| ⇧→ | Extend Selection One Cell | — | |
| ⌘⇧→ | Extend Selection to Last Cell | — | |
| ⌘⌃V | Paste Special | — | |
| F2 | Edit Active Cell | — | |
| ⌃⌥↵ | Insert Line Break in Cell | — | |
| ⌦ | Delete Cell Contents | — | |
| ⌘1 | Format Cells Dialog | — | |
| ⌃⇧` | General Number Format | — | |
| ⇧F3 | Insert Function Dialog | — | |
| ⌘⇧T | AutoSum | — | |
| F9 | Calculate All Worksheets | — | |
| ⌘T | Toggle Absolute Reference | — | |
| ⌃⇧= | Insert Cells | — | |
| ⌘− | Delete Cells | — | |
| ⌘N | New Workbook | — | |
| ⌘O | Open Workbook | — | |
| ⌘S | Save Workbook | — | |
| ⌘W | Close Workbook | — | |
| ⌃H | Find and Replace | — | |
| F11 | Create Chart Sheet | — |
- 17Same key, same action
- 5Same key, different action
- 26Google Sheets only
- 20Microsoft Excel only
| Key | Microsoft Excel | Google Sheets | Difference |
|---|---|---|---|
| CtrlHome | Go to Cell A1 | Move to beginning of sheetNavigation | Different action |
| CtrlEnd | Go to Last Used Cell | Move to end of sheetNavigation | Different action |
| CtrlA | Select Entire Worksheet | Select allSelection | Different action |
| AltEnter | Insert Line Break in Cell | Open hyperlinkNavigation | Different action |
| CtrlShift5 | Percent Format | Format as percentageFormatting | Different action |
| CtrlSpace | Select Entire Column | Select columnSelection | Same |
| ShiftSpace | Select Entire Row | Select rowSelection | Same |
| CtrlX | Cut | CutEditing | Same |
| CtrlC | Copy | CopyEditing | Same |
| CtrlV | Paste | PasteEditing | Same |
| CtrlZ | Undo | UndoEditing | Same |
| CtrlY | Redo | RedoEditing | Same |
| CtrlD | Fill Down | Fill downEditing | Same |
| CtrlR | Fill Right | Fill rightEditing | Same |
| CtrlB | Bold | BoldFormatting | Same |
| CtrlI | Italic | ItalicFormatting | Same |
| CtrlU | Underline | UnderlineFormatting | Same |
| CtrlShift4 | Currency Format | Format as currencyFormatting | Same |
| F4 | Toggle Absolute Reference | Toggle absolute/relative referenceFormulas | Same |
| CtrlP | PrintEditing | Same | |
| CtrlF | Find | FindEditing | Same |
| CtrlH | Find and Replace | Find and replaceEditing | Same |
| Home | — | Move to beginning of rowNavigation | |
| End | — | Move to end of rowNavigation | |
| AltDOWN | — | Next sheetNavigation | |
| AltUP | — | Previous sheetNavigation | |
| CtrlShiftV | — | Paste values onlyEditing | |
| CtrlEnter | — | Fill rangeEditing | |
| CtrlK | — | Insert linkEditing | |
| Ctrl; | — | Insert dateEditing | |
| CtrlShift; | — | Insert timeEditing | |
| CtrlAltM | — | Insert/edit commentEditing | |
| ShiftF2 | — | Insert/edit noteEditing | |
| AltShift5 | — | StrikethroughFormatting | |
| CtrlShiftE | — | Center alignFormatting | |
| CtrlShiftL | — | Left alignFormatting | |
| CtrlShiftR | — | Right alignFormatting | |
| Ctrl\ | — | Clear formattingFormatting | |
| CtrlShift3 | — | Format as dateFormatting | |
| AltShift7 | — | Apply outer borderFormatting | |
| CtrlAlt= | — | Insert rows aboveRows & Columns | |
| CtrlAlt− | — | Delete rowsRows & Columns | |
| CtrlAlt9 | — | Hide rowRows & Columns | |
| CtrlShift9 | — | Unhide rowRows & Columns | |
| CtrlAlt0 | — | Hide columnRows & Columns | |
| CtrlShift0 | — | Unhide columnRows & Columns | |
| Ctrl` | — | Show all formulasFormulas | |
| CtrlShiftEnter | — | Insert array formulaFormulas | |
| CtrlRIGHT | Move to Edge of Data Region | — | |
| CtrlPgDn | Next Worksheet | — | |
| CtrlPgUp | Previous Worksheet | — | |
| ShiftRIGHT | Extend Selection One Cell | — | |
| CtrlShiftRIGHT | Extend Selection to Last Cell | — | |
| CtrlAltV | Paste Special | — | |
| F2 | Edit Active Cell | — | |
| Del | Delete Cell Contents | — | |
| Ctrl1 | Format Cells Dialog | — | |
| CtrlShift` | General Number Format | — | |
| ShiftF3 | Insert Function Dialog | — | |
| Alt= | AutoSum | — | |
| F9 | Calculate All Worksheets | — | |
| CtrlShift= | Insert Cells | — | |
| Ctrl− | Delete Cells | — | |
| CtrlN | New Workbook | — | |
| CtrlO | Open Workbook | — | |
| CtrlS | Save Workbook | — | |
| CtrlW | Close Workbook | — | |
| F11 | Create Chart Sheet | — |
Keep the new set within reach
For the first weeks after a switch, keep the new app's full list one glance away and look a shortcut up instead of guessing from the old one. The differences above are the ones to drill.
FAQ
- Do Excel shortcuts work in Google Sheets?
- Many do. The table above lists every combination both apps document and whether it does the same thing in each.
- Where do these shortcuts come from?
- From each app's official documentation. Every app page lists its sources and the date its shortcuts were last checked.