In this article:

Google Sheets Shortcuts: The Ultimate Guide in 2024

google sheets shortcuts
Source: business.tutsplus.com

Google Sheets Shortcuts 

Using keyboard shortcuts in Google Sheets increases efficiency in handling tasks, complex calculations or even simple tasks. Below are some of the most common Google Sheets shortcuts that you can use. 

1. Shortcut for Fill Color in Google Sheets

Here’s how to apply a background color to selected cells:

Shortcut for PC - Alt + H, H

Shortcut for Mac - Use Format menu (No direct shortcut)

For PC users, select the cells you wish to color, press Alt + H, H, and choose your desired color. Mac users need to navigate through the Format menu to select "Fill color."

2. Shortcut for Strikethrough in Google Sheets

To easily apply or remove strikethrough formatting, follow the shortcut below.

Shortcut for PC - Alt + Shift + 5

Shortcut for Mac - Cmd + Shift + X

Highlight the text or cell you wish to format and use the shortcut to toggle strikethrough on or off.

3. How to Tab Down in Google Sheets

Navigate down cells quickly with this simple shortcut.

Shortcut for PC - Enter

Shortcut for Mac -Enter

Press Enter to move the selection down to the next cell and facilitate efficient data entry down a column.

4. Google Sheets Paint Format Shortcut

Copy and apply formatting from one cell to another easily with the shortcut below.

Shortcut for PC - Ctrl + Alt + V

Shortcut for Mac - Cmd + Option + V

Select the cell with the formatting you wish to copy, press the shortcut, then click on the cell(s) where you want to apply the formatting.

5. Google Sheets Copy Formatting Shortcut

To duplicate cell formatting quickly across your spreadsheet, follow the shortcut below.

Shortcut for PC - Ctrl + Alt + V

Shortcut for Mac - Cmd + Option + V

This works similarly to the Paint format. Use this shortcut after copying a cell's format to apply it elsewhere efficiently.

6. How to Search in Google Sheets Shortcut

Find text or numbers within your sheet instantly with the search keyboard shortcut.

Shortcut for PC - Ctrl + F

Shortcut for Mac - Cmd + F

Activate the search box with the shortcut and enter your query to locate specific data quickly.

7. Google Sheets Edit Cell Shortcut

To edit cell contents directly, use the shortcut below.

Shortcut for PC - F2

Shortcut for Mac - Enter or Cmd + U

Press the shortcut to enter edit mode in the selected cell to allow for a more immediate content modification.

8. Google Sheets Highlight Shortcut

Highlight cells easily using the fill color functionality.

Shortcut for PC - Alt + H, H

Shortcut for Mac - Use Format menu (No direct shortcut)

Leverage the Fill Color shortcut for highlighting. Select cells and apply your chosen color for emphasis.

9. Shortcut to Switch Tabs in Google Sheets

Navigate between sheets within a workbook effortlessly.

Shortcut for PC - Ctrl + Page Up/Page Down

Shortcut for Mac - Option + Up/Down arrow

Use this shortcut to move quickly between multiple sheets in your workbook to enhance navigation efficiency.

10. Google Sheets Zoom Shortcut

Adjust your sheet's view to zoom in or out.

Shortcut for PC - Ctrl + Alt + Mouse Scroll

Shortcut for Mac - Cmd + Alt + Mouse Scroll

Control the zoom level of your Google Sheets document by scrolling the mouse wheel while holding down the specified keys.

11. Paste Values Only Shortcut in Google Sheets

Paste copied content as values only and strip away formatting.

Shortcut for PC - Ctrl + Shift + V

Shortcut for Mac - Cmd + Shift + V

Copy any cell's content and use this shortcut to paste only the value into another cell and omit the original cell's formatting.

12. Google Sheets Autofit Column Width Shortcut

Automatically adjust column width to fit content.

Shortcut for PC - Double-click the right edge of the column header

