Excel Keyboard Shortcuts
Microsoft Excel keyboard shortcut reference covering 130 bindings for Windows & Mac. Commonly searched bindings include Go to Beginning, Go to End, and Jump to Edge. 130 of 130 shortcuts are verified against official Microsoft Excel documentation, each with a linked source when available. Search by action name, filter by category, look up what a key combination does, print a cheat sheet, or practice with flashcards.
Official Microsoft Excel documentation
Automation
| Action | Description | Windows | Mac | Verified | Source |
|---|
| Macros |
Open Macro dialog |
Alt+F8 |
Option+F8 |
Yes |
Source |
| VBA Editor |
Open Visual Basic Editor |
Alt+F11 |
Option+F11 |
Yes |
Source |
Charts
| Action | Description | Windows | Mac | Verified | Source |
|---|
| Embedded Chart |
Create embedded chart in sheet |
Alt+F1 |
Option+F1 |
Yes |
Source |
Data
| Action | Description | Windows | Mac | Verified | Source |
|---|
| Toggle AutoFilter |
Apply or remove AutoFilter |
Ctrl+Shift+L |
Cmd+Shift+L |
Yes |
Source |
| Quick Analysis |
Show Quick Analysis options |
Ctrl+Q |
Cmd+Q |
Yes |
Source |
| Flash Fill |
Flash Fill pattern recognition |
Ctrl+E |
Cmd+E |
Yes |
Source |
| Refresh Sheet |
Refresh external data on sheet |
Ctrl+F5 |
Cmd+F5 |
Yes |
Source |
| Refresh All |
Refresh all external data |
Ctrl+Alt+F5 |
Cmd+Option+F5 |
Yes |
Source |
| Power Query |
Open Power Query Editor |
Alt+F12 |
Option+F12 |
Yes |
Source |
| Validation Dropdown |
Open data validation list |
Alt+Down |
Option+Down |
Yes |
Source |
Editing
| Action | Description | Windows | Mac | Verified | Source |
|---|
| Edit Cell |
Edit active cell |
F2 |
F2 |
Yes |
Source |
| Fill Down |
Fill down from above |
Ctrl+D |
Cmd+D |
Yes |
Source |
| Fill Right |
Fill right from left |
Ctrl+R |
Cmd+R |
Yes |
Source |
| Current Date |
Insert today's date |
Ctrl+; |
Cmd+; |
Yes |
Source |
| Current Time |
Insert current time |
Ctrl+Shift+; |
Cmd+Shift+; |
Yes |
Source |
| Copy Formula Above |
Copy formula from above |
Ctrl+' |
Cmd+' |
Yes |
Source |
| Fill Selection |
Fill selected cells |
Ctrl+Enter |
Cmd+Enter |
Yes |
Source |
| New Line in Cell |
Line break within cell |
Alt+Enter |
Option+Enter |
Yes |
Source |
| Insert Rows/Cols |
Insert cells |
Ctrl+Shift+Plus |
Cmd+Shift+Plus |
Yes |
Source |
| Delete Rows/Cols |
Delete cells |
Ctrl+Minus |
Cmd+Minus |
Yes |
Source |
| Create Table |
Create Excel table |
Ctrl+T |
Cmd+T |
Yes |
Source |
| Insert Chart |
Insert chart |
Alt+N+C |
Option+N+C |
Yes |
Source |
| Chart New Sheet |
Chart in new sheet |
F11 |
F11 |
Yes |
Source |
| Insert Hyperlink |
Insert hyperlink |
Ctrl+K |
Cmd+K |
Yes |
Source |
| PivotTable |
Create PivotTable |
Alt+N+V |
Option+N+V |
Yes |
Source |
| Undo |
Undo |
Ctrl+Z |
Cmd+Z |
Yes |
Source |
| Redo |
Redo |
Ctrl+Y |
Cmd+Y |
Yes |
Source |
| Insert Row |
Insert row |
Alt+I+R |
Option+I+R |
Yes |
Source |
| Edit Active Cell |
Edit and clear cell |
Delete |
Delete |
Yes |
Source |
| Copy |
Copy |
Ctrl+C |
Cmd+C |
Yes |
Source |
| Paste |
Paste |
Ctrl+V |
Cmd+V |
Yes |
Source |
| Paste Special |
Paste special dialog |
Ctrl+Alt+V |
Cmd+Option+V |
Yes |
Source |
| Cut |
Cut selection to clipboard |
Ctrl+X |
Cmd+X |
Yes |
Source |
| Insert Note |
Insert or edit cell note |
Shift+F2 |
Shift+F2 |
Yes |
Source |
| New Worksheet |
Insert new worksheet |
Shift+F11 |
Shift+F11 |
Yes |
Source |
| Insert Worksheet |
Insert worksheet via ribbon |
Alt+Shift+F1 |
Option+Shift+F1 |
Yes |
Source |
| Copy Value Above |
Copy value from cell above |
Ctrl+Shift+\" |
Cmd+Shift+\" |
Yes |
Source |
File
| Action | Description | Windows | Mac | Verified | Source |
|---|
| New Workbook |
Create new workbook |
Ctrl+N |
Cmd+N |
Yes |
Source |
| Open Workbook |
Open workbook |
Ctrl+O |
Cmd+O |
Yes |
Source |
| Save |
Save workbook |
Ctrl+S |
Cmd+S |
Yes |
Source |
| Save As |
Save as |
F12 |
F12 |
Yes |
Source |
| Print |
Print |
Ctrl+P |
Cmd+P |
Yes |
Source |
| Workbook Statistics |
Open Workbook Statistics dialog |
Ctrl+Shift+G |
Cmd+Shift+G |
Yes |
Source |
| File Menu |
Open Backstage File menu |
Alt+F |
Option+F |
Yes |
Source |
Formatting
| Action | Description | Windows | Mac | Verified | Source |
|---|
| Format Cells |
Open format cells dialog |
Ctrl+1 |
Cmd+1 |
Yes |
Source |
| Bold |
Bold text |
Ctrl+B |
Cmd+B |
Yes |
Source |
| Italic |
Italic text |
Ctrl+I |
Cmd+I |
Yes |
Source |
| Underline |
Underline text |
Ctrl+U |
Cmd+U |
Yes |
Source |
| Strikethrough |
Strikethrough |
Ctrl+5 |
Cmd+5 |
Yes |
Source |
| Currency Format |
Apply currency format |
Ctrl+Shift+$ |
Cmd+Shift+$ |
Yes |
Source |
| Percent Format |
Apply percent format |
Ctrl+Shift+% |
Cmd+Shift+% |
Yes |
Source |
| Scientific Format |
Apply scientific format |
Ctrl+Shift+^ |
Cmd+Shift+^ |
Yes |
Source |
| Date Format |
Apply date format |
Ctrl+Shift+# |
Cmd+Shift+# |
Yes |
Source |
| Time Format |
Apply time format |
Ctrl+Shift+@ |
Cmd+Shift+@ |
Yes |
Source |
| Number Format |
Apply number format |
Ctrl+Shift+! |
Cmd+Shift+! |
Yes |
Source |
| Outline Border |
Add outline border |
Ctrl+Shift+& |
Cmd+Shift+& |
Yes |
Source |
| Remove Border |
Remove border |
Ctrl+Shift+_ |
Cmd+Shift+_ |
Yes |
Source |
| Font Dialog |
Open font dialog |
Ctrl+Shift+P |
Cmd+Shift+P |
Yes |
Source |
| Center Align |
Center align |
Alt+H+A+C |
Option+H+A+C |
Yes |
Source |
| Fill Color |
Cell fill color |
Alt+H+H |
Option+H+H |
Yes |
Source |
| Add Border |
Add border |
Alt+H+B |
Option+H+B |
Yes |
Source |
| General Format |
Apply General number format |
Ctrl+Shift+~ |
Cmd+Shift+~ |
Yes |
Source |
| Hide Row |
Hide selected rows |
Ctrl+9 |
Cmd+9 |
Yes |
Source |
| Hide Column |
Hide selected columns |
Ctrl+0 |
Cmd+0 |
Yes |
Source |
| Unhide Row |
Unhide rows |
Ctrl+Shift+9 |
Cmd+Shift+9 |
Yes |
Source |
| Unhide Column |
Unhide columns |
Ctrl+Shift+0 |
Cmd+Shift+0 |
Yes |
Source |
| Format Fonts |
Open font options in Format Cells |
Ctrl+Shift+F |
Cmd+Shift+F |
Yes |
Source |
| Group Rows/Columns |
Group selected rows or columns |
Alt+Shift+Right |
Option+Shift+Right |
Yes |
Source |
| Ungroup Rows/Columns |
Ungroup rows or columns |
Alt+Shift+Left |
Option+Shift+Left |
Yes |
Source |
Formulas
| Action | Description | Windows | Mac | Verified | Source |
|---|
| Autosum |
Insert SUM formula |
Alt+= |
Option+= |
Yes |
Source |
| Toggle Absolute Ref |
Toggle $ in formula |
F4 |
F4 |
Yes |
Source |
| Array Formula |
Enter array formula |
Ctrl+Shift+Enter |
Cmd+Shift+Enter |
Yes |
Source |
| Show Formulas |
Show/hide formulas |
Ctrl+` |
Cmd+` |
Yes |
Source |
| Calculate |
Recalculate workbook |
F9 |
F9 |
Yes |
Source |
| Calculate Sheet |
Recalculate sheet |
Shift+F9 |
Shift+F9 |
Yes |
Source |
| Name Manager |
Open name manager |
Ctrl+F3 |
Cmd+F3 |
Yes |
Source |
| Create Names |
Create names from selection |
Ctrl+Shift+F3 |
Cmd+Shift+F3 |
Yes |
Source |
| Start Formula |
Begin formula entry |
= |
= |
Yes |
Source |
| Extend Formula Bar |
Expand or collapse formula bar |
Ctrl+Shift+U |
Cmd+Shift+U |
Yes |
Source |
| Insert Function Args |
Insert argument names in formula |
Ctrl+Shift+A |
Cmd+Shift+A |
Yes |
Source |
| Insert Function |
Open Insert Function dialog |
Shift+F3 |
Shift+F3 |
Yes |
Source |
| Go to Precedents |
Jump to precedent cells |
Ctrl+[ |
Cmd+[ |
Yes |
Source |
| Go to Dependents |
Jump to dependent cells |
Ctrl+] |
Cmd+] |
Yes |
Source |
| Force Calculate All |
Recalculate all open workbooks |
Ctrl+Alt+F9 |
Cmd+Option+F9 |
Yes |
Source |
| Insert Function Dialog |
Open Function Arguments dialog |
Ctrl+A |
Cmd+A |
Yes |
Source |
Navigation
| Action | Description | Windows | Mac | Verified | Source |
|---|
| Go to Beginning |
Go to cell A1 |
Ctrl+Home |
Cmd+Home |
Yes |
Source |
| Go to End |
Go to last used cell |
Ctrl+End |
Cmd+End |
Yes |
Source |
| Jump to Edge |
Jump to edge of data region |
Ctrl+Arrow |
Cmd+Arrow |
Yes |
Source |
| Previous Sheet |
Go to previous worksheet |
Ctrl+Page+Up |
Ctrl+Page+Up |
Yes |
Source |
| Next Sheet |
Go to next worksheet |
Ctrl+Page+Down |
Ctrl+Page+Down |
Yes |
Source |
| Go To Dialog |
Open Go To dialog |
Ctrl+G |
Cmd+G |
Yes |
Source |
| Go To |
Open Go To (F5) |
F5 |
F5 |
Yes |
Source |
| Next Pane |
Move to next pane |
F6 |
F6 |
Yes |
Source |
| Select Sheets Forward |
Select current and next sheets |
Ctrl+Shift+PageDown |
Cmd+Shift+PageDown |
Yes |
Source |
| Select Sheets Back |
Select current and previous sheets |
Ctrl+Shift+PageUp |
Cmd+Shift+PageUp |
Yes |
Source |
| Move Up |
Complete entry and move up |
Shift+Enter |
Shift+Enter |
Yes |
Source |
| Tell Me Search |
Search ribbon and help |
Alt+Q |
Option+Q |
Yes |
Source |
| Context Menu |
Open context menu |
Ctrl+Shift+F10 |
Cmd+Shift+F10 |
Yes |
Source |
| End Mode |
Enter End mode for navigation |
End |
End |
Yes |
Source |
| Jump to Corner |
Jump to next corner of selection |
Ctrl+. |
Cmd+. |
Yes |
Source |
| Data Tab |
Go to Data tab |
Alt+A |
Option+A |
Yes |
Source |
| Formulas Tab |
Go to Formulas tab |
Alt+M |
Option+M |
Yes |
Source |
| View Tab |
Go to View tab |
Alt+W |
Option+W |
Yes |
Source |
| Page Layout Tab |
Go to Page Layout tab |
Alt+P |
Option+P |
Yes |
Source |
Review
| Action | Description | Windows | Mac | Verified | Source |
|---|
| Spell Check |
Check spelling in worksheet |
F7 |
F7 |
Yes |
Source |
| Review Tab |
Go to Review tab |
Alt+R |
Option+R |
Yes |
Source |
| Threaded Comment |
Insert or reply to threaded comment |
Ctrl+Shift+F2 |
Cmd+Shift+F2 |
Yes |
Source |
Search
| Action | Description | Windows | Mac | Verified | Source |
|---|
| Find |
Find |
Ctrl+F |
Cmd+F |
Yes |
Source |
| Replace |
Find and replace |
Ctrl+H |
Cmd+H |
Yes |
Source |
| Find Next |
Find next match |
Shift+F4 |
Shift+F4 |
Yes |
Source |
Selection
| Action | Description | Windows | Mac | Verified | Source |
|---|
| Select Column |
Select entire column |
Ctrl+Space |
Cmd+Space |
Yes |
Source |
| Select Row |
Select entire row |
Shift+Space |
Shift+Space |
Yes |
Source |
| Select Region |
Select current region |
Ctrl+Shift+* |
Cmd+Shift+* |
Yes |
Source |
| Select All |
Select all cells |
Ctrl+A |
Cmd+A |
Yes |
Source |
| Extend Selection |
Extend selection to end |
Ctrl+Shift+End |
Cmd+Shift+End |
Yes |
Source |
| Extend to Start |
Extend selection to A1 |
Ctrl+Shift+Home |
Cmd+Shift+Home |
Yes |
Source |
| Select Note Cells |
Select all cells with notes |
Ctrl+Shift+O |
Cmd+Shift+O |
Yes |
Source |
| Select Worksheet |
Select entire worksheet |
Ctrl+Shift+Space |
Cmd+Shift+Space |
Yes |
Source |
| Add to Selection |
Add non-adjacent cells to selection |
Shift+F8 |
Shift+F8 |
Yes |
Source |
| Extend Mode |
Toggle extend selection mode |
F8 |
F8 |
Yes |
Source |
| Extend to Region Edge |
Extend selection to data region edge |
Ctrl+Shift+Arrow |
Cmd+Shift+Arrow |
Yes |
Source |
View
| Action | Description | Windows | Mac | Verified | Source |
|---|
| Hide Objects |
Hide or show objects and placeholders |
Ctrl+6 |
Cmd+6 |
Yes |
Source |
| Outline Symbols |
Show or hide outline symbols |
Ctrl+8 |
Cmd+8 |
Yes |
Source |
| Toggle Ribbon |
Show or hide the ribbon |
Ctrl+F1 |
Cmd+F1 |
Yes |
Source |
| Full Screen |
Toggle full screen mode |
Ctrl+Shift+F1 |
Cmd+Shift+F1 |
Yes |
Source |
Window
| Action | Description | Windows | Mac | Verified | Source |
|---|
| Close |
Close workbook |
Ctrl+W |
Cmd+W |
Yes |
Source |
| Close Window |
Close active workbook window |
Ctrl+F4 |
Cmd+F4 |
Yes |
Source |
| Minimize Window |
Minimize workbook window |
Ctrl+F9 |
Cmd+F9 |
Yes |
Source |
| Maximize Window |
Maximize or restore window |
Ctrl+F10 |
Cmd+F10 |
Yes |
Source |
| Switch Windows |
Switch between Excel windows |
Ctrl+Shift+F6 |
Cmd+Shift+F6 |
Yes |
Source |
← All apps on Shortcut Atlas