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.
- Switch OS tabs for Windows, macOS, or Linux shortcuts.
- Use / to jump to search instantly.
- Use Compare mode when moving between machines.
- Print or save the page as a compact PDF cheat sheet.
Navigation
8 shortcuts
Move to beginning of row
Home
WinHomeMacHome/Fn+LeftLinuxHome
Move to beginning of sheet
Ctrl+Home
WinCtrl+HomeMac⌘+Home/⌃⌘+LeftLinuxCtrl+Home
Move to end of sheet
Ctrl+End
WinCtrl+EndMac⌘+EndLinuxCtrl+End
Move to next sheet
Ctrl+PageDown
WinCtrl+PageDownMac⌘+⇧+PgDnLinuxCtrl+PageDown
Move to previous sheet
Ctrl+PageUp
WinCtrl+PageUpMac⌘+⇧+PgUpLinuxCtrl+PageUp
Jump to range
Ctrl+G
WinCtrl+GMac⌘GLinuxCtrl+G
Go to cell A1
Ctrl+Home
WinCtrl+HomeMac⌘+Fn+LeftLinuxCtrl+Home
Scroll to active cell
Ctrl+Backspace
WinCtrl+BackspaceMac⌘+BackspaceLinuxCtrl+Backspace
Editing
13 shortcuts
Edit active cell
F2
WinF2MacF2LinuxF2
Undo
Ctrl+Z
WinCtrl+ZMac⌘ZLinuxCtrl+Z
Redo
Ctrl+Y
WinCtrl+YMac⌘YLinuxCtrl+Y
Cut
Ctrl+X
WinCtrl+XMac⌘XLinuxCtrl+X
Copy
Ctrl+C
WinCtrl+CMac⌘CLinuxCtrl+C
Paste
Ctrl+V
WinCtrl+VMac⌘VLinuxCtrl+V
Paste values only
Ctrl+Shift+V
WinCtrl+Shift+VMac⌘Shift+VLinuxCtrl+Shift+V
Fill down
Ctrl+D
WinCtrl+DMac⌘DLinuxCtrl+D
Fill right
Ctrl+R
WinCtrl+RMac⌘RLinuxCtrl+R
Insert new line in cell
Alt+Enter
WinAlt+EnterMac⌃⌥EnterLinuxAlt+Enter
Delete cell contents
Delete
WinDeleteMacDelete/BackspaceLinuxDelete
Find and replace
Ctrl+H
WinCtrl+HMac⌘HLinuxCtrl+H
Find
Ctrl+F
WinCtrl+FMac⌘FLinuxCtrl+F
Formatting
11 shortcuts
Bold
Ctrl+B
WinCtrl+BMac⌘BLinuxCtrl+B
Italic
Ctrl+I
WinCtrl+IMac⌘ILinuxCtrl+I
Underline
Ctrl+U
WinCtrl+UMac⌘ULinuxCtrl+U
Strikethrough
Alt+Shift+5
WinAlt+Shift+5Mac⌥Shift+5LinuxAlt+Shift+5
Format as currency
Ctrl+Shift+4
WinCtrl+Shift+4Mac⌘Shift+4LinuxCtrl+Shift+4
Format as percentage
Ctrl+Shift+5
WinCtrl+Shift+5Mac⌘Shift+5LinuxCtrl+Shift+5
Format as date
Ctrl+Shift+3
WinCtrl+Shift+3Mac⌘Shift+3LinuxCtrl+Shift+3
Align left
Ctrl+Shift+L
WinCtrl+Shift+LMac⌘Shift+LLinuxCtrl+Shift+L
Align center
Ctrl+Shift+E
WinCtrl+Shift+EMac⌘Shift+ELinuxCtrl+Shift+E
Align right
Ctrl+Shift+R
WinCtrl+Shift+RMac⌘Shift+RLinuxCtrl+Shift+R
Clear formatting
Ctrl+\
WinCtrl+\Mac⌘\LinuxCtrl+\
Rows & Columns
8 shortcuts
Insert row above
Ctrl+Alt+Shift+=
WinCtrl+Alt+Shift+=Mac⌘⌥Shift+=LinuxCtrl+Alt+Shift+=
Insert column left
Ctrl+Alt+=
WinCtrl+Alt+=Mac⌘⌥=LinuxCtrl+Alt+=
Delete row
Ctrl+Alt+-
WinCtrl+Alt+-Mac⌘⌥-LinuxCtrl+Alt+-
Select entire row
Shift+Space
WinShift+SpaceMacShift+SpaceLinuxShift+Space
Select entire column
Ctrl+Space
WinCtrl+SpaceMac⌃SpaceLinuxCtrl+Space
Hide row
Ctrl+Alt+9
WinCtrl+Alt+9Mac⌘⌥9LinuxCtrl+Alt+9
Hide column
Ctrl+Alt+0
WinCtrl+Alt+0Mac⌘⌥0LinuxCtrl+Alt+0
Group rows/columns
Alt+Shift+Right
WinAlt+Shift+RightMac⌥Shift+RightLinuxAlt+Shift+Right
Formulas
6 shortcuts
Show all formulas
Ctrl+`
WinCtrl+`Mac⌃`LinuxCtrl+`
Insert current date
Ctrl+;
WinCtrl+;Mac⌘;LinuxCtrl+;
Insert current time
Ctrl+Shift+;
WinCtrl+Shift+;Mac⌘Shift+;LinuxCtrl+Shift+;
Toggle absolute/relative reference
F4
WinF4MacF4LinuxF4
Sum selected cells
Alt+=
WinAlt+=Mac⌘Shift+TLinuxAlt+=
Insert comment
Ctrl+Alt+M
WinCtrl+Alt+MMac⌘⌥MLinuxCtrl+Alt+M
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.
Advertisement