fbpx

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 shortcuts. We’ll highlight highly helpful 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

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
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 the current region around the selected cell ⌘ + Shift + *, Ctrl + Shift + *
Displays or hides the menus ⌘ + Option + R, Ctrl + Shift + F

 


DOWNLOAD FREE FILES NOW
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!

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Back to top button