Shortcut for Mac - Double-click the right edge of the column header

Auto-resize a column to fit its content by double-clicking the right border of the column header to simplify column width adjustments.

13. Repeat the Last Action

Easily replicate your most recent action with a single keystroke.

Shortcut for PC - Ctrl + Y

Shortcut for Mac - Cmd + Y

This command is useful for repeating the last action, such as formatting changes across multiple cells without manually redoing each step.

14. Cut/Copy/Paste/Undo/Redo

Below are some of the most essential editing commands for efficient data management.

Cut

Shortcut for PC - Ctrl + X

Shortcut for Mac - Cmd + X

Copy

Shortcut for PC - Ctrl + C

Shortcut for Mac - Cmd + C

Paste

Shortcut for PC - Ctrl + V

Shortcut for Mac - Cmd + V

Undo

Shortcut for PC - Ctrl + Z

Shortcut for Mac - Cmd + Z

Redo

Shortcut for PC - Ctrl + Y

Shortcut for Mac - Cmd + Shift + Z

These shortcuts allow for quick modification of your data to make it easy to move, duplicate, or revert changes in your spreadsheet.

15. Insert Row or Insert Column

Add new rows or columns to your sheet without navigating menus using the shortcuts below.

Insert Row

Shortcut for PC - Ctrl + Alt + I, R

Shortcut for Mac - Cmd + Option + I, R

Insert Column

Shortcut for PC - Ctrl + Alt + I, C

Shortcut for Mac - Cmd + Option + I, C

These shortcuts provide a fast way to expand your sheet by adding rows or columns at the cell's location.

16. Delete Row or Delete Column

Remove unwanted rows or columns quickly with the shortcuts below.

Delete Row

Shortcut for PC - Ctrl + Alt + E, D

Shortcut for Mac - Cmd + Option + E, D

Delete Column

Shortcut for PC - Ctrl + Alt + E, D

Shortcut for Mac - Same as PC

17. Select the Whole Row or Select Whole Column

Highlight entire rows or columns for quick actions using the shortcuts below.

Select Whole Row

Shortcut for PC - Shift + Space

Shortcut for Mac - Shift + Space

Select Whole Column

Shortcut for PC - Ctrl + Space

Shortcut for Mac - Cmd + Space

Use these shortcuts to quickly select entire rows or columns for formatting, copying, or deleting.

18. Add New Sheet in Google Sheets with a Shortcut

Create a new sheet within your workbook instantly using the shortcuts below.

Shortcut for PC - Shift + F11

Shortcut for Mac - Fn + Shift + F11

19. Formatting Shortcuts (Bold, Underline, Italics, Strikethrough)

Use the shortcuts below to apply common text formatting options.

Bold

Shortcut for PC - Ctrl + B

Shortcut for Mac - Cmd + B

Underline

Shortcut for PC - Ctrl + U

Shortcut for Mac - Cmd + U

Italics

Shortcut for PC - Ctrl + I

Shortcut for Mac - Cmd + I

Strikethrough

Shortcut for PC - Alt + Shift + 5

Shortcut for Mac - Cmd + Shift + X

Emphasize or denote text in your cells quickly with these formatting shortcuts.

20. Cell Alignment Shortcuts in Google Sheets

Adjust the alignment of your cell content using the shortcuts below.

Left Align

Shortcut for PC - Alt + H, A, L

Shortcut for Mac - Use Format menu

Center Align

Shortcut for PC - Alt + H, A, C

Shortcut for Mac -Use Format menu

Right Align

Shortcut for PC - Alt + H, A, R

Shortcut for Mac - Use Format menu

21. Insert a Link in a Cell Using a Shortcut

Embed hyperlinks directly into your cells for easy access to related resources.

Shortcut for PC - Ctrl + K

Shortcut for Mac - Cmd + K

You can turn text into clickable links to external websites, documents, or email addresses with this shortcut.

