As a marketer, you already know that you love using Google Sheets to store data, track performance metrics, and create collaborative reports. But are you using the full Google Sheets shortcuts to simplify your workflow and save valuable time?

Whether you’re experienced with Google Sheets or just getting started, you’ll be happy to know that there are many easy and time-saving Google Sheets keyboard shortcuts you can use.

It might sound daunting to keep track of numerous keyboard shortcuts, but luckily I’ve included a list of Google Sheets shortcuts here that you can bookmark and come back to again and again.

30 Google Sheets Keyboard Shortcuts

1. Select a column

Ctrl + Space (PC and Mac)

2. Insert column on the left

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

3. Insert column to the right

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

4. Select row

Shift + Spacebar (PC and Mac)

5. Insert row above

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

6. Insert row below

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

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

7. Select All

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

8. Fill Range

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

9. Fill in

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

10. Fill in correctly

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)

Save work, open sheets, and paste values ​​with Google Sheets shortcuts

14. Insert a new worksheet

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 + Option + Shift + ; (Mac)

Insert new sheet, insert time, insert date, and insert date and time using Google Sheets shortcuts

18. Format as decimal

Ctrl + Shift + 1 (PC and Mac)

19. The format is 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 formatting

Ctrl + (PC), Command + (Mac)

Use Google Sheets shortcuts to format decimals, time, date, currency, percent or clear formatting

24. Show all formulas

Ctrl + ~ (PC and Mac)

25. Insert an array formula

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

26. Collapse expanded array formula

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

27. Show/Hide Formula Help

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

28. Complete compact formula help

F1 (PC), Fn + F1 (Mac)

29. Absolute/relative references

F4 (PC), Fn + F4 (Mac)

30. Toggle formula

F9 (PC), Fn + F9 (Mac)

Use Google Sheets shortcuts to display all formulas, insert array formulas, and more

Alternatives to Google Sheets Custom Keyboard Shortcuts

In the past, Google Sheets custom keyboard shortcuts were options that users could perform to customize the shortcuts in the way that works best for them. However, custom keyboard shortcuts in Google Sheets are not an option these days.

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

To do this, press Ctrl + / and click the button next to “Enable Compatible Spreadsheet Shortcuts.”

How to Enable Excel Shortcuts Using Google Sheets Shortcuts

After that, you’ll have over 100 new keyboard shortcuts for recording and sorting data in Google Sheets.

Work smarter and easier with Google Sheets keyboard shortcuts

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

Not only do these time-saving shortcuts make data logging more convenient, they also allow you to spend more time on other tasks—because, let’s face it, a marketer’s job is never done.

Business Google Form Template