Here’s Every Google Sheets Keyboard Shortcut

  • MORE

Spreadsheet programs like Google Sheets can be highly effective tools for organizing data, and even moreso for those who learn the keyboard shortcuts. While Google Sheets offers standard shortcuts for actions like copy and paste, it also has more powerful key commands that let you insert and delete rows or change how it formats numerals.

Read our comprehensive listof over three dozen Google Sheets keyboard shortcuts so you can spend less tme pushing the mouse around and more time getting work done.

Common Actions

Select column: PC and Mac: Ctrl + Space

screenshot 2016 05 06 15.42.03Select row: PC and Mac: Shift + Space

Select all: PC: Ctrl + A | Mac: Command + A

Undo: PC: Ctrl + Z | Mac: Command + Z

Redo: PC: Ctrl + Y | Mac: Command + Y

Find: PC: Ctrl + F | Mac: Command + F

Find and replace: PC: Ctrl + H | Mac: Command + Shift + H

Fill range: PC: Ctrl + Enter | Mac: Command + Enter

Fill down: PC: Ctrl + D | Mac: Command + D

Fill right: PC: Ctrl + R | Mac: Command + R

Copy: PC: Ctrl + C | Mac: Command + S

Cut: PC: Ctrl + X | Mac: Command + X

Paste: PC: Ctrl + V | Mac: Command + V

Paste values only: PC: Ctrl + Shift + V | Mac: Command + Shift + V

Insert new sheet: PC: Shift + F11 (not available on Mac)

Compact controls: PC: Ctrl + Shift + F | Mac: Control + Shift + K

Insert or Delete rows or Columns

screenshot 2016 05 06 15.42.49

On PC (if not using Chrome, hold Shift in addition to Alt)

Insert row above: Alt + I, then R

Insert row below: Alt + I, then W

Insert column to the left: Alt + I, then C

Insert column to the right: Alt + I, then G

Delete row: Alt + E, then D

Delete column: Alt + E, then E

On Mac (all browsers):

Insert row above: Ctrl + Option + I, then R

Insert row below: Ctrl + Option + I, then W

Insert column to the left: Ctrl + Option + I, then C

Insert column to the right: Ctrl + Option + I, then G

Delete row: Ctrl + Option + E, then D

Delete column: Ctrl + Option + E, then E

MORE: Best Ultrabooks (Thin-and-Light Windows Laptops)

Formatting

Bold: PC: Ctrl + B | Mac: Command + B

Underline: PC: Ctrl + U | Mac: Command + U

Italic: PC: Ctrl + I | Mac: Command + I

screenshot 2016 05 06 15.43.46Strikethrough: PC: Alt + Shift + 5 | Mac: Option + Shift + 5

Center align: PC: Ctrl + Shift + E | Mac: Command + Shift + E

Left align: PC: Ctrl + Shift + L | Mac: Command + Shift + L

Right align: PC: Ctrl + Shift + R | Mac: Command + Shift + R

Apply top border: PC: Alt + Shift + 1 | Mac: Option + Shift + 1

Apply right border: PC: Alt + Shift + 2 | Mac: Option + Shift + 2

Apply bottom border: PC: Alt + Shift + 3 | Mac: Option + Shift + 3

Apply left border: PC: Alt + Shift + 4 | Mac: Option + Shift + 4

Remove borders: PC: Alt + Shift + 6 | Mac: Option + Shift + 6

Apply outer border: PC: Alt + Shift + 7 | Mac: Option + Shift + 7

Insert link: PC: Ctrl + K | Mac: Command + K

Insert time: PC: Ctrl + Shift + ; | Mac: Command + Shift + ;

Insert date: PC: Ctrl + ; | Mac: Command + ;

Format as decimal: PC: Ctrl + Shift + 1 | Mac: Ctrl + Shift + 1

Format as time: PC: Ctrl + Shift + 2 | Mac: Ctrl + Shift + 2

Format as date: PC: Ctrl + Shift + 3 | Mac: Ctrl + Shift + 3

Format as currency: PC: Ctrl + Shift + 4 | Mac: Ctrl + Shift + 4

Format as percentage: PC: Ctrl + Shift + 5 | Mac: Ctrl + Shift + 5

Format as exponent: PC: Ctrl + Shift + 6 | Mac: Ctrl + Shift + 6

Clear formatting: PC: Ctrl + \ | Mac: Command + \

MORE: How to Convert Excel Spreadsheets to Google Sheets

Navigation

Move to beginning of row: PC: Home | Mac: Fn + Left arrow

Move to beginning of sheet: PC: Ctrl + Home | Mac: Command + Fn + Left arrow

Move to end of row: PC: End | Mac: Fn + Right arrow

Move to end of sheet: PC: Ctrl + End | Mac: Command + Fn + Right arrow

Scroll to active cell: PC: Ctrl + Backspace | Mac: Command + Backspace

Move to next sheet: PC: Ctrl + Shift + Page Down | Mac: Command + Shift + Fn + Down arrow

Move to previous sheet: PC: Ctrl + Shift + Page Up | Mac: Command + Shift + Fn + Up arrow

Display list of sheets: PC: Alt + Shift + K | Mac: Option + Shift + K

Open hyperlink: PC: Alt + Enter | Mac: Option + Enter

screenshot 2016 05 06 15.44.38Open Explore: PC: Alt + Shift + X | Mac: Option + Shift + X

Move focus out of spreadsheet: PC: Ctrl + Alt + Shift + M | Mac: Ctrl + Command + Shift + M

Move to quicksum (when a range of cells is selected): PC: Alt + Shift + Q | Mac: Option + Shift + Q

Open revision history: PC: Ctrl + Alt + Shift + G | Mac: Command + Option + Shift + G

Open chat inside the spreadsheet: PC: Shift + Esc | Mac: Shift + Esc + F

Close drawing editor: PC: Shift + Esc | Mac: Command + Esc

Insert/edit note: PC: Shift + F2 | Mac: Shift + F2

screenshot 2016 05 06 15.46.59

Insert/edit comment: PC: Ctrl + Alt + M | Mac: Command + Option + M

Open comment discussion thread: PC: Ctrl + Alt + Shift + A | Mac: Command + Option + Shift + A

Enter current comment: PC: holding Ctrl + Alt, press E then C | Mac: holding Ctrl + ⌘, press E then C

Move to next comment: PC: holding Ctrl + Alt, press N then C | Mac: holding Ctrl + ⌘, press N then C

Move to previous comment: PC: holding Ctrl + Alt, press P then C | Mac: holding Ctrl + ⌘, press P then C

Formulas

Show all formulas: PC: Ctrl + ~ | Mac: Ctrl + ~

Insert array formula: PC: Ctrl + Shift + Enter | Mac: Command + Shift + Enter

Collapse an expanded array formula: PC: Ctrl + E | Mac: Command + E

Shortcuts for when entering a formula:

Show/hide formula help: PC: Shift + F1 | Mac: Shift + Fn + F1

Full/compact formula help: PC: F1 | Mac: Fn + F1

Absolute/relative references: PC: F4 | Mac: Fn + F4

Toggle formula result previews: PC: F9 | Mac: Fn + F9

Author Bio
Henry T. Casey
Henry T. Casey,
After graduating from Bard College a B.A. in Literature, Henry T. Casey worked in publishing and product development at Rizzoli and The Metropolitan Museum of Art, respectively. Henry joined Tom's Guide and LAPTOP having written for The Content Strategist, Tech Radar and Patek Philippe International Magazine. He divides his free time between going to live concerts, listening to too many podcasts, and mastering his cold brew coffee process. Content rules everything around him.
Henry T. Casey, on
Add a comment