top of page

Google Sheets Shortcuts Complete List

Why  Use Keyboards Shortcuts?

Whether you're a seasoned professional or a casual user, mastering keyboard shortcuts can transform your digital experience from mundane to magnificent. Why waste time navigating through endless menus and submenus when you can accomplish tasks with a simple keystroke?

Learn how to enable compatible keyboard shortcuts
here.

Command
PC
Mac
Compatible Keyboard
Speak Comment
Ctrl+Alt+a Ctrl+Alt+c
⌘+Option+a ⌘+Option+c
Alt+a,c,c
Speak Formatting
Alt+a,s,f
Speak Row
Ctrl+Alt+Shift+r
⌘+Option+Shift+r
Alt+a,s,r
Spell Check
F7 Alt+r,s Alt+t,s,s
Split Text To Columns
Alt+a,e Alt+d,e
Summarize Chart Content
Ctrl+Alt+Shift+v
⌘+Option+Shift+v
Toggle Screen Reader Support
Ctrl+Alt+z
⌘+Option+z
Tools Menu
in Google Chrome: Alt+t other browsers: Alt+Shift+t
Ctrl+Option+t
Trim Whitespace
Alt+d,i
Undo An Action
Ctrl+z
⌘+z
Alt+2 Alt+e,u
Unfreeze Columns
Alt+v,r,c
Unfreeze Rows
Alt+v,r,r
Ungroup Columns/Rows
Alt+Shift+ArrowLeft
Option+Shift+ArrowLeft
Unhide Columns
Ctrl+Shift+0
⌘+Shift+0
Alt+h,o,u,l Alt+o,c,u
Unhide Rows
Ctrl+Shift+9
⌘+Shift+9
Alt+h,o,u,o Alt+o,r,u
Unmerge Cells
Alt+h,m,u Alt+o,m,u
View Menu
Alt+Shift+v Alt+v
Ctrl+Option+v
Wrap Text
Alt+h,w Alt+o,w,w
Number Format: Percent
Ctrl+Shift+5
⌘+Shift+5
Alt+h,p Alt+o,n,p
Number Format: Plain Text
Alt+o,n,x
Number Format: Scientific
Ctrl+Shift+6
⌘+Shift+6
Alt+o,n,s
Number Format: Time
Ctrl+Shift+2
⌘+Shift+2
Alt+o,n,t
Open A File
Ctrl+o
⌘+o
Alt+f,o
Open A New Spreadsheet
Alt+f,n Alt+w,n
Open Comment History
Ctrl+Alt+Shift+a
⌘+Option+Shift+a
Alt+a,c,o Alt+r,a Alt+v,c
Open Explore
Alt+Shift+x
Option+Shift+x
Open Filter Dropdown Menu
Ctrl+Alt+r
⌘+Option+r
Open Spreadsheet Settings
Alt+f,t Alt+f,g
Open The Delete Row/Column Menu
Ctrl+Alt+- in Google Chrome: Alt+e,e other browsers: Alt+Shift+e,e (with columns selected)
⌘+Option+- ⌘+Option+e,e (with columns selected)
Ctrl+- Alt+h,d,d
Open The Insert Row/Column Menu
Ctrl+Alt+Shift+= Ctrl+Alt+=
⌘+Option+Shift+= ⌘+Option+=
Ctrl+Shift+= Ctrl+= Alt+h,i,i Alt+i,e
Paste
Ctrl+v Shift+Insert
⌘+v
Alt+h,v,p Alt+e,p
Paste All Except Borders
Alt+h,v,b Alt+e,s,b
Paste Column Widths Only
Alt+h,v,w
Paste Format Only
Ctrl+Alt+v
⌘+Option+v
Alt+h,v,r
Paste Formula Only
Alt+h,v,f
Paste Transposed
Alt+h,v,t Alt+e,s,e
Paste Values Only
Ctrl+Shift+v
⌘+Shift+v
Alt+h,v,v
Print
Ctrl+p
⌘+p
Ctrl+F2 Alt+f,p
Protect A Sheet
Alt+h,o,p Alt+r,p Alt+t,p Alt+t,t
Redo An Action
Ctrl+y Ctrl+Shift+z F4
⌘+y ⌘+Shift+z F4
Alt+3 Alt+e,r
Remove Borders
Alt+Shift+6
Option+Shift+6
Ctrl+Shift+- Alt+h,b,n
Remove Duplicate Rows
Alt+a,m Alt+d,m
Resize A Column
Alt+h,o,i Alt+o,c,a
Resize A Row
Alt+h,o,a Alt+o,r,a
Rotate Text In The Cell (Rotate Down)
Alt+h,f,q,d Alt+o,r,d
Rotate Text In The Cell (Rotate Up)
Alt+h,f,q,u
Rotate Text In The Cell (Stack Vertically)
Alt+h,f,q,v Alt+o,r,v
Rotate Text In The Cell (Tilt Down)
Alt+h,f,q,l Alt+o,r,w
Rotate Text In The Cell (Tilt Up)
Alt+h,f,q,o Alt+o,r,p
Scroll To The Active Cell
Ctrl+Backspace
⌘+Backspace
See All Keyboard Shortcuts
Ctrl+/
⌘+/
See Version History
Ctrl+Alt+Shift+h
⌘+Option+Shift+h
Select A Column
Ctrl+Space
⌘+Space
Select A Row
Shift+Space
Shift+Space
Select All
Ctrl+a Ctrl+Shift+Space
⌘+a ⌘+Shift+Space
Ctrl+Shift+8
Set Absolute/Relative References In Formula
F4
F4
Share The Spreadsheet
Alt+f,h Alt+t,b
Show All Formulas
Ctrl+`
Ctrl+~
Alt+m,h Alt+v,a
Show Compact Controls
Ctrl+Shift+f
⌘+Shift+f
Show Formula Bar
Ctrl+Shift+u
⌘+Shift+u
Alt+w,v,f Alt+v,f
Show Full Screen
Ctrl+F1 Alt+v,u
Show Gridlines
Alt+w,v,g Alt+v,g
Show Sheet List
Shift+Alt+k
Shift+Option+k
Sort Range
Alt+h,s,u Alt+d,s
Sort Range By The Selected Column (Bottom To Top)
Alt+h,s,o Alt+d,t
Sort Range By The Selected Column (Top To Bottom)
Alt+h,s,s Alt+d,r
Speak Anchor
Ctrl+Alt+a
⌘+Option+a
Alt+a,c,a
Speak Column
Ctrl+Alt+Shift+c
⌘+Option+Shift+c
Alt+a,s,l
Freeze Two First Columns
Alt+v,r,m
Freeze Two First Rows
Alt+v,r,w
Freeze Up To The Current Columns
Alt+v,r,p
Go To A Specific Range
F5 Alt+e,g
Go To The Help Center
Shift+F1
Shift+F1
F1
Group Columns/Rows
Alt+Shift+ArrowRight
Option+Shift+Right Arrow
Help Menu
in Google Chrome: Alt+h other browsers: Alt+Shift+h
Ctrl+Option+h
Hide Selected Columns
Ctrl+Alt+0
⌘+Option+0
Ctrl+0 Alt+h,o,u,c Alt+o,c,h
Hide Selected Rows
Ctrl+Alt+9
⌘+Option+9
Ctrl+9 Alt+h,o,u,r Alt+o,r,h
Hide The Current Sheet
Alt+h,o,u,s Alt+o,h
Increase Decimal Places
Alt+h,0
Insert A Cell And Shift Down
Alt+i,d
Insert A Chart
Alt+F1 Alt+n,k Alt+i,h
Insert A Checkbox
Alt+i,x
Insert A Comment
Ctrl+Alt+m
⌘+Option+m
Alt+r,c Alt+i,m
Insert A Link
Ctrl+k
⌘+k
Alt+n,i Alt+i,i Alt+i,k
Insert A New Sheet
Shift+F11
Shift+F11
Alt+Shift+F1 Alt+h,i,s Alt+i,w Alt+i,s
Insert Current Date
Ctrl+;
⌘+;
Insert Current Date And Time
Ctrl+Alt+Shift+;
⌘+Option+Shift+;
Insert Current Time
Ctrl+Shift+;
⌘+Shift+;
Insert Menu
in Google Chrome: Alt+i other browsers: Alt+Shift+i
Ctrl+Option+i
Insert One Column Left
Alt+h,i,c Alt+i,c
Insert One Column Right
Alt+i,o
Insert One Row Above
Alt+h,i,r Alt+i,r
Insert One Row Below
Alt+i,b
Insert The Average Function
Alt+h,u,a Alt+m,u,a Alt+i,u,a
Insert The Count Function
Alt+h,u,c Alt+m,u,c Alt+i,u,c
Insert The Max Function
Alt+h,u,m Alt+m,u,m Alt+i,u,m
Insert The Min Function
Alt+h,u,i Alt+m,u,i Alt+i,u,i
Insert The Sum Function
Alt+h,u,s Alt+m,u,s Alt+i,u,s
Insert/Edit A Note
Shift+F2
Shift+F2
Merge All Cells
Alt+h,m,m Alt+o,m,a
Merge Cells Horizontally
Alt+h,m,a Alt+o,m,h
Move To The Beginning Of The Row
Home
Home
Move To The Beginning Of The Sheet
Ctrl+Home
⌘+Home
Move To The End Of The Row
End
End
Move To The End Of The Sheet
Ctrl+End
⌘+End
Move To The Next Comment
Ctrl+Alt+n Ctrl+Alt+c
⌘+Option+n ⌘+Option+c
Alt+a,c,n
Move To The Next Sheet
Ctrl+Shift+PageDown Alt+ArrowDown
⌘+Shift+PageDown Option+ArrowDown
Move To The Previous Comment
Alt+a,c,p
Move To The Previous Sheet
Ctrl+Shift+PageUp Alt+ArrowUp
⌘+Shift+PageUp Option+ArrowUp
Number Format: Accounting
Alt+h,a,n Alt+o,n,a
Number Format: Automatic
Ctrl+Shift+` Alt+o,n,m
Number Format: Currency
Ctrl+Shift+4
⌘+Shift+4
Alt+o,n,c
Number Format: Currency (Rounded)
Alt+o,n,r
Number Format: Date
Ctrl+Shift+3
⌘+Shift+3
Alt+o,n,d
Number Format: Date Time
Alt+o,n,i
Number Format: Duration
Alt+o,n,u
Number Format: Financial
Alt+o,n,f
Number Format: Number
Ctrl+Shift+1
⌘+Shift+1
Alt+h,k Alt+o,n,n
Access The Sheet Menu
Alt+Shift+s
Option+Shift+s
Add-Ons Menu
in Google Chrome: Alt+n other browsers: Alt+Shift+n
Ctrl+Option+n
Align Bottom
Alt+h,a,b Alt+o,a,b
Align Center
Ctrl+Shift+e
⌘+Shift+e
Alt+h,a,c Alt+o,a,c
Align Left
Ctrl+Shift+l
⌘+Shift+l
Alt+h,a,l Alt+o,a,l
Align Middle
Alt+h,a,m Alt+o,a,m
Align Right
Ctrl+Shift+r
⌘+Shift+r
Alt+h,a,r Alt+o,a,r
Align Top
Alt+h,a,t Alt+o,a,t
Apply All Borders
Alt+h,b,a
Apply Bold
Ctrl+b
⌘+b
Ctrl+2 Alt+h,1 Alt+o,b
Apply Bottom Border
Alt+Shift+3
Option+Shift+3
Alt+h,b,o
Apply Conditional Formatting
Alt+h,l Alt+o,d Alt+o,f
Apply Data Validation
Alt+a,v Alt+d,l Alt+d,v
Apply Italic
Ctrl+i
⌘+i
Ctrl+3 Alt+h,2 Alt+o,i
Apply Left Border
Alt+Shift+4
Option+Shift+4
Alt+h,b,l
Apply Outer Border
Alt+Shift+7 Ctrl+Shift+7
Option+Shift+7 ⌘+Shift+7
Alt+h,b,s
Apply Right Border
Alt+Shift+2
Option+Shift+2
Alt+h,b,r
Apply Strikethrough
Alt+Shift+5
Option+Shift+5
Ctrl+5 Alt+o,k
Apply Top Border
Alt+Shift+1
Option+Shift+1
Alt+h,b,p
Apply Underline
Ctrl+u
⌘+u
Ctrl+4 Alt+h,3,u Alt+o,u
Bold
Ctrl+b
⌘+b
Ctrl+b
Cleanup Suggestions
Alt+a,y Alt+d,y
Clear Formatting
Ctrl+\
⌘+\
Alt+h,e,f Alt+e,a,f
Clear Notes
Alt+h,e,m Alt+e,a,m
Collapse Grouped Columns/Rows
Alt+Shift+ArrowUp
Option+Shift+Up Arrow
Context Menu
Ctrl+Shift+\ Ctrl+Shift+x
⌘+Shift+\
Shift+F10
Copy
Ctrl+c Ctrl+Insert
⌘+c
Alt+h,c,c Alt+e,c
Copy Down (Fill Down)
Ctrl+d
⌘+d
Alt+h,f,i,d Alt+e,i,d
Copy To The Range (Fill Range)
Ctrl+Enter
⌘+Enter
Copy To The Right (Fill Right)
Ctrl+r
⌘+r
Alt+h,f,i,r Alt+e,i,r
Create A Filter
Alt+h,s,f Alt+d,f
Create A Pivot Table
Alt+n,v Alt+d,p
Cut
Ctrl+x
⌘+x
Alt+h,x Alt+e,t
Data Menu
in Google Chrome: Alt+d other browsers: Alt+Shift+d
Ctrl+Option+d
Decrease Decimal Places
Alt+h,9
Define A Named Range
Alt+m,n Alt+i,n Alt+d,n
Delete The Current Column
Alt+h,d,c
Delete The Current Row
Alt+h,d,r Alt+e,d
Delete The Current Sheet
Alt+h,d,s Alt+e,l
Delete Values In The Cell
Alt+h,e,c Alt+e,a,c Alt+e,v
Display list of sheets
Alt+Shift+k
Option+Shift+k
Edit Menu
in Google Chrome: Alt+e other browsers: Alt+Shift+e
Ctrl+Option+e
Edit The Selected Cell
F2
F2
Expand Grouped Columns/Rows
Alt+Shift+ArrowDown
Option+Shift+ArrowDown
File Menu
in Google Chrome: Alt+f other browsers: Alt+Shift+f
Ctrl+Option+f
Find And Replace In The Sheet
Ctrl+h
⌘+Shift+h
Alt+h,f,d,r Alt+e,e Alt+e,f
Find In The Sheet
Ctrl+f
⌘+f
Format Menu
in Google Chrome: Alt+o other browsers: Alt+Shift+o
Ctrl+Option+o
Ctrl+1
Freeze The First Column
Alt+w,f,c Alt+v,r,l
Freeze The First Row
Alt+w,f,r Alt+v,r,o

Not Able to Find What You Are Looking For?

Try SheetWhiz, Free.

  • Key Native Excel Shortcuts (Mac-compatible!)

  • Trace Precedents

  • Trace Dependents

  • Format Cycling

Trace Precedents on Google Sheets like Macabacus and Arixcel on Excel

Reach out to us with any inquiries by emailing david@sheetwhiz.com!

bottom of page