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
Reach out to us with any inquiries by emailing david@sheetwhiz.com!
bottom of page