GOOGLE SHEETS KEYBOARD SHORTCUTS FOR PC

GOOGLE SHEETS KEYBOARD SHORTCUTS FOR PC - CHEAT SHEET

Topic ID Description PC Shortcut Topic ID Description PC Shortcut

1 New Window CTRL + N 46 File Menu ALT + F

2 New Tab CTRL + T 47 Edit Menu ALT + E

3 Close Current Tab CTRL + W 48 View Menu ALT + V

4 Move to Next Tab (right) CTRL + TAB 49 Insert Menu ALT + I

5 Move to Previous Tab (left) CTRL + SHIFT + TAB 50 Format Menu ALT + O

6 Highlight URL Address CTRL + L 51 Tools Menu ALT + T

7 Reload Current Web Page CTRL + R 52 Add-Ons Menu ALT + N

8 Find Text CTRL + F 53 Help Menu ALT + H

9 Show Google Drive Keyboard Shortcuts SHIFT + ? 54 Format Selected Cell(s) with Align Left CTRL + SHIFT + L

10 Open Selected File or Folder ENTER 55 Format Selected Cell(s) with Align Center CTRL + SHIFT + E

11 Go Previous (go back one folder) G then P 56 Format Selected Cell(s) with Align Right CTRL + SHIFT + R

12 Delete Selected File(s) or Folder(s) DEL 57 Add Top Border to Selected Cell(s) SHIFT + ALT + 1

13 Create New Folder SHIFT + F 58 Add Right Border to Selected Cell(s) SHIFT + ALT + 2

14 Rename Selected File or Folder N 59 Add Bottom Border to Selected Cell(s) SHIFT + ALT + 3

15 More Actions (right-click selected file(s) or folder(s)) A 60 Add Left Border to Selected Cell(s) SHIFT + ALT + 4

16 Move Selected File(s) or Folder(s) Z 61 Add Outside Border to Selected Cell(s) SHIFT + ALT + 7

17 Expand Selection of File(s) or Folder(s) SHIFT + ARROWS 62 Remove All Borders to Selected Cell(s) SHIFT + ALT + 6

18 Select Non-Adjacent File(s) or Folder(s) CTRL + ARROWS then X 63 Format Selected Cell(s) as "Decimal" CTRL + SHIFT + 1

19 Create New Google Doc SHIFT + T 64 Format Selected Cell(s) as "Time" CTRL + SHIFT + 2

20 Create New Google Sheet SHIFT + S 65 Format Selected Cell(s) as "Date" CTRL + SHIFT + 3

21 Close Current Workbook (Browser Tab) CTRL + W 66 Format Selected Cell(s) as "Currency" CTRL + SHIFT + 4

22 Move to Next Workbook (Browser Tab) CTRL + TAB 67 Format Selected Cell(s) as "Percentage" CTRL + SHIFT + 5

23 Move to Previous Workbook (Browser Tab) SHIFT + CTRL + TAB 68 Format Selected Cell(s) as "Exponent" CTRL + SHIFT + 6

24 Move to Next Worksheet (right) ALT + ↓ 69 Select Non-Adjacent Cells CTRL + Click

25 Move to Previous Worksheet (left) ALT + ↑ 70 Clear Formatting in Selected Cell(s) CTRL + \

26 Insert New Worksheet SHIFT + F11 71 Open Right-Click Menu Based on Current Selection CTRL + SHIFT + \

27 Select All CTRL + A 72 Insert Line Break (in cell edit mode) ALT + ENTER

28 Select Entire Column CTRL + SPACE 73 Repeat Last Action F4

29 Select Entire Row SHIFT + SPACE 74 Undo Last Action CTRL + Z

30 Insert Row(s) Above Current Selection ALT + I + R 75 Redo Last Action CTRL + Y

31 Insert Column(s) Left of Current Selection ALT + I + C 76 Cut Selected Cell(s) CTRL + X

32 Delete Selected Row(s) ALT + E + D 77 Copy Selected Cell(s) CTRL + C

33 Delete Selected Column(s) ALT + E + E 78 Paste Clipboard Contents to Selected Cells CTRL + V

