All Excel Keyboard Shortcuts at One Place

We have gathered all the Keyboard Shortcuts of Microsoft Excel at one place. To easy access of yours, we have categorized all the shortcuts. Now, you can find the required category and can easily access the list of shortcuts by clicking on the links listed below and increase your productivity.

Note: Here, You can find the shortcut keys for Mac & Windows both the platforms.

Excel Ribbon Tab Shortcuts for Windows

Shortcuts to Make Selections in Excel

Formatting Cell Shortcuts in Excel

Inside the Ribbon Shortcuts in Excel

Frequently Used Keyboard Shortcuts For Mac & Windows in Excel

Excel Cell Navigation Shortcuts For Mac & Windows

Formula Shortcuts For Mac & Windows

Increase Productivity using these Top Excel Keyboard Shortcuts

Excel Ribbon Tab Shortcuts for Windows

To do this action	Press in Windows
Go To Search Field	Alt+Q
Open Data Tab	Alt+A
Open File Page	Alt+F
Open Formula Tab	Alt+M
Open Home Tab	Alt+H
Open Insert Tab	Alt+N
Open Page Layout Tab	Alt+P
Open Review Tab	Alt+R
Open View Tab	Alt+W

For More Shortcuts (Click on the links below):

Shortcuts to Make Selections in Excel

Formatting Cell Shortcuts in Excel

Inside the Ribbon Shortcuts in Excel

Frequently Used Keyboard Shortcuts For Mac & Windows in Excel

Excel Cell Navigation Shortcuts For Mac & Windows

Formula Shortcuts For Mac & Windows

Formula Shortcuts in Excel

To do this action	Press in Windows	Press in Mac
Autosum Selection Of Cells	Alt+=	⌘ +⇧ +T
Calculate Active Worksheet	Shift+F9	Fn+⇧ +F9
Calculate All Worksheets	F9	Fn+F9
Cancel Entry In Formula Bar	Esc	Esc
Complete Entry In Formula Bar	Enter	Return
Copy The Value From The Cell Above	Ctrl+Shift+"	⌃ +⇧ +"
Create Chart In A New Sheet	F11	Fn+F11
Create Embedded Chart	Alt+F1	Fn+⌥ +F1
Define Name For References	Ctrl+F3	Fn+⌃ +F3
Display Function Arguments Dialog	Ctrl+A	⌃ +A
Display Message For Error Checking Button	Alt+Shift+F10
Edit Active Cell	F2	⌃ +U
Expand Or Collapse Formula Bar	Ctrl+Shift+U	⌃ +⇧ +U
Force Calculate All Worksheets	Ctrl+Alt+F9
Input Array Formula	Ctrl+Shift+Enter	⌃ +⇧ +Return
Insert a Function (Opens a Dialog Box)	Shift+F3	Fn+⇧ +F3
Insert Function Arguments	Ctrl+Shift+A	⌃ +⇧ +A
Invoke Flash Fill	Ctrl+E
Move To End Of Text When In The Formula Bar	Ctrl+End	Fn+⌃ +→
Move To Next Record Of Data Form	Enter	Return
Open Macro Dialog	Alt+F8	Fn+⌥ +F8
Open Visual Basic For Applications (VBA) Editor	Alt+F11	Fn+⌥ +F11
Paste a Name	F3
Select Text In Formula Bar To End	Ctrl+Shift+End	Fn+⌃ +⇧ +→
Toggle Absolute or Relative References	F4

For More Shortcuts (Click on the links below):

Excel Ribbon Tab Shortcuts for Windows

Shortcuts to Make Selections in Excel

Formatting Cell Shortcuts in Excel

Inside the Ribbon Shortcuts in Excel

Frequently Used Keyboard Shortcuts For Mac & Windows in Excel

Excel Cell Navigation Shortcuts For Mac & Windows

Shortcuts to Make Selections in Excel

