+ Indicates to hold the previous key, while pressing the next key.
> Indicates to tap the previous key, releasing it before pressing the next key.
Find the shortcuts list below:
| # | Description | PC Shortcut | Mac Shortcut | |
|---|---|---|---|---|
| Common actions | ||||
| 1 | Select column | Ctrl+Space |
^+Space |
|
| 2 | Select row | Shift+Space |
⇧+Space |
|
| 3 | Select all | Ctrl+A |
^+A |
|
| 4 | Undo | Ctrl+Z |
^+Z |
|
| 5 | Redo | Ctrl+Y |
^+Y |
|
| 6 | Find | Ctrl+F |
^+F |
|
| 7 | Find and replace | Ctrl+H |
^+H |
|
| 8 | Fill range | Ctrl+Enter |
^+Enter |
|
| 9 | Fill down | Ctrl+D |
^+D |
|
| 10 | Fill right | Ctrl+R |
^+R |
|
| 11 | Save | Ctrl+S |
^+S |
|
| 12 | Open | Ctrl+O |
^+O |
|
| 13 | Ctrl+P |
^+P |
||
| 14 | Copy | Ctrl+C |
^+C |
|
| 15 | Cut | Ctrl+X |
^+X |
|
| 16 | Paste | Ctrl+V |
^+V |
|
| 17 | Paste values only | Ctrl+Shift+V |
^+⇧+V |
|
| 18 | Show common keyboard shortcuts | Ctrl+OemQuestion |
^+OemQuestion |
|
| 19 | Insert new sheet | Shift+F11 |
⇧+F11 |
|
| 20 | Compact controls | Ctrl+Shift+F |
^+⇧+F |
|
| 21 | Input tools on/off | Ctrl+Shift+K |
^+⇧+K |
|
| 22 | Select input tools | Ctrl+Alt+Shift+K |
^+⌥+⇧+K |
|
| Format cells | ||||
| 23 | Bold | Ctrl+B |
^+B |
|
| 24 | Underline | Ctrl+U |
^+U |
|
| 25 | Italic | Ctrl+I |
^+I |
|
| 26 | Strikethrough | Alt+Shift+5 |
⌥+⇧+5 |
|
| 27 | Center align | Ctrl+Shift+E |
^+⇧+E |
|
| 28 | Left align | Ctrl+Shift+L |
^+⇧+L |
|
| 29 | Right align | Ctrl+Shift+R |
^+⇧+R |
|
| 30 | Apply top border | Alt+Shift+1 |
⌥+⇧+1 |
|
| 31 | Apply right border | Alt+Shift+2 |
⌥+⇧+2 |
|
| 32 | Apply bottom border | Alt+Shift+3 |
⌥+⇧+3 |
|
| 33 | Apply left border | Alt+Shift+4 |
⌥+⇧+4 |
|
| 34 | Remove borders | Alt+Shift+6 |
⌥+⇧+6 |
|
| 35 | Apply outer border | Alt+Shift+7 |
⌥+⇧+7 |
|
| 36 | Insert link | Ctrl+K |
^+K |
|
| 37 | Insert time | Ctrl+Shift+; |
^+⇧+; |
|
| 38 | Insert date | Ctrl+; |
^+; |
|
| 39 | Insert date and time | Ctrl+Alt+Shift+; |
^+⌥+⇧+; |
|
| 40 | Format as decimal | Ctrl+Shift+1 |
^+⇧+1 |
|
| 41 | Format as time | Ctrl+Shift+2 |
^+⇧+2 |
|
| 42 | Format as date | Ctrl+Shift+3 |
^+⇧+3 |
|
| 43 | Format as currency | Ctrl+Shift+4 |
^+⇧+4 |
|
| 44 | Format as percentage | Ctrl+Shift+5 |
^+⇧+5 |
|
| 45 | Format as exponent | Ctrl+Shift+6 |
^+⇧+6 |
|
| 46 | Clear formatting | Ctrl+Oem5 |
^+Oem5 |
|
| Navigate spreadsheet | ||||
| 47 | Move to beginning of row | Home |
Home |
|
| 48 | Move to beginning of sheet | Ctrl+Home |
^+Home |
|
| 49 | Move to end of row | End |
End |
|
| 50 | Move to end of sheet | Ctrl+End |
^+End |
|
| 51 | Scroll to active cell | Ctrl+Back |
^+Back |
|
| 52 | Move to next sheet | Ctrl+Shift+PgDn |
^+⇧+PgDn |
|
| 53 | Move to previous sheet | Ctrl+Shift+PgUp |
^+⇧+PgUp |
|
| 54 | Display list of sheets | Alt+Shift+K |
⌥+⇧+K |
|
| 55 | Open hyperlink | Alt+Enter |
⌥+Enter |
|
| 56 | Open Explore | Alt+Shift+X |
⌥+⇧+X |
|
| 57 | Move focus out of spreadsheet | Ctrl+Alt+Shift+M |
^+⌥+⇧+M |
|
| 58 | Move to quicksum | Alt+Shift+Q |
⌥+⇧+Q |
|
| 59 | (when a range of cells is selected) | Add |
Add |
|
| 60 | Move focus to popup | Ctrl+Alt+E+P |
^+⌥+E+P |
|
| 61 | Open drop-down menu on filtered cell | Ctrl+Alt+R |
^+⌥+R |
|
| 62 | Open revision history | Ctrl+Alt+Shift+H |
^+⌥+⇧+H |
|
| 63 | Open chat inside the spreadsheet | Shift+Escape |
⇧+Escape |
|
| 64 | Close drawing editor | Shift+Escape |
⇧+Escape |
|
| Edit notes and comments | ||||
| 65 | Insert/edit note | Shift+F2 |
⇧+F2 |
|
| 66 | Insert/edit comment | Ctrl+Alt+M |
^+⌥+M |
|
| 67 | Open comment discussion thread | Ctrl+Alt+Shift+A |
^+⌥+⇧+A |
|
| 68 | Enter current comment | Ctrl+Alt+E+C |
^+⌥+E+C |
|
| 69 | Move to next comment | Ctrl+Alt+N+C |
^+⌥+N+C |
|
| 70 | Move to previous comment | Ctrl+Alt+P+C |
^+⌥+P+C |
|
| Open a menu | ||||
| 71 | File menu | Alt+F |
⌥+F |
|
| 72 | Edit menu | Alt+E |
⌥+E |
|
| 73 | View menu | Alt+V |
⌥+V |
|
| 74 | Insert menu | Alt+I |
⌥+I |
|
| 75 | Format menu | Alt+O |
⌥+O |
|
| 76 | Data menu | Alt+D |
⌥+D |
|
| 77 | Tools menu | Alt+T |
⌥+T |
|
| 78 | Open insert menu | Ctrl+Alt+Shift+= |
^+⌥+⇧+= |
|
| 79 | Open delete menu | Ctrl+Alt+Subtract |
^+⌥+Subtract |
|
| 80 | Form menu | Alt+M |
⌥+M |
|
| 81 | Add-ons menu | Alt+N |
⌥+N |
|
| 82 | Help menu | Alt+H |
⌥+H |
|
| 83 | Accessibility menu | Alt+A |
⌥+A |
|
| 84 | Sheet menu | Alt+Shift+S |
⌥+⇧+S |
|
| 85 | Context menu | Ctrl+Shift+Oem5 |
^+⇧+Oem5 |
|
| Add or changerows and columns | ||||
| 86 | Insert rows above | Ctrl+Alt+Shift+= |
^+⌥+⇧+= |
|
| 87 | Insert rows below | Alt+I+W |
⌥+I+W |
|
| 88 | Insert columns to the left | Ctrl+Alt+Shift+= |
^+⌥+⇧+= |
|
| 89 | Insert columns to the right | Alt+I+O |
⌥+I+O |
|
| 90 | Delete rows | Ctrl+Alt+Subtract |
^+⌥+Subtract |
|
| 91 | Delete columns | Ctrl+Alt+Subtract |
^+⌥+Subtract |
|
| 92 | Hide row | Ctrl+Alt+9 |
^+⌥+9 |
|
| 93 | Hide column | Ctrl+Alt+0 |
^+⌥+0 |
|
| 94 | Unhide row | Ctrl+Shift+9 |
^+⇧+9 |
|
| 95 | Unhide column | Ctrl+Shift+0 |
^+⇧+0 |
|
| 96 | Group rows or columns | Alt+Shift+Right |
⌥+⇧+Right |
|
| 97 | Ungroup rows or columns | Alt+Shift+Left |
⌥+⇧+Left |
|
| 98 | Expand grouped rows or columns | Alt+Shift+Down |
⌥+⇧+Down |
|
| 99 | Collapse grouped rows or columns | Alt+Shift+Up |
⌥+⇧+Up |
|
| Use formulas & Screen readers | ||||
| 100 | Show all formulas | Ctrl+Oemtilde |
^+Oemtilde |
|
| 101 | Insert array formula | Ctrl+Shift+Enter |
^+⇧+Enter |
|
| 102 | Collapse an expanded array formula | Ctrl+E |
^+E |
|
| 103 | Show/hide formula help | Shift+F1 |
⇧+F1 |
|
| 104 | Full/compact formula help | F1 |
F1 |
|
| 105 | Absolute/relative references | F4 |
F4 |
|
| 106 | Toggle formula result previews | F9 |
F9 |
|
| 107 | Resize formula bar | Ctrl+Up |
^+Up |
|
| 108 | Turn on screen reader support | Ctrl+Alt+Z |
^+⌥+Z |
|
| 109 | Read column | Ctrl+Alt+Shift+C |
^+⌥+⇧+C |
|
| 110 | Read row | Ctrl+Alt+Shift+R |
^+⌥+⇧+R |
|