Amazing Google Sheets Keyboard Shortcuts For Mac Users
Do you utilize Google Sheets on your Mac? If yes, you could reduce time and boost the efficiency of your work by becoming familiar with keyboard shortcuts. We’ll highlight highly helpful Google Sheets keyboard shortcuts for Mac users. We’ve divided these shortcuts into sections to make them quick to access. Here’s a summary of the information you’ll find in this article:
- Common actions: The shortcuts are designed to perform the basics of opening of and shutting down files backing up your work, and reversing mistakes.
- Format cells: The shortcuts allow you to easily change the size, and font as well as alignment and formatting options for your cells.
- Navigation of your Spreadsheet: These shortcuts assist you in moving through your spreadsheet fast and efficiently.
- Modify Notes and Commentaries: These shortcuts allow you to rapidly add or edit and remove notes and other comments to your spreadsheet.
- Keyboard Shortcuts to selected comments: These shortcuts let you quickly respond to, delete and transfer selected comments.
- Open a menu: These shortcuts allow you to open menus swiftly without your mouse.
- Add or Edit Columns and Rows: These shortcuts let you quickly add or modify columns and rows in your spreadsheet.
- Formulas: This shortcut lets you swiftly add and edit formulas within your spreadsheet.
- Aid for Screen Readers: The shortcuts provided provide assistance for screen readers that are used by those who have visual impairments.
We hope you will find these keyboard shortcuts useful!
Check 70+ Common and Helpful Keyboard Shortcuts on Mac
Google Sheets Keyboard Shortcuts For Mac
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 |
| ⌘ + 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 the current region around the 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 the beginning of the row | Fn + Left Arrow | |
| Move to the beginning of the sheet | ⌘ + Fn + Left Arrow | |
| Move to the end of the row | Fn + Right Arrow | |
| Move to the end of the sheet | ⌘ + Fn + Right Arrow | |
| Scroll to the active cell | ⌘ + Backspace | |
| Move to the next sheet | Option + Down Arrow | Option + Right Arrow |
| Move to the 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 the side panel | ⌘ + Option + . / ⌘ + Option + , | |
| Move focus out of a spreadsheet | Ctrl + ⌘ + Shift + M | |
| Move to quick sum (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 the drop-down menu on the 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 the 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 the next comment | Hold Ctrl + ⌘, press N then C |
| Move to the previous comment | Hold Ctrl + ⌘, press P then C |
Use Keyboard Shortcuts on Selected Comments
| Action | Macbook |
|---|---|
| Reply to the current comment | R |
| Move to the next comment | J |
| Move to the 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 the 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 |
Keyboard shortcuts can save countless hours when using Google Sheets, making the experience far faster and more efficient than before. By learning and mastering some of the more commonly utilized shortcuts, your efficiency will quickly increase resulting in time saved and greater output from each workday.
Explore all of the shortcuts listed here and discover which are most suitable to you. If you know of other useful Google Sheets keyboard shortcuts for Mac users, feel free to post them below as comments! We welcome your ideas too – feel free to post in!