To do this action	Press in Windows	Press in Mac
Complete Cell Entry and Select Above Cell	Shift+Enter	⇧ +Return
Extend Cell Selection Downward	Shift+↓	⇧ +↓
Extend Cell Selection to the Left	Shift+←	⇧ +←
Extend Cell Selection to the Right	Shift+→	⇧ +→
Extend Cell Selection to the Top	Ctrl+Shift+Home	Fn+⌃ +⇧ +←
Extend Cell Selection Upwards	Shift+↑	⇧ +↑
Extend Selection to Last Bottom Cell	Ctrl+Shift+↓	⌃ +⇧ +↓
Extend Selection to Last Left Cell	Ctrl+Shift+←	⌃ +⇧ +←
Extend Selection to Last Right Cell	Ctrl+Shift+→	⌃ +⇧ +→
Extend Selection to Last Top Cell	Ctrl+Shift+↑	⌃ +⇧ +↑
Fill Selected Cell Range with the Current Entry	Ctrl+Enter	⌃ +Return
Redo Last Action	Ctrl+Y	⌘ +Y
Undo Typing	Ctrl+Z	⌘ +Z
Select All Objects when an Object is Selected	Ctrl+Shift+Space
Select Current and Next Worksheet	Ctrl+Shift+Pg Dn
Select Current and Previous Worksheet	Ctrl+Shift+Pg Up
Select Current Array	Ctrl+/	⌃ +/
Select Current Region around the Cell	Ctrl+Shift+*	⇧ +⌃ +Space
Select Differences in Columns	Ctrl+Shift+|	⌃ +⇧ +|
Select Differences in Rows	Ctrl+\	⌃ +\
Select Entire Column	Ctrl+Space	⌃ +Space
Select Entire Row	Shift+Space	⇧ +Space
Select Entire Worksheet	Ctrl+A	⌘ +A
Select First Command on Menu	Home	Fn+←
Select Only Visible Cells	Alt+;	⌘ +⇧ +Z
Start a New Line in a Cell	Alt+Enter	⌃ +⌥ +Return
Toggle Add to Selection Mode	Shift+F8	Fn+⇧ +F8
Toggle Extend Mode	F8	Fn+F8

For More Shortcuts (Click on the links below):

Excel Ribbon Tab Shortcuts for Windows

Formatting Cell Shortcuts in Excel

Inside the Ribbon Shortcuts in Excel

Frequently Used Keyboard Shortcuts For Mac & Windows in Excel

Excel Cell Navigation Shortcuts For Mac & Windows

Formula Shortcuts For Mac & Windows

Formatting Cell Shortcuts in Excel

To do this action	Press in Windows	Press in Mac
Apply Date Format	Ctrl+Shift+#	⌃ +⇧ +#
Apply General Format	Ctrl+Shift+~	⌃ +⇧ +~
Apply Number Format	Ctrl+Shift+!	⌃ +⇧ +!
Apply Percentage Format	Ctrl+Shift+%	⌃ +⇧ +%
Apply Scientific Format	Ctrl+Shift+^	⌃ +⇧ +^
Apply Time Format	Ctrl+Shift+@	⌃ +⇧ +@
Apply or Remove Bold Formatting	Ctrl+B	⌘ +B
Apply or Remove Italic Formatting	Ctrl+I	⌘ +I
Apply or Remove Strikethrough Formatting	Ctrl+5	⌘ +⇧ +X
Apply or Remove Underline	Ctrl+U	⌘ +U
Check Spelling	F7	Fn+F7
Copy Formula from above Cell	Ctrl+'	⌃ +'
Display the Quick Analysis Options	Ctrl+Q
Edit Active Cell	F2	⌃ +U
Enter Current Date	Ctrl+;	⌃ +;
Enter Current Time	Ctrl+Shift+;	⌘ +;
Fill Down from Cell Above	Ctrl+D	⌃ +D
Fill Right from Cell Left	Ctrl+R	⌃ +R
Format Fonts in Format Cells Dialog	Ctrl+Shift+F	⌃ +⇧ +F
Insert a Note	Shift+F2	Fn+⇧ +F2
Insert Table	Ctrl+T	⌃ +T
Insert Threaded Comment	Ctrl+Shift+F2
Open Delete Dialog to Delete Cells	Ctrl+-	⌘ +-
Open Format Cells Dialog	Ctrl+1	⌘ +1
Open Insert Dialog to Insert Cells	Ctrl+Shift++	⌘ +⇧ ++
Open Paste Special Dialog	Ctrl+Alt+V	⌃ +⌘ +V
Open the Insert Hyperlink Dialog	Ctrl+K	⌘ +K
Apply Outline Borders to Cells	Ctrl+Shift+&	⌘ +⌥ +0
Remove Outline Border to Selected Cell(s)	Ctrl+Shift+_	⌘ +⌥ +_
Show or Hide Objects	Ctrl+6	⌃ +6
Show or Hide Outline Symbols	Ctrl+8	⌃ +8
Toggle Formulas On and Off	Ctrl+`	⌃ +`

For More Shortcuts (Click on the links below):

Excel Ribbon Tab Shortcuts for Windows

Shortcuts to Make Selections in Excel

Inside the Ribbon Shortcuts in Excel

Frequently Used Keyboard Shortcuts For Mac & Windows in Excel

Excel Cell Navigation Shortcuts For Mac & Windows

Formula Shortcuts For Mac & Windows

