Google Sheets Keyboard Shortcuts for Mac Users

Learn the keyboard shortcuts that make Google Sheets on Mac a breeze.

By . in Internet. Updated on .

Do you use a Mac and work with Google Sheets? 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 mac keyboard shortcuts

Google Sheets shortcuts for:

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
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
WebsiteFacebookTwitterInstagramPinterestLinkedInGoogle+YoutubeRedditDribbbleBehanceGithubCodePenWhatsappEmail