As a marketer, you recognize you’re keen on Google Sheets for storing knowledge, monitoring efficiency metrics, and growing collaborative stories. However are the usage of the overall arsenal of Google Sheets shortcuts to be had to streamline your workflow and save precious time?

Whether or not you’re skilled with Google Sheets otherwise you’re simply getting began, you’ll be at liberty to understand there are lots of easy and time-saving Google Sheets keyboard shortcuts at your disposal.

Maintaining a tally of the a lot of keyboard shortcuts might sound daunting however, fortunately, I’m right here with an inventory of Google Sheets shortcuts you’ll be able to bookmark and go back to over and over again.

→ Access Now: Google Sheets Templates [Free Kit]

30 Google Sheets Keyboard Shortcuts

1. Make a choice column

Ctrl + House (PC and Mac)

2. Insert columns to the left

Alt + i, then C (PC), Ctrl + Choices + i, then C (Mac)

3. Insert columns to the appropriate

Alt + i, then O (PC), Ctrl + Possibility + i, then O (Mac)

4. Make a choice row

Shift + House (PC and Mac)

5. Insert rows above

Alt + i, then R (PC), Ctrl + Possibility + i, then R (Mac)

6. Insert rows beneath

Alt + i, then W (PC), Ctrl + Possibility + i, then B (Mac)

How to use Google Sheets Shortcuts to select columns, insert columns to the left or right, select row, and select rows above or below.

7. Make a choice all

Ctrl + A (PC), Command + A (Mac)

8. Fill vary

Ctrl + Input (PC), Command + Input (Mac)

9. Fill down

Ctrl + D (PC), Command + D (Mac)

10. Fill proper

Ctrl + R (PC), Command + R (Mac)

How to use Google Sheets shortcuts to select all, fill range, fill down, and fill right.

11. Save

Ctrl + S (PC), Command + S (Mac)

12. Open

Ctrl + O (PC), Command + O (Mac)

13. Paste values

Ctrl + Shift + V (PC), Command + Shift + V (Mac)

Using Google Sheets shortcuts to save work, open sheets, and paste values

14. Insert new sheet

Shift + F11(PC), Shift + Fn + F11 (Mac)

15. Insert time

Ctrl + Shift + ; (PC), Command + Shift +; (Mac)

16. Insert date

Ctrl + ; (PC) , Command + ; (Mac)

17. Insert date and time

Ctrl + Alt + Shift + ; (PC), Command + Possibility + Shift + ; (Mac)

Using Google Sheets shortcuts to insert new sheet, insert time, insert date, and insert date and time

18. Layout as decimals

Ctrl + Shift + 1 (PC and Mac)

19. Layout as time

Ctrl + Shift + 2 (PC and Mac)

20. Layout as date

Ctrl + Shift + 3 (PC and Mac)

21. Layout as forex

Ctrl + Shift + 4 (PC and Mac)

22. Layout as proportion

Ctrl + Shift + 5 (PC and Mac)

23. Transparent formatting

Ctrl + (PC), Command + (Mac)

Using Google Sheets shortcuts to format as decimals, time, date, currency, percentage, or to clear formatting

24. Display all formulation

Ctrl + ~ (PC and Mac)

25. Insert array components

Ctrl + Shift + Input (PC), Command + Shift + Input (Mac)

26. Cave in an expanded array components

Ctrl + E (PC), Command + E (Mac)

27. Display/Disguise Formulation Assist

Shift + F1 (PC), Shift + Fn + F1 (Mac)

28. Complete Compact Formulation Assist

F1 (PC), Fn + F1 (Mac)

29. Absolute/relative references

F4 (PC), Fn + F4 (Mac)

30. Toggle Formulation

F9 (PC), Fn + F9 (Mac)

Using Google Sheets shortcuts to show all formulas, insert array formula, and more

An Selection to Google Sheets Customized Keyboard Shortcuts

Up to now, Google Sheets customized keyboard shortcuts had been an choice customers may just carry out to customise their shortcuts in some way that suited them absolute best. Then again, this present day customized keyboard shortcuts in Google Sheets don’t seem to be an choice.

However don’t fear! Any other function that let you additional streamline your paintings in Google Sheets is the power to make use of appropriate keyboard shortcuts from different virtual spreadsheets, like Excel, in Google Sheets.

To try this, press Ctrl + / then click on the button subsequent to “Permit appropriate spreadsheet shortcuts.”

How to enable Excel shortcuts with Google Sheets shortcuts

Later on, you’ll have greater than 100 new keyboard shortcuts you’ll be able to use to file and type your knowledge in Google Sheets.

Paintings Smarter, Now not More difficult, with Google Sheets Keyboard Shortcuts

Keyboard shortcuts permit you, as a hectic marketer, to streamline your workflow and minimize down at the time it takes to file and type knowledge in Google Sheets. Best possible of all, those shortcuts are simple to put into effect whether or not you’re on a Mac or PC.

Now not most effective will those time-saving shortcuts make knowledge recording extra handy, they’ll additionally assist you to spend extra time that specialize in different duties —as a result of, let’s face it, a marketer’s paintings isn’t completed.

business google sheets templates

WordPress SEO

[ continue ]