Reference / Shortcuts
Keyboard shortcuts
46 shortcuts for Google Sheets, Mac and Windows side-by-side. ⌘ on Mac is Ctrl on Windows; ⌥ on Mac is Alt on Windows.
Navigation
ActionMacWindows
Show keyboard shortcuts overlay
⌘+/
Ctrl+/
Open formula / function search
⌘+K
Ctrl+K
Open Go-to-cell prompt
F5
F5
Move to the next sheet tab
⌥+⇧+↓
Alt+Shift+PgDn
Move to the previous sheet tab
⌥+⇧+↑
Alt+Shift+PgUp
Jump to the edge of the data regionSubstitute any arrow key to jump that direction.
⌘+→
Ctrl+→
Jump to the beginning of the sheet (A1)
⌘+Fn+←
Ctrl+Home
Jump to the last cell with data
⌘+Fn+→
Ctrl+End
Selection
ActionMacWindows
Select the entire column
⌃+Space
Ctrl+Space
Select the entire row
⇧+Space
Shift+Space
Select all cells in the sheet
⌘+A
Ctrl+A
Extend selection to the edge of the data regionAny arrow key works; this is the table-spanning quick-select.
⌘+⇧+→
Ctrl+Shift+→
Extend selection one cell at a time
⇧+→
Shift+→
Formatting
ActionMacWindows
Bold the selected cells
⌘+B
Ctrl+B
Italicize the selected cells
⌘+I
Ctrl+I
Underline the selected cells
⌘+U
Ctrl+U
Strike through the selected cells
⌘+⇧+X
Alt+Shift+5
Format as currency
⌘+⇧+4
Ctrl+Shift+4
Format as percent
⌘+⇧+5
Ctrl+Shift+5
Format as date
⌘+⇧+3
Ctrl+Shift+3
Format as time
⌘+⇧+2
Ctrl+Shift+2
Add borders to the selected cells
⌘+⇧+7
Ctrl+Shift+7
Clear all formatting
⌘+\
Ctrl+\
Data & editing
ActionMacWindows
Paste values only (strip formatting)
⌘+⇧+V
Ctrl+Shift+V
Fill down: copy the top cell into the rest of the selection
⌘+D
Ctrl+D
Fill right: copy the leftmost cell across the selection
⌘+R
Ctrl+R
Insert a row above the current selectionSelect a full row first to insert above it.
⌘+⌥+=
Ctrl+Alt+=
Insert a column to the left of the current selectionSelect a full column first to insert to its left.
⌘+⌥+=
Ctrl+Alt+=
Delete the selected row
⌘+⌥+-
Ctrl+Alt+-
Delete the selected column
⌘+⌥+-
Ctrl+Alt+-
Undo the last change
⌘+Z
Ctrl+Z
Redo the last undone change
⌘+Y
Ctrl+Y
Find in the current sheet
⌘+F
Ctrl+F
Find and replace across the workbook
⌘+⇧+H
Ctrl+H
Formulas
ActionMacWindows
Toggle absolute / relative reference
F4
F4
Edit the active cell
F2
F2
Wrap the current formula in ARRAYFORMULA
⌘+⇧+↵
Ctrl+Shift+Enter
Show formulas instead of computed values
⌃+`
Ctrl+`
Insert the current date as a static value
⌘+;
Ctrl+;
Insert the current time as a static value
⌘+⇧+;
Ctrl+Shift+;
Insert a comment on the active cell
⌘+⌥+M
Ctrl+Alt+M
Insert a link in the active cellInside a cell, this wraps the selection in a link; in nav mode it opens search.
⌘+K
Ctrl+K
View
ActionMacWindows
Zoom in
⌘++
Ctrl++
Zoom out
⌘+-
Ctrl+-
Show / hide the menus (compact mode)
⌃+⇧+F
Ctrl+Shift+F
Open the Explore panel
⌥+⇧+X
Alt+Shift+X