ToolsAmazing Google Sheets Keyboard Shortcuts For Mac Users

    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
    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
    See also  The new version of Google Wallet for Android devices has begun rolling out


    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
    See also  Google has released the first Android 13 patch for Pixel devices, which includes improvements to Bluetooth, battery life, and the user interface
    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!

    Montel Anthony
    Montel Anthony
    Montel Anthony is a passionate/enthusiastic Blogger who loves creating helpful guide contents for its users. I'm also a web developer, Graphics designer and Writer.


    Please enter your comment!
    Please enter your name here
    Captcha verification failed!
    CAPTCHA user score failed. Please contact us!

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

    Latest news

    Apple releases iOS 16.6.1 and macOS Ventura 13.5.2, here’s what’s new

    Apple today seeded minor updates to iOS 16 and macOS Ventura with critical security updates and bug fixes. The...

    Samsung’s One UI 6 lets you create a personalized voice for Bixby Text Call

    Samsung has been improving its One UI software with each iteration, adding new features and enhancements to its Galaxy...

    Microsoft bids farewell to WordPad, the legacy word processor for Windows

    Microsoft has quietly announced the end of WordPad for Windows, the basic word processor that has been bundled with...

    Sony Xperia 5 V: A Compact Flagship with a Huge Camera Upgrade

    Sony has announced its latest compact flagship smartphone, the Xperia 5 V, which features a new camera system with...


    Step-by-Step Guide: How to Download Tor on Chromebook

    Are you looking for a way to enjoy secure and anonymous internet browsing on your Chromebook? Here's an interesting fact: Tor Browser,...

    How to Disable the Lock Sound on an iPhone or iPad

    The sound of locking on an iPhone as well as an iPad is a short hum that is played...

    How to Enter the BIOS on Your Windows 11 PC

    The BIOS (Basic Input/Output System) is a firmware that manages both your boot process and hardware settings on a...

    How to Check CPU Compatibility for Windows 11

    Windows 11 is thе latеst opеrating systеm from Microsoft that offеrs many nеw fеaturеs and improvеmеnts ovеr Windows 10....

    How to Delete Threads Without Losing Your Instagram

    Is it possible to dеlеtе Thrеads without losing your Instagram account? Sadly, Mеta's social mеdia platform doesn't offer this...

    Must read

    The One UI 4 Beta 2 is Now Available for Samsung’s Galaxy S20 and Note20 Smartphones

    Along with today's One UI 4 update to remedy...

    How to use Bing Image Creator on Mobile (Android and iOS)

    After introducing Bing Chat, a chatbot powered by GPT4...

    You might also likeRELATED
    Recommended to you

    Welcome to Cloudorian Tech.