Google Sheets Shortcuts

Google Sheets keyboard shortcuts.

Edit spreadsheets faster in Google Sheets — selection, formatting and data-entry shortcuts.

Essentials
Copy⌘+CCtrl+CCtrl+C
Paste⌘+VCtrl+VCtrl+V
Paste values only⌘+⇧+VCtrl+⇧+VCtrl+⇧+V
Undo⌘+ZCtrl+ZCtrl+Z
Redo⌘+YCtrl+YCtrl+Y
Find & replace⌘+⇧+HCtrl+⇧+HCtrl+⇧+H
Print⌘+PCtrl+PCtrl+P
Selecting & moving
Move to edge of data⌘+ArrowCtrl+ArrowCtrl+Arrow
Select column⌃+SpaceCtrl+SpaceCtrl+Space
Select row⇧+Space⇧+Space⇧+Space
Select all⌘+ACtrl+ACtrl+A
Formatting
Bold⌘+BCtrl+BCtrl+B
Italic⌘+ICtrl+ICtrl+I
Underline⌘+UCtrl+UCtrl+U
Strikethrough⌘+⇧+XAlt+⇧+5Alt+⇧+5
Insert link⌘+KCtrl+KCtrl+K
Center align⌘+⇧+ECtrl+⇧+ECtrl+⇧+E
Cells & data
Edit active cellReturnF2F2
New line in cell⌥+ReturnAlt+EnterAlt+Enter
Insert date⌘+;Ctrl+;Ctrl+;
Insert time⌘+⇧+;Ctrl+⇧+;Ctrl+⇧+;
Fill down⌘+DCtrl+DCtrl+D
Fill right⌘+RCtrl+RCtrl+R
Inside Google Sheets, press ⌘/Ctrl + / to view the full in-app shortcut list.

Spreadsheet speed in the browser

Navigation is where Google Sheets shortcuts shine: ⌘/Ctrl + Arrow jumps to the edge of your data, ⌃/Ctrl + Space selects a column, and ⌘/Ctrl + ; drops in today's date. Fill down with ⌘/Ctrl + D to copy a formula across rows in a flash.

FAQ

How do I insert today's date in Google Sheets?
Press ⌘ + ; on Mac or Ctrl + ; on Windows to insert the current date into the selected cell.
How do I add a new line inside a cell?
Press ⌥ + Return on Mac or Alt + Enter on Windows to add a line break within the same cell.

Related

Excel shortcuts →
Spreadsheet cheatsheet
Word shortcuts →
Formatting & editing in Word
Keyboard shortcuts →
Mac & Windows cheatsheet
JSON ⇄ CSV converter →
Convert JSON and CSV both ways