34 Insert Cells(s) and Shift Current Selection Down ALT + I + D 79 Paste Values Only to Selected Cells CTRL + SHIFT + V

35 Insert Cells(s) and Shift Current Selection Right ALT + I + I 80 Paste Formats Only to Selected Cells CTRL + ALT + V

36 Delete Selected Cells(s) and Shift Up ALT + E + Y 81 Paste Formulas Only to Selected Cells ALT + E + S + F

37 Delete Selected Cells(s) and Shift Left ALT + E + Z 82 Paste Column Widths Only to Selected Cells ALT + E + S + W

38 Expand Selection of Cells SHIFT + ARROWS 83 Toggle Formula Audit Mode CTRL + ` (grave)

39 Catapult to Next or Last Non-Empty Cell CTRL + ARROWS 84 Toggle Absolute/Relative Cell References F4 (in cell edit mode)

40 Select & Catapult to Next or Last Non-Empty Cell SHIFT + CTRL + ARROWS 85 Toggle Function Help Window F1 (in cell edit mode)

41 Move to First Cell of Worksheet CTRL + Home 86 Auto-Complete Highlighted Function from List TAB (in cell edit mode)

42 Move to Last Cell of Worksheet CTRL + End 87 Open Dropdown List / Choose Highlighted List Item ENTER (cell w/ dropdown)

43 Edit Cell Contents / Save Cell Changes & Move 1 Down ENTER 88 Open Filter Dropdown Menu CTRL + ALT + R

44 Exit Cell Without Saving Changes ESC 89 Insert Today's Date Value Into Active Cell CTRL + ; (semi-colon)

45 Save Cell Changes & Move 1 Right TAB 90 Insert Current Time Value Into Active Cell CTRL + : (colon)

Additional Resources: https://excelshir.com/resources

Navigation Browser

Navigation Menus

Navigation Google Drive

Format

Align

Format Borders

Format Numbers

Nav. Workbooks

& Worksheets

Nav. Rows & Cols

Data Manipulation

Formulas

Drop-

downs

Format Misc

Navigation Cells

Quick

Values

GOOGLE SHEETS KEYBOARD SHORTCUTS FOR MAC - CHEAT SHEET

Topic ID Description MAC Shortcut Topic ID Description MAC Shortcut

1 New Window CMD + N 46 File Menu CTRL + OPT + F

2 New Tab CMD + T 47 Edit Menu CTRL + OPT + E

3 Close Current Tab CMD + W 48 View Menu CTRL + OPT + V

4 Move to Next Tab (right) CTRL + TAB 49 Insert Menu CTRL + OPT + I

5 Move to Previous Tab (left) CTRL + SHIFT + TAB 50 Format Menu CTRL + OPT + O

6 Highlight URL Address CMD + L 51 Tools Menu CTRL + OPT + T

7 Reload Current Web Page CMD + R 52 Add-Ons Menu CTRL + OPT + N

8 Find Text CMD + F 53 Help Menu CTRL + OPT + H

9 Show Google Drive Keyboard Shortcuts SHIFT + ? 54 Format Selected Cell(s) with Align Left SHIFT + CMD + L

10 Open Selected File or Folder ENTER 55 Format Selected Cell(s) with Align Center SHIFT + CMD + E

11 Go Previous (go back one folder) G then P 56 Format Selected Cell(s) with Align Right SHIFT + CMD + R

12 Delete Selected File(s) or Folder(s) fn + DEL 57 Add Top Border to Selected Cell(s) SHIFT + OPT + 1

13 Create New Folder SHIFT + F 58 Add Right Border to Selected Cell(s) SHIFT + OPT + 2

14 Rename Selected File or Folder N 59 Add Bottom Border to Selected Cell(s) SHIFT + OPT + 3

15 More Actions (right-click selected file(s) or folder(s)) A 60 Add Left Border to Selected Cell(s) SHIFT + OPT + 4

16 Move Selected File(s) or Folder(s) Z 61 Add Outside Border to Selected Cell(s) SHIFT + OPT + 7

17 Expand Selection of File(s) or Folder(s) SHIFT + ARROWS 62 Remove All Borders to Selected Cell(s) SHIFT + OPT + 6

18 Select Non-Adjacent File(s) or Folder(s) CMD + ARROWS then X 63 Format Selected Cell(s) as "Decimal" CTRL + SHIFT + 1

19 Create New Google Doc SHIFT + T 64 Format Selected Cell(s) as "Time" CTRL + SHIFT + 2

20 Create New Google Sheet SHIFT + S 65 Format Selected Cell(s) as "Date" CTRL + SHIFT + 3

21 Close Current Workbook (Browser Tab) CMD + W 66 Format Selected Cell(s) as "Currency" CTRL + SHIFT + 4

22 Move to Next Workbook (Browser Tab) CTRL + TAB 67 Format Selected Cell(s) as "Percentage" CTRL + SHIFT + 5

23 Move to Previous Workbook (Browser Tab) SHIFT + CTRL + TAB 68 Format Selected Cell(s) as "Exponent" CTRL + SHIFT + 6

24 Move to Next Worksheet (right) OPT + ↓ 69 Select Non-Adjacent Cells CMD + Click

25 Move to Previous Worksheet (left) OPT + ↑ 70 Clear Formatting in Selected Cell(s) CMD + \

26 Insert New Worksheet fn + SHIFT + F11 71 Open Right-Click Menu Based on Current Selection SHIFT + CMD + \

27 Select All CMD + A 72 Insert Line Break (in cell edit mode) OPT + ENTER

28 Select Entire Column CTRL + SPACE 73 Repeat Last Action F4

29 Select Entire Row SHIFT + SPACE 74 Undo Last Action CMD + Z

30 Insert Row(s) Above Current Selection CTRL + OPT + I + R 75 Redo Last Action CMD + Y

31 Insert Column(s) Left of Current Selection CTRL + OPT + I + C 76 Cut Selected Cell(s) CMD + X

32 Delete Selected Row(s) CTRL + OPT + E + D 77 Copy Selected Cell(s) CMD + C

33 Delete Selected Column(s) CTRL + OPT + E + E 78 Paste Clipboard Contents to Selected Cells CMD + V

34 Insert Cells(s) and Shift Current Selection Down CTRL + OPT + I + D 79 Paste Values Only to Selected Cells SHIFT + CMD + V

35 Insert Cells(s) and Shift Current Selection Right CTRL + OPT + I + I 80 Paste Formats Only to Selected Cells OPT + CMD + V

36 Delete Selected Cells(s) and Shift Up CTRL + OPT + E + Y 81 Paste Formulas Only to Selected Cells CTRL + OPT + E + S + F

37 Delete Selected Cells(s) and Shift Left CTRL + OPT + E + Z 82 Paste Column Widths Only to Selected Cells CTRL + OPT + E + S + W

38 Expand Selection of Cells SHIFT + ARROWS 83 Toggle Formula Audit Mode CTRL + ` (grave)

