Amazing Google Sheets Keyboard Shortcuts For Mac Users

Tutorials & Methods
,
1

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!

4 Likes