22. Open Links with a Shortcut

Access linked resources or web pages directly from your sheet using the shortcut below.

Shortcut for PC - Alt + Enter

Shortcut for Mac - Cmd + Enter

23. Quick Sum

Use the shortcut below to easily sum selected cells.

Shortcut for PC - Alt + =

Shortcut for Mac - Cmd + Shift + T

Highlight a range of cells you want to sum and press the shortcut. Google Sheets will automatically insert the sum function at the end of the selected range or next to it.

24. Format as Currency

Use the shortcut below to format selected cells as currency.

Shortcut for PC - Ctrl + Shift + 4

Shortcut for Mac - Cmd + Shift + 4

Select the cells containing numerical values you wish to format and apply the shortcut. This will format the numbers as currency while adding the currency symbol and two decimal places.

25. Format as Percentage

Convert selected cells' values to percentages using the shortcut below.

Shortcut for PC - Ctrl + Shift + 5

Shortcut for Mac - Cmd + Shift + 5

Highlight the cells you'd like to format and use the shortcut. This converts the numbers into percentages which is useful for financial analysis and reporting.

26. Apply Date Format

Shortcut for PC - Ctrl + Shift + 3

Shortcut for Mac - Cmd + Shift + 3

Select your cells and use the shortcut to format them as dates to make it easier to read and understand chronological data.

27. Clear Formatting

Remove any cell formatting in Google Sheets to reset its appearance using the shortcuts below.

Shortcut for PC - Ctrl + \

Shortcut for Mac - Cmd + \

To remove all formatting from selected cells, such as font styles, colors, and cell background colors, use this shortcut. It restores the default formatting.

28. Google Sheets Shortcuts PDF

To save a Google Sheets document as a PDF:

Press Ctrl + P (PC) or Cmd + P (Mac) to open the print dialog. Set the destination to "Save as PDF" and click "Save".

Source: business.tutsplus.com

30+ Google Sheets Keyboard Shortcuts

Here are more keyboard shortcuts for Google Sheets that you should know. 

Common Actions

1. Undo

Shortcut for PC - Ctrl + Z

Shortcut for Mac - Cmd + Z

2. Redo

Shortcut for PC - Ctrl + Y

Shortcut for Mac - Cmd + Shift + Z

3. Copy

Shortcut for PC - Ctrl + C

Shortcut for Mac - Cmd + C

4. Cut

Shortcut for PC - Ctrl + X

Shortcut for Mac - Cmd + X

5. Paste

Shortcut for PC - Ctrl + V

Shortcut for Mac - Cmd + V

6. Paste Values Only

Shortcut for PC - Ctrl + Shift + V

Shortcut for Mac - Cmd + Shift + V

Formatting

7. Bold

Shortcut for PC - Ctrl + B

Shortcut for Mac - Cmd + B

8. Italic

Shortcut for PC - Ctrl + I

Shortcut for Mac - Cmd + I

9. Underline

Shortcut for PC - Ctrl + U

Shortcut for Mac - Cmd + U

10. Strikethrough

Shortcut for PC - Alt + Shift + 5

Shortcut for Mac - Cmd + Shift + X

11. Text Wrap

Shortcut for PC - Ctrl + Shift + W

Shortcut for Mac - Cmd + Option + W

12. Merge Cells

Shortcut for PC - Alt + O, M

Shortcut for Mac - No direct shortcut

Navigating the Spreadsheet

13. Go to Beginning

Shortcut for PC - Ctrl + Home

Shortcut for Mac - Cmd + Up Arrow

14. Go to End

Shortcut for PC - Ctrl + End

Shortcut for Mac - Cmd + Down Arrow

15. Move to Next Sheet

Shortcut for PC - Ctrl + Shift + PgDn

Shortcut for Mac - Cmd + Shift + Fn + Down Arrow

16. Move to Previous Sheet

Shortcut for PC - Ctrl + Shift + PgUp