39 Catapult to Next or Last Non-Empty Cell CMD + ARROWS 84 Toggle Absolute/Relative Cell References fn + F4 (in cell edit mode)

40 Select & Catapult to Next or Last Non-Empty Cell SHIFT + CMD + ARROWS 85 Toggle Function Help Window F1 (in cell edit mode)

41 Move to First Cell of Worksheet fn + CMD + ← 86 Auto-Complete Highlighted Function from List TAB (in cell edit mode)

42 Move to Last Cell of Worksheet fn + CMD + → 87 Open Dropdown List / Choose Highlighted List Item ENTER (cell w/ dropdown)

43 Edit Cell Contents / Save Cell Changes & Move 1 Down ENTER 88 Open Filter Dropdown Menu CTRL + CMD + R

44 Exit Cell Without Saving Changes ESC 89 Insert Today's Date Value Into Active Cell CMD + ; (semi-colon)

45 Save Cell Changes & Move 1 Right TAB 90 Insert Current Time Value Into Active Cell CMD + : (colon)

Additional Resources: https://excelshir.com/resources

Quick

Values

Navigation Cells

Navigation Browser

Navigation Menus

Navigation Google Drive

Format

Align

Format Borders

Format Numbers

Nav. Workbooks

& Worksheets

Nav. Rows & Cols

Data Manipulation

Formulas

Drop-

downs

Format Misc