Google Sheets Cheatsheet
// This might work...
http://ursooperduper.github.io/cheatsheets/google-sheets/
Google Sheets Cheatsheet
General
| ⌃ Space | Select column |
| ⇧ Space | Select row |
| ⌘ A | Select all |
| ⌘ ⇧ ⌫ | Hide background over selected cells |
| ⌘ Z | Undo |
| ⌘ Y | Redo |
| ⌘ F | find |
| ⌘ ⇧ H | Find and replace |
| ⌘ ↩ | Fill range |
| ⌘ D | Fill down |
| ⌘ R | Fill right |
| ⌘ S | Save |
| ⌘ O | Open |
| ⌘ P | |
| ⌘ C | Copy |
| ⌘ X | Cut |
| ⌘ V | Paste |
| ⌘ ⇧ V | Paste values only |
| ⌘ / | Show common keyboard shortcuts |
| ⌃ ⇧ K | Compact controls |
| ⌘ ⇧ K | Input tools on/off |
| ⌘ ⌥ ⇧ K | Select input tools |
Cell Formatting
| ⌘ B | Bolds |
| ⌘ U | Underline |
| ⌘ I | Italicize |
| ⌥ ⇧ 5 | Strikethrough |
| ⌘ ⇧ E | Center align |
| ⌘ ⇧ L | Left align |
| ⌘ ⇧ R | Right align |
| ⌥ ⇧ 1 | Apply top border |
| ⌥ ⇧ 2 | Apply right border |
| ⌥ ⇧ 3 | Apply bottom border |
| ⌥ ⇧ 4 | Apply left border |
| ⌥ ⇧ 6 | Remove borders |
| ⌥ ⇧ 7 | Apply outer border |
| ⌘ K | Insert link |
| ⌘ ⇧ ; | Insert name |
| ⌘ ; | Insert date |
| ⌃ ⇧ 1 | Format as decimal |
| ⌃ ⇧ 2 | Format as time |
| ⌃ ⇧ 3 | Format as date |
| ⌃ ⇧ 4 | Format as currency |
| ⌃ ⇧ 5 | Format as percentage |
| ⌃ ⇧ 6 | Format as exponent |
| ⌘ \\ | Clear formatting |
Insert or Delete Rows or Columns
| ⌃ ⌥ I, then R | Insert row above |
| ⌃ ⌥ I, then W | Insert row below |
| ⌃ ⌥ I, then C | Insert column to the left |
| ⌃ ⌥ I, then G | Insert column to the right |
| ⌃ ⌥ E, then D | Delete row |
| ⌃ ⌥ E, then E | Delete column |
Spreadsheet Navigation
| fn ← | Move to beginning of row |
| ⌘ fn ← | Move to beginning of sheet |
| fn → | Move to end of row |
| ⌘ fn → | Move to end of sheet |
| ⌘ ⌫ | Scroll to active cell |
| ⌘ ⇧ fn ↓ | Move to next sheet |
| ⌘ ⇧ fn ↑ | Move to previous sheet |
| ⌥ ⇧ K | Display list of sheets |
| ⌥ ↩ | Open hyperlink |
| ⌃ ⌘ ⇧ M | Move focus out of spreadsheet |
| ⌥ ⇧ Q | Move to quicksum |
| hold ⌃ ⌘, press E then P | Move focus to popup |
| ⌃ ⌘ R | Open drop-down menu on filtered cell |
| ⌘ ⌥ ⇧ G | Open revision history |
| ⇧ ⎋ | Open chat inside the spreadsheet |
| ⌘ ⎋ | Close drawing editor |
Notes and Comments
| ⇧ F2 | Insert/edit note |
| ⌘ ⌥ M | Insert/edit comment |
| ⌘ ⌥ ⇧ A | Open comment discussion thread |
| hold ⌃ ⌘, press E then C | Enter current comment |
| hold ⌃ ⌘, press N then C | Move to next comment |
| hold ⌃ ⌘, press P then C | Move to previous comment |
Menus
| ⌃ ⌥ F | File menu |
| ⌃ ⌥ E | Edit menu |
| ⌃ ⌥ V | View menu |
| ⌃ ⌥ I | Insert menu |
| ⌃ ⌥ O | Format menu |
| ⌃ ⌥ D | Data menu |
| ⌃ ⌥ T | Tools menu |
| ⌃ ⌥ M | Form menu |
| ⌃ ⌥ N | Add-ons menu |
| ⌃ ⌥ H | Help menu |
| ⌃ ⌥ A | Accessibility menu |
| ⌥ ⇧ S | Sheet menu |
| ⌘ ⇧ \\ | Context menu |
Formulas
| ⌃ ~ | Show all formulas |
| ⌘ ⇧ ↩ | Insert array formulas |
| ⌘ E | Collapse an expanded array formula |
| ⇧ fn F1 | Show/hide formula help |
Legend
| ⇧ | Shift |
| ⌃ | Control |
| ⌥ | Option |
| ⌘ | Command |
| ↩ | Return |
| ⎋ | Escape |
| ⌫ | Delete |
| ⇥ | Tab |
Print this page for a specially formatted version of this cheatsheet.
General
| ⌃ Space | Select column |
| ⇧ Space | Select row |
| ⌘ A | Select all |
| ⌘ ⇧ ⌫ | Hide background over selected cells |
| ⌘ Z | Undo |
| ⌘ Y | Redo |
| ⌘ F | find |
| ⌘ ⇧ H | Find and replace |
| ⌘ ↩ | Fill range |
| ⌘ D | Fill down |
| ⌘ R | Fill right |
| ⌘ S | Save |
| ⌘ O | Open |
| ⌘ P | |
| ⌘ C | Copy |
| ⌘ X | Cut |
| ⌘ V | Paste |
| ⌘ ⇧ V | Paste values only |
| ⌘ / | Show common keyboard shortcuts |
| ⌃ ⇧ K | Compact controls |
| ⌘ ⇧ K | Input tools on/off |
| ⌘ ⌥ ⇧ K | Select input tools |
Insert or Delete Rows or Columns
| ⌃ ⌥ I, then R | Insert row above |
| ⌃ ⌥ I, then W | Insert row below |
| ⌃ ⌥ I, then C | Insert column to the left |
| ⌃ ⌥ I, then G | Insert column to the right |
| ⌃ ⌥ E, then D | Delete row |
| ⌃ ⌥ E, then E | Delete column |
Formulas
| ⌃ ~ | Show all formulas |
| ⌘ ⇧ ↩ | Insert array formulas |
| ⌘ E | Collapse an expanded array formula |
| ⇧ fn F1 | Show/hide formula help |
Spreadsheet Navigation
| fn ← | Move to beginning of row |
| ⌘ fn ← | Move to beginning of sheet |
| fn → | Move to end of row |
| ⌘ fn → | Move to end of sheet |
| ⌘ ⌫ | Scroll to active cell |
| ⌘ ⇧ fn ↓ | Move to next sheet |
| ⌘ ⇧ fn ↑ | Move to previous sheet |
| ⌥ ⇧ K | Display list of sheets |
| ⌥ ↩ | Open hyperlink |
| ⌃ ⌘ ⇧ M | Move focus out of spreadsheet |
| ⌥ ⇧ Q | Move to quicksum |
| hold ⌃ ⌘, press E then P | Move focus to popup |
| ⌃ ⌘ R | Open drop-down menu on filtered cell |
| ⌘ ⌥ ⇧ G | Open revision history |
| ⇧ ⎋ | Open chat inside the spreadsheet |
| ⌘ ⎋ | Close drawing editor |
Menus
| ⌃ ⌥ F | File menu |
| ⌃ ⌥ E | Edit menu |
| ⌃ ⌥ V | View menu |
| ⌃ ⌥ I | Insert menu |
| ⌃ ⌥ O | Format menu |
| ⌃ ⌥ D | Data menu |
| ⌃ ⌥ T | Tools menu |
| ⌃ ⌥ M | Form menu |
| ⌃ ⌥ N | Add-ons menu |
| ⌃ ⌥ H | Help menu |
| ⌃ ⌥ A | Accessibility menu |
| ⌥ ⇧ S | Sheet menu |
| ⌘ ⇧ \\ | Context menu |
Cell Formatting
| ⌘ B | Bolds |
| ⌘ U | Underline |
| ⌘ I | Italicize |
| ⌥ ⇧ 5 | Strikethrough |
| ⌘ ⇧ E | Center align |
| ⌘ ⇧ L | Left align |
| ⌘ ⇧ R | Right align |
| ⌥ ⇧ 1 | Apply top border |
| ⌥ ⇧ 2 | Apply right border |
| ⌥ ⇧ 3 | Apply bottom border |
| ⌥ ⇧ 4 | Apply left border |
| ⌥ ⇧ 6 | Remove borders |
| ⌥ ⇧ 7 | Apply outer border |
| ⌘ K | Insert link |
| ⌘ ⇧ ; | Insert name |
| ⌘ ; | Insert date |
| ⌃ ⇧ 1 | Format as decimal |
| ⌃ ⇧ 2 | Format as time |
| ⌃ ⇧ 3 | Format as date |
| ⌃ ⇧ 4 | Format as currency |
| ⌃ ⇧ 5 | Format as percentage |
| ⌃ ⇧ 6 | Format as exponent |
| ⌘ \\ | Clear formatting |
Notes and Comments
| ⇧ F2 | Insert/edit note |
| ⌘ ⌥ M | Insert/edit comment |
| ⌘ ⌥ ⇧ A | Open comment discussion thread |
| hold ⌃ ⌘, press E then C | Enter current comment |
| hold ⌃ ⌘, press N then C | Move to next comment |
| hold ⌃ ⌘, press P then C | Move to previous comment |
Legend
⇧
Shift
⌃
Control
⌥
Option
⌘
Command
↩
Return
⎋
Escape
⌫
Delete
⇥
Tab