30 Google Sheets Shortcuts Marketers Need to Know

As a marketer, you already know that you like Google Sheets for storing data, tracking performance metrics, and creating collaborative reports. But are you using the full array of Google Spreadsheets shortcuts available to streamline your workflow and save valuable time?

Whether you’re new to Google Spreadsheets or just starting out, you’ll want to know that you have many simple keyboard shortcuts that save you time.

Keeping track of the many keyboard shortcuts may seem daunting, but luckily I’m here with a list of Google Spreadsheets shortcuts that you can dial in and back to again.

→ Sign in now: Google Spreadsheets Templates [Free Kit]

30 Google Sheets keyboard shortcuts

1. Select the column

Ctrl + space (PC and Mac)

2. Insert columns on the left

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

3. Insert columns on the right

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

4. Select the row

Shift + space (PC and Mac)

5. Insert rows at the top

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

6. Insert rows below

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

How to use Google Spreadsheets shortcuts to select columns, insert left or right columns, select row, and select rows above or below.

7. Select everything

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

8. Fill in the range

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

9. Fill down

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

10. Fill to the right

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

How to use Google Spreadsheets shortcuts to select everything, fill in the range, fill down, and fill in the 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)

Use Google Spreadsheets shortcuts to save work, open worksheets, and paste values

14. Insert a new sheet

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

15. Enter time

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

16. Insert date

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

17. Insert date and time

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

Use Google Spreadsheets shortcuts to insert a new sheet, insert time, insert date, and insert date and time

18. Format as decimals

Ctrl + Shift + 1 (PC and Mac)

19. Format as time

Ctrl + Shift + 2 (PC and Mac)

20. Format as date

Ctrl + Shift + 3 (PC and Mac)

21. Format as currency

Ctrl + Shift + 4 (PC and Mac)

22. Format as a percentage

Ctrl + Shift + 5 (PC and Mac)

23. Clear format

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

Use Google Spreadsheets shortcuts to format as decimals, time, date, currency, percentage, or to clear the format

24. Show all formulas

Ctrl + ~ (PC and Mac)

25. Insert the matrix formula

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

26. Reduce an expanded matrix formula

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

27. Show / hide formula help

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

28. Complete help of compact formula

F1 (PC), Fn + F1 (Mac)

29. Absolute / relative references

F4 (PC), Fn + F4 (Mac)

30. Alternate the formula

F9 (PC), Fn + F9 (Mac)

Use Google Spreadsheets shortcuts to show all formulas, insert array formulas, and more

An alternative to Google Sheets custom keyboard shortcuts

In the past, custom keyboard shortcuts in Google Spreadsheets were an option for users to customize their shortcuts in the way that suited them best. However, custom keyboard shortcuts in Google Spreadsheets are not an option today.

But don’t worry! Another feature that can help you streamline your work on Google Spreadsheets is the ability to use compatible keyboard shortcuts from other digital spreadsheets, such as Excel, in Google Spreadsheets.

To do this, press Ctrl + /, and then click the button next to “Enable supported spreadsheet shortcuts.”

How to enable Excel shortcuts with Google Sheets shortcuts

Then you have more than 100 new shortcut keys that you can use to save and sort your data in Google Spreadsheets.

Work smarter, not harder, with Google Sheets keyboard shortcuts

Keyboard shortcuts allow you, as a busy marketer, to streamline your workflow and reduce the time it takes to record and sort data in Google Spreadsheets. Best of all, these shortcuts are easy to implement whether you’re on a Mac or a PC.

These time-saving shortcuts will not only make recording data more convenient, but will also allow you to spend more time focusing on other tasks, because, let’s be honest, a salesperson’s job is never ends.

Google Business Sheet Templates

Source link

Leave a Reply