Cheat sheet guide
Google Sheets shortcuts worth learning first
This page collects 46 searchable Google Sheets keyboard shortcuts across 5 categories. Start with the shortcuts for Navigation, Editing, Formatting, Rows & Columns, then print the cheat sheet once the important ones are worth keeping nearby.
- Move to beginning of rowHome
- Edit active cellF2
- BoldCtrlB
- Insert row aboveCtrlAltShift=
- Show all formulasCtrl`
- Move to beginning of sheetCtrlHome
Navigation
8 shortcuts
Move to beginning of row
Home
WinHomeMacHomeFnLeftLinuxHome
Move to beginning of sheet
CtrlHome
WinCtrlHomeMac⌘Home⌃⌘LeftLinuxCtrlHome
Move to end of sheet
CtrlEnd
WinCtrlEndMac⌘EndLinuxCtrlEnd
Move to next sheet
CtrlPageDown
WinCtrlPageDownMac⌘⇧PgDnLinuxCtrlPageDown
Move to previous sheet
CtrlPageUp
WinCtrlPageUpMac⌘⇧PgUpLinuxCtrlPageUp
Jump to range
CtrlG
WinCtrlGMac⌘GLinuxCtrlG
Go to cell A1
CtrlHome
WinCtrlHomeMac⌘FnLeftLinuxCtrlHome
Scroll to active cell
CtrlBackspace
WinCtrlBackspaceMac⌘BackspaceLinuxCtrlBackspace
Editing
13 shortcuts
Edit active cell
F2
WinF2MacF2LinuxF2
Undo
CtrlZ
WinCtrlZMac⌘ZLinuxCtrlZ
Redo
CtrlY
WinCtrlYMac⌘YLinuxCtrlY
Cut
CtrlX
WinCtrlXMac⌘XLinuxCtrlX
Copy
CtrlC
WinCtrlCMac⌘CLinuxCtrlC
Paste
CtrlV
WinCtrlVMac⌘VLinuxCtrlV
Paste values only
CtrlShiftV
WinCtrlShiftVMac⌘ShiftVLinuxCtrlShiftV
Fill down
CtrlD
WinCtrlDMac⌘DLinuxCtrlD
Fill right
CtrlR
WinCtrlRMac⌘RLinuxCtrlR
Insert new line in cell
AltEnter
WinAltEnterMac⌃⌥EnterLinuxAltEnter
Delete cell contents
Delete
WinDeleteMacDeleteBackspaceLinuxDelete
Find and replace
CtrlH
WinCtrlHMac⌘HLinuxCtrlH
Find
CtrlF
WinCtrlFMac⌘FLinuxCtrlF
Formatting
11 shortcuts
Bold
CtrlB
WinCtrlBMac⌘BLinuxCtrlB
Italic
CtrlI
WinCtrlIMac⌘ILinuxCtrlI
Underline
CtrlU
WinCtrlUMac⌘ULinuxCtrlU
Strikethrough
AltShift5
WinAltShift5Mac⌥Shift5LinuxAltShift5
Format as currency
CtrlShift4
WinCtrlShift4Mac⌘Shift4LinuxCtrlShift4
Format as percentage
CtrlShift5
WinCtrlShift5Mac⌘Shift5LinuxCtrlShift5
Format as date
CtrlShift3
WinCtrlShift3Mac⌘Shift3LinuxCtrlShift3
Align left
CtrlShiftL
WinCtrlShiftLMac⌘ShiftLLinuxCtrlShiftL
Align center
CtrlShiftE
WinCtrlShiftEMac⌘ShiftELinuxCtrlShiftE
Align right
CtrlShiftR
WinCtrlShiftRMac⌘ShiftRLinuxCtrlShiftR
Clear formatting
Ctrl\
WinCtrl\Mac⌘\LinuxCtrl\
Rows & Columns
8 shortcuts
Insert row above
CtrlAltShift=
WinCtrlAltShift=Mac⌘⌥Shift=LinuxCtrlAltShift=
Insert column left
CtrlAlt=
WinCtrlAlt=Mac⌘⌥=LinuxCtrlAlt=
Delete row
CtrlAlt-
WinCtrlAlt-Mac⌘⌥-LinuxCtrlAlt-
Select entire row
ShiftSpace
WinShiftSpaceMacShiftSpaceLinuxShiftSpace
Select entire column
CtrlSpace
WinCtrlSpaceMac⌃SpaceLinuxCtrlSpace
Hide row
CtrlAlt9
WinCtrlAlt9Mac⌘⌥9LinuxCtrlAlt9
Hide column
CtrlAlt0
WinCtrlAlt0Mac⌘⌥0LinuxCtrlAlt0
Group rows/columns
AltShiftRight
WinAltShiftRightMac⌥ShiftRightLinuxAltShiftRight
Formulas
6 shortcuts
Show all formulas
Ctrl`
WinCtrl`Mac⌃`LinuxCtrl`
Insert current date
Ctrl;
WinCtrl;Mac⌘;LinuxCtrl;
Insert current time
CtrlShift;
WinCtrlShift;Mac⌘Shift;LinuxCtrlShift;
Toggle absolute/relative reference
F4
WinF4MacF4LinuxF4
Sum selected cells
Alt=
WinAlt=Mac⌘ShiftTLinuxAlt=
Insert comment
CtrlAltM
WinCtrlAltMMac⌘⌥MLinuxCtrlAltM
Frequently asked questions
What is the fastest way to find Google Sheets shortcuts on this page?
Use the search box or press /, then type an action such as move to beginning of row.
Can I print this Google Sheets shortcut cheat sheet?
Yes. Use the Print / PDF button or your browser print command to save a compact cheat sheet.
Does this page include Windows and Mac shortcuts for Google Sheets?
Yes. Use the OS tabs to switch between Windows and macOS shortcuts. For example, Move to beginning of row is Home on Windows and Home / Fn+Left on macOS where available.
