Google Sheets Keyboard Shortcuts
Work faster in Google Sheets with essential shortcuts for editing, formulas, formatting, filters, and sheet navigation.
Navigation
Go to beginning of row
Home
Go to beginning of sheet
CtrlHome
Jump to edge of data
CtrlArrow
Go to specific range
CtrlG
Switch to next sheet
AltDown
Editing
Edit active cell
F2
Find
CtrlF
Find and replace
CtrlH
Paste values only
CtrlShiftV
Insert current date
Ctrl;
Formatting
Bold
CtrlB
Italic
CtrlI
Underline
CtrlU
Format as currency
CtrlShift4
Clear formatting
Ctrl\
Selection & Sheets
Select row
ShiftSpace
Select column
CtrlSpace
Select all
CtrlA
Insert row above
AltIR
Insert column left
AltIC
Data & Formulas
Show formulas
Ctrl`
Create filter
CtrlShiftL
Fill down
CtrlD
Fill right
CtrlR
Open all shortcuts
Ctrl/
Navigation
Go to beginning of row
fn←
Go to beginning of sheet
Cmdfn←
Jump to edge of data
CmdArrow
Go to specific range
CmdG
Switch to next sheet
OptionDown
Editing
Edit active cell
Return
Find
CmdF
Find and replace
CmdShiftH
Paste values only
CmdShiftV
Insert current date
Cmd;
Formatting
Bold
CmdB
Italic
CmdI
Underline
CmdU
Format as currency
CmdShift4
Clear formatting
Cmd\
Selection & Sheets
Select row
ShiftSpace
Select column
CtrlSpace
Select all
CmdA
Insert row above
OptionIR
Insert column left
OptionIC
Data & Formulas
Show formulas
Cmd`
Create filter
CmdShiftL
Fill down
CmdD
Fill right
CmdR
Open all shortcuts
Cmd/