Shortcut for Mac - Cmd + Shift + Fn + Up Arrow

Editing Notes and Comments

17. Insert Comment

Shortcut for PC - Ctrl + Alt + M

Shortcut for Mac - Cmd + Option + M

18. Edit Comment

Shortcut for PC - Ctrl + Enter

Shortcut for Mac - Cmd + Enter

19. Close Comment

Shortcut for PC - Esc

Shortcut for Mac - Esc

Use Keyboard in Selected Comments

20. Reply to Comment

Shortcut for PC - R

Shortcut for Mac - R

21. Resolve Comment

Shortcut for PC - E

Shortcut for Mac - E

Open Menu

22. Open Context Menu

Shortcut for PC - Shift + F10

Shortcut for Mac - Shift + F10 or Ctrl + Fn + F10

Add or Change Rows and Columns

23. Insert Row Above

Shortcut for PC - Ctrl + Alt + =

Shortcut for Mac - Cmd + Option + =

24. Insert Row Below

Shortcut for PC - Ctrl + Alt + -

Shortcut for Mac - Cmd + Option + -

25. Delete Row

Shortcut for PC - Ctrl + Alt + E

Shortcut for Mac - Cmd + Option + E

26. Insert Column Left

Shortcut for PC - Ctrl + Alt + [

Shortcut for Mac - Cmd + Option + [

27. Insert Column Right

Shortcut for PC - Ctrl + Alt + ]

Shortcut for Mac - Cmd + Option + ]

Use Formulas

28. Start a Formula

Shortcut for PC - =

Shortcut for Mac - =

29. Array Formula

Shortcut for PC - Ctrl + Shift + Enter

Shortcut for Mac - Cmd + Shift + Enter

30. Absolute/Relative Refs

Shortcut for PC - F4

Shortcut for Mac - Cmd + T

Help for Screen Readers

31. Read Column and Row

Shortcut for PC - Ctrl + Alt + Shift + C

Shortcut for Mac - Cmd + Option + Shift + C

32. Speak from A1 to Selected Cell

Shortcut for PC - Ctrl + Alt + Shift + X

Shortcut for Mac - Cmd + Option + Shift + X

We hope that you now have a better understanding of some of the most commonly used Google Sheets shortcuts and how to use them.

If you enjoyed this article, you might also like our article on query not equal in Google Sheets or our article on how to reference another sheet on Google Sheets.  

Automate repetitive tasks with Lido

Save hours on repetitive and tedious work. Lido is a new spreadsheet that connects your spreadsheets, forms, PDFs, and email inbox.

Trigger
Action
Select trigger
When a cell value in Google Sheets changes
Check Google Sheets for today's date
When a new row is added to Google Sheets
On new Google Form submission
Send me a daily reminder
On new Typeform submission
When a cell value in database changes
Check database for today's date
When a new row is added in database
When a new HubSpot customer is created
Select action
ADDCALENDAREVENT
Creates a one- or multiple-day calendar event with optional attendees
ADDHUBSPOT
Adds an object to Hubspot
ADDSLACKCHANNEL
Create a Slack channel, and optionally add a topic or members
CALLURL
Makes any HTTP request
CREATEGOOGLEDOC
Replaces [@column_name] values in a Google Doc with the corresponding table row's values
CREATEPDF
Replaces [@column_name] values in a Google Doc with the corresponding table row's values, then export it as a PDF
FETCH
Makes any HTTP request and returns the response
INSERTROWS
Inserts given array below defined values in given worksheet
SENDGMAIL
Sends an email using your Google account
SENDOUTLOOK
Sends an email using your Microsoft Outlook account
SENDSLACK
Sends a Slack message
SENDSMS
Sends an SMS message using your Twilio account
UPDATECELL
Updates cells with given values
UPDATEHUBSPOT
Updates a property of a Hubspot object
Trigger is required
Action is required
Get started