Frequently Used Keyboard Shortcuts For Mac & Windows in Excel

To do this action	Press in Windows	Press in Mac
Add Borders	Ctrl+Shift+&	⌘ +⌥ +0
Add or Remove Filter	Ctrl+Shift+L	⌘ +⇧ +F
Bold	Ctrl+B	⌘ +B
Center Align cell Contents	Alt+H+A+C	⌘ +E
Left Align cell Contents	Alt+H+A+L	⌘ +L
Right Align Cell Contents	Alt+H+A+R	⌘ +R
Choose a Fill Color	Alt+H+H
Cut	Ctrl+X	⌘ +X
Copy	Ctrl+C	⌘ +C
Paste	Ctrl+V	⌘ +V
Delete Column / Row	Ctrl+-	⌘ +-
Insert Column / Row	Ctrl++	⌘ ++
Find	Ctrl+F	⌘ +F
Replace	Ctrl+H	⌃ +H
Find Next Match	Shift+F4	⌘ +G
Find Previous Match	Ctrl+Shift+F4	⌘ +⇧ +G
Hide Selected Column	Ctrl+0	⌃ +0
Unhide Columns	Ctrl+Shift+0	⌃ +⇧ +0
Hide Selected Rows	Ctrl+9	⌃ +9
Unhide Rows	Ctrl+Shift+9	⌃ +⇧ +9
Open Context Menu	Shift+F10	Fn+⇧ +F10
New Workbook	Ctrl+N	⌘ +N
Open Workbook	Ctrl+O	⌘ +O
Close Workbook	Ctrl+W	⌘ +W
Print Preview	Ctrl+F2
Print	Ctrl+P	⌘ +P
Remove Cell Contents	Delete	Fn+Delete
Save Workbook	Ctrl+S	⌘ +S
Undo	Ctrl+Z	⌘ +Z
Zoom In	Ctrl+Alt++	⌥ +⌘ ++
Zoom Out	Ctrl+Alt+-	⌥ +⌘ +-

For More Shortcuts (Click on the links below):

Excel Ribbon Tab Shortcuts for Windows

Shortcuts to Make Selections in Excel

Formatting Cell Shortcuts in Excel

Inside the Ribbon Shortcuts in Excel

Excel Cell Navigation Shortcuts For Mac & Windows

Formula Shortcuts For Mac & Windows

Excel Cell Navigation Shortcuts For Mac & Windows

To do this action	Press in Windows	Press in Mac
Cycle Through Text Boxes / Images	Ctrl+Alt+5
Enter the End Mode	End	Fn+→
Exit Navigation of Text Boxes / Images	Esc	Esc
Extend Selection of Cells to Last Used Cells	Ctrl+Shift+End	Fn+⌃ +⇧ +→
Move One Cell Down	↓	↓
Move One Cell Left	←	←
Move One Cell Right	→	→
Move One Cell Up	↑	↑
Move One Screen Down in a Worksheet	Pg Dn	Fn+↓
Move One Screen Left in Worksheet	Alt+Pg Up	Fn+⌥ +↑
Move One Screen Right in Worksheet	Alt+Pg Dn	Fn+⌥ +↓
Move One Screen Up in a Worksheet	Pg Up	Fn+↑
Move to Beginning of a Worksheet	Ctrl+Home	Fn+⌃ +←
Move to Cell in the Upper Left Corner	Home+Scr Lk	Fn+⌃ +←
Move to Left Edge of Data Region	Ctrl+←	⌃ +←
Move to Right Edge of Data Region	Ctrl+→	⌃ +→
Move to Top Edge of Data Region	Ctrl+↑	⌃ +↑
Move to Bottom Edge of Data Region	Ctrl+↓	⌃ +↓
Move to Last Cell on a Worksheet	Ctrl+End	Fn+⌃ +→
Move to the Next Cell (Right Side)	Tab	Tab
Move to the Previous Cell	Shift+Tab	⇧ +Tab
Move to the Next Sheet in Workbook	Ctrl+Pg Dn	Fn+⌃ +↓
Move to the Previous Sheet in Workbook	Ctrl+Pg Up	Fn+⌃ +↑
Open List of Choices (Drop-down) on a Cell	Alt+↓	⌥ +↓
Show "Go to" Dialog	Ctrl+G	⌃ +G

For More Shortcuts (Click on the links below):

Excel Ribbon Tab Shortcuts for Windows

Shortcuts to Make Selections in Excel

Formatting Cell Shortcuts in Excel

Inside the Ribbon Shortcuts in Excel

Frequently Used Keyboard Shortcuts For Mac & Windows in Excel

Formula Shortcuts For Mac & Windows