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