![shortcuts for google sheets for mac shortcuts for google sheets for mac](https://images.zapier.com/storage/photos/fabe2b0c56b32f28020b32accce3e1d2.png)
In the past, Google Sheets custom keyboard shortcuts were an option users could perform to customize their shortcuts in a way that suited them best. Toggle FormulaĪn Alternative to Google Sheets Custom Keyboard Shortcuts Absolute/relative referencesį4 (PC), Fn + F4 (Mac) 30.
#Shortcuts for google sheets for mac full
Full Compact Formula Helpį1 (PC), Fn + F1 (Mac) 29. Shift + F1 (PC), Shift + Fn + F1 (Mac) 28.
![shortcuts for google sheets for mac shortcuts for google sheets for mac](https://i0.wp.com/www.techjunkie.com/wp-content/uploads/2020/09/60.pf2_.png)
Collapse an expanded array formulaĬtrl + E (PC), Command + E (Mac) 27. Insert array formulaĬtrl + Shift + Enter (PC), Command + Shift + Enter (Mac) 26. Clear formattingĬtrl + ~ (PC and Mac) 25.
![shortcuts for google sheets for mac shortcuts for google sheets for mac](https://static1.makeuseofimages.com/wordpress/wp-content/uploads/2021/08/pixelbuds-aseries-thumbnail.jpg)
Format as percentageĬtrl + Shift + 5 (PC and Mac) 23. Format as currencyĬtrl + Shift + 4 (PC and Mac) 22. Format as dateĬtrl + Shift + 3 (PC and Mac) 21. Format as timeĬtrl + Shift + 2 (PC and Mac) 20. Insert date and timeĬtrl + Alt + Shift + (PC), Command + Option + Shift + (Mac)Ĭtrl + Shift + 1 (PC and Mac) 19. Insert dateĬtrl + (PC), Command + (Mac) 17. Insert timeĬtrl + Shift + (PC), Command + Shift + (Mac) 16. Paste valuesĬtrl + Shift + V (PC), Command + Shift + V (Mac) Fill rightĬtrl + S (PC), Command + S (Mac) 12. Fill downĬtrl + D (PC), Command + D (Mac) 10. Fill rangeĬtrl + Enter (PC), Command + Enter (Mac) 9. Insert rows belowĪlt + i, then W (PC), Ctrl + Option + i, then B (Mac)Ĭtrl + A (PC), Command + A (Mac) 8. Insert rows aboveĪlt + i, then R (PC), Ctrl + Option + i, then R (Mac) 6. Insert columns to the rightĪlt + i, then O (PC), Ctrl + Option + i, then O (Mac) 4. Insert columns to the leftĪlt + i, then C (PC), Ctrl + Options + i, then C (Mac) 3. Select columnĬtrl + Space (PC and Mac) 2. Keeping track of the numerous keyboard shortcuts may sound daunting but, luckily, I’m here with a list of Google Sheets shortcuts you can bookmark and return to again and again.ģ0 Google Sheets Keyboard Shortcuts 1. Whether you’re experienced with Google Sheets or you’re just getting started, you’ll be happy to know there are many simple and time-saving Google Sheets keyboard shortcuts at your disposal. But are using the full arsenal of Google Sheets shortcuts available to streamline your workflow and save valuable time? As a marketer, you already know you love Google Sheets for storing data, tracking performance metrics, and creating collaborative reports.