# Amazing Google Sheets Keyboard Shortcuts For Mac Users

**URL:** <https://onehack.st/t/amazing-google-sheets-keyboard-shortcuts-for-mac-users/254517>\
**Category:** Tutorials & Methods\
**Tags:** tools, tips-tricks\
**Created:** [September 24, 2023, 10:21am UTC](https://onehack.st/t/amazing-google-sheets-keyboard-shortcuts-for-mac-users/254517 "2023-09-24T10:21:00Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![PlayBoy83](https://onehack.st/user_avatar/onehack.st/playboy83/32/164314_2.png) [@PlayBoy83](https://onehack.st/u/PlayBoy83)\
**Post date:** [September 24, 2023, 10:21am UTC](https://onehack.st/t/amazing-google-sheets-keyboard-shortcuts-for-mac-users/254517/1 "2023-09-24T10:21:00Z")

</div>

Boost your productivity with our detailed guide to Google Sheets Mac keyboard shortcuts. Whether you’re dealing with basic navigation or intricate data handling, these shortcuts are a significant aid for those aiming to optimize their workflow.

**Google Sheets shortcuts for:**

- Common Actions
- Format Cells
- Navigate the Spreadsheet
- Edit Notes and Comments
- Use Keyboard Shortcuts on Selected Comments
- Open a Menu
- Add or Change Rows and Columns
- Use Formulas
- Help for Screen Readers

##### Common Actions

| Action | Shortcut |
| --- | --- |
| Select column | Ctrl + Space |
| Select row | Shift + Space |
| Select all | ⌘ + A, ⌘ + Shift + Space |
| Undo | ⌘ + Z |
| Redo | ⌘ + Y, ⌘ + Shift + Z, Fn + F4 |
| Find | ⌘ + F |
| Find and replace | ⌘ + Shift + H |
| Fill range | ⌘ + Enter |
| Fill down | ⌘ + D |
| Fill right | ⌘ + R |
| Save (every change is saved automatically in Drive) | ⌘ + S |
| Open | ⌘ + O |
| Print | ⌘ + P |
| Copy | ⌘ + C |
| Cut | ⌘ + X |
| Paste | ⌘ + V |
| Paste values only | ⌘ + Shift + V |
| Show common keyboard shortcuts | ⌘ + / |
| Insert new sheet | Shift + Fn + F11 |
| Compact controls | Ctrl + Shift + F |
| Input tools on/off (available in non-Latin languages) | ⌘ + Shift + K |
| Select input tools | ⌘ + Option + Shift + K |
| Tool finder (formerly Search the menus) | Option + / |
| Select current region around selected cell | ⌘ + Shift + \*, Ctrl + Shift + \* |
| Displays or hides the menus | ⌘ + Option + R, Ctrl + Shift + F |

##### Format Cells

| Action | Shortcut 1 | Shortcut 2 | Shortcut 3 |
| --- | --- | --- | --- |
| Bold | ⌘ + B | ⌘ + 2 | Ctrl + 2 |
| Underline | ⌘ + U | ⌘ + 4 | Ctrl + 4 |
| Italic | ⌘ + I | ⌘ + 3 | Ctrl + 3 |
| Strikethrough | ⌘ + Shift + X | ⌘ + 5 | Ctrl + 5 |
| Center align | ⌘ + Shift + E | | |
| Left align | ⌘ + Shift + L | | |
| Right align | ⌘ + Shift + R | | |
| Apply top border | Option + Shift + 1 | | |
| Apply right border | Option + Shift + 2 | | |
| Apply bottom border | Option + Shift + 3 | | |
| Apply left border | Option + Shift + 4 | | |
| Remove borders | Option + Shift + 6 | | |
| Apply outer border | Option + Shift + 7 | ⌘ + Shift + 7 | Ctrl + Shift + 7 |
| Insert link | ⌘ + K | | |
| Insert time | ⌘ + Shift + ; | | |
| Insert date | ⌘ + ; | | |
| Insert date and time | ⌘ + Option + Shift + ; | | |
| Format as decimal | Ctrl + Shift + 1 | | |
| Format as time | Ctrl + Shift + 2 | | |
| Format as date | Ctrl + Shift + 3 | | |
| Format as currency | Ctrl + Shift + 4 | | |
| Format as percentage | Ctrl + Shift + 5 | | |
| Format as exponent | Ctrl + Shift + 6 | | |
| Clear formatting | ⌘ + | | | |

##### Navigate the Spreadsheet

| Action | Shortcut | Shortcut(Macbook) |
| --- | --- | --- |
| Move to beginning of row | Fn + Left Arrow | |
| Move to beginning of sheet | ⌘ + Fn + Left Arrow | |
| Move to end of row | Fn + Right Arrow | |
| Move to end of sheet | ⌘ + Fn + Right Arrow | |
| Scroll to active cell | ⌘ + Backspace | |
| Move to next sheet | Option + Down Arrow | Option + Right Arrow |
| Move to previous sheet | Option + Up Arrow | Option + Left Arrow |
| Display list of sheets | Option + Shift + K | |
| Open hyperlink | Option + Enter | |
| Open Explore | ⌘ + Option + Shift + I | |
| Go to side panel | ⌘ + Option + . / ⌘ + Option + , | |
| Move focus out of spreadsheet | Ctrl + ⌘ + Shift + M | |
| Move to quicksum (when a range of cells is selected) | Option + Shift + Q | |
| Move focus to popup (for links, bookmarks, images) | hold Ctrl + ⌘, press E then P | |
| Open drop-down menu on filtered cell | Ctrl + ⌘ + R | |
| Open revision history | ⌘ + Option + Shift + H | |
| Close drawing editor | ⌘ + Esc / Shift + Esc | |
| Show “Go to range” dialog | Ctrl + G | |
| Find and replace with Find tab selected | Ctrl + F | |

##### Edit Notes and Comments

| Action | Macbook |
| --- | --- |
| Insert/edit note | Shift + F2 |
| Insert/edit comment | ⌘ + Option + M |
| Open comment discussion thread | ⌘ + Option + Shift + A |
| Enter current comment | hold Ctrl + ⌘, press E then C |
| Move to next comment | hold Ctrl + ⌘, press N then C |
| Move to previous comment | hold Ctrl + ⌘, press P then C |

##### Use Keyboard Shortcuts on Selected Comments

| Action | Macbook |
| --- | --- |
| Reply to current comment | R |
| Move to next comment | J |
| Move to previous comment | K |
| Resolve current comment | E |
| Exit current comment | U |

##### Open a Menu

| Open File menu | Ctrl + Option + F |
| --- | --- |
| Open Edit menu | Ctrl + Option + E |
| Open View menu | Ctrl + Option + V |
| Open Insert menu | Ctrl + Option + I |
| Open Format menu | Ctrl + Option + O |
| Open Data menu | Ctrl + Option + D |
| Open Tools menu | Ctrl + Option + T |
| Open insert menu (with cells selected) | ⌘ + Option + = |
| Open delete menu (with cells selected) | ⌘ + Option + – |
| Open Form menu (when connected to a form) | Ctrl + Option + M |
| Open Add-ons menu | Ctrl + Option + N |
| Open Help menu | Ctrl + Option + H |
| Open Accessibility menu (screen reader support) | Ctrl + Option + A |
| Open Sheet menu (copy, delete, other sheet actions) | Option + Shift + S |
| Open Context menu | ⌘ + Shift + \ or Shift + F10 |

##### Add or Change Rows and Columns

| Action | Shortcut |
| --- | --- |
| Insert rows above | ⌘ + Option + = (with rows selected) |
| Insert rows below | |
| Insert columns to the left | ⌘ + Option + = (with columns selected) |
| Insert columns to the right | |
| Delete rows | ⌘ + Option + – (with rows selected) |
| Delete columns | ⌘ + Option + – (with columns selected) |
| Hide row | ⌘ + Option + 9 |
| Unhide row | ⌘ + Shift + 9 |
| Hide column | ⌘ + Option + 0 |
| Unhide column | ⌘ + Shift + 0 |
| Group rows or columns | Option + Shift + Right Arrow |
| Ungroup rows or columns | Option + Shift + Left Arrow |
| Expand grouped rows or columns | Option + Shift + Down Arrow |
| Collapse grouped rows or columns | Option + Shift + Up Arrow |

##### Use Formulas

| Action | Shortcut |
| --- | --- |
| Show all formulas | Ctrl + ~ |
| Insert array formula | ⌘ + Shift + Enter |
| Collapse an expanded array formula | ⌘ + E |
| Show/hide formula help (when entering a formula) | Shift + Fn + F1 |
| Full/compact formula help (when entering a formula) | Fn + F1 |
| Absolute/relative references (when entering a formula) | Fn + F4 |
| Toggle formula result previews (when entering a formula) | Fn + F9 |
| Resize formula bar (move up or down) | Ctrl + Option + Up and Ctrl + Option + Down |
| Toggle formula range selection (when entering a formula) | F2, Ctrl + E |

##### Help for Screen Readers

| Action | Shortcut |
| --- | --- |
| Turn on screen reader support | ⌘ + Option + Z |
| Learn more about using Google Sheets with a screen reader | ⌘ + Option + Z |
| Enable braille support | ⌘ + Option + H |
| Read column | ⌘ + Option + Shift + C |
| Read row | ⌘ + Option + Shift + R |

**Happy learning!**