As a marketer, you already know you love Google Sheets for storing data, tracking performance metrics, and creating collaborative reports. But are using the full arsenal of Google Sheets shortcuts available to streamline your workflow and save valuable time?
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.
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.
30 Google Sheets Keyboard Shortcuts 1. Select columnCtrl + Space (PC and Mac)
2. Insert columns to the leftAlt + i, then C (PC), Ctrl + Options + i, then C (Mac)
3. Insert columns to the rightAlt + i, then O (PC), Ctrl + Option + i, then O (Mac)
4. Select rowShift + Space (PC and Mac)
5. Insert rows aboveAlt + i, then R (PC), Ctrl + Option + i, then R (Mac)
6. Insert rows belowAlt + i, then W (PC), Ctrl + Option + i, then B (Mac)
7. Select allCtrl + A (PC), Command + A (Mac)
8. Fill rangeCtrl + Enter (PC), Command + Enter (Mac)
9. Fill downCtrl + D (PC), Command + D (Mac)
10. Fill rightCtrl + R (PC), Command + R (Mac)
11. SaveCtrl + S (PC), Command + S (Mac)
12. OpenCtrl + O (PC), Command + O (Mac)
13. Paste valuesCtrl + Shift + V (PC), Command + Shift + V (Mac)
14. Insert new sheetShift + F11(PC), Shift + Fn + F11 (Mac)
15. Insert timeCtrl + Shift + ; (PC), Command + Shift +; (Mac)
16. Insert dateCtrl + ; (PC) , Command + ; (Mac)
17. Insert date and timeCtrl + Alt + Shift + ; (PC), Command + Option + Shift + ; (Mac)
18. Format as decimalsCtrl + Shift + 1 (PC and Mac)
19. Format as timeCtrl + Shift + 2 (PC and Mac)
20. Format as dateCtrl + Shift + 3 (PC and Mac)
21. Format as currencyCtrl + Shift + 4 (PC and Mac)
22. Format as percentageCtrl + Shift + 5 (PC and Mac)
23. Clear formattingCtrl + (PC), Command + (Mac)
24. Show all formulasCtrl + ~ (PC and Mac)
25. Insert array formulaCtrl + Shift + Enter (PC), Command + Shift + Enter (Mac)
26. Collapse an expanded array formulaCtrl + E (PC), Command + E (Mac)
27. Show/Hide Formula HelpShift + F1 (PC), Shift + Fn + F1 (Mac)
28. Full Compact Formula HelpF1 (PC), Fn + F1 (Mac)
29. Absolute/relative referencesF4 (PC), Fn + F4 (Mac)
30. Toggle FormulaF9 (PC), Fn + F9 (Mac)
An Alternative to Google Sheets Custom Keyboard ShortcutsIn the past, Google Sheets custom keyboard shortcuts were an option users could perform to customize their shortcuts in a way that suited them best. However, nowadays custom keyboard shortcuts in Google Sheets are not an option.
But don't worry! Another feature that can help you further streamline your work in Google Sheets is the ability to use compatible keyboard shortcuts from other digital spreadsheets, like Excel, in Google Sheets.
To do this, press Ctrl + / then click the button next to "Enable compatible spreadsheet shortcuts."
Afterward, you'll have more than 100 new keyboard shortcuts you can use to record and sort your data in Google Sheets.
Work Smarter, Not Harder, with Google Sheets Keyboard ShortcutsKeyboard shortcuts allow you, as a busy marketer, to streamline your workflow and cut down on the time it takes to record and sort data in Google Sheets. Best of all, these shortcuts are easy to implement whether you're on a Mac or PC.
Not only will these time-saving shortcuts make data recording more convenient, they'll also allow you to spend more time focusing on other tasks -because, let's face it, a marketer's work is never done.
Originally published Apr 22, 2022 7:00:00 AM, updated April 22 2022
Topics:
Google SheetsAttachments
- Original Link
- Original Document
- Permalink
Disclaimer
HubSpot Inc. published this content on 22 April 2022 and is solely responsible for the information contained therein. Distributed by Public, unedited and unaltered, on 22 April 2022 11:07:03 UTC.