Microsoft Excel is one of the best Mathematical applications. Using keyboard shortcuts will help you to use Excel more effectively. Here we shared the huge list of 250+ Excel Keyboard Shortcuts for you.

We really liked that windows gives us multiple ways to perform the task in Excel, let’s say we want to save a file, either we can press the key “Ctrl+S” or “Shift+F11”.

Below are the amazing Shortcuts for Excel category wise, in which you will find the Excel formula shortcuts, Excel copy paste shortcuts, Excel keyboard shortcuts to insert row, Excel keyboard shortcuts to select row, Keyboard shortcuts for VBA and Excel hot keys (add more alt shortcuts to Excel).

Dialog Box Excel Shortcuts

Dialog Box Excel Shortcuts Description
Alt+F8 Macro Dialog box
Alt+‘ To open format style box
Ctrl+1 Format cells dialog box
Shift+Ctrl+F,F Open the font tab in the format cells dialog box
Ctrl+Alt Displays the paste special dialog box
Ctrl+T Displays the create table dialog box
Shift+Ctrl+F Open the format cells dialog box
Esc Cancel and close the dialog box

Entering Data Excel Shortcuts:

Entering Data Excel Shortcuts Description
Ctrl+‘ Fill the above formula in down
Ctrl+Shift+: Insert the current time
Ctrl+: Insert current time
Ctrl+; Insert Current Date
Ctrl+R Fill the Right
Ctrl+Y Redo the last action
Ctrl+Del Deletes the end of the word

File Command Excel Shortcuts:

File Command Excel Shortcuts Description
Shift+F11 To Insert a new worksheet
Shift+F12 To save the file
Ctrl+F12 To open a file
Ctrl+Shift+F12 To give the Print
Alt+Shift+F2 To save the File
Ctrl+P To print the file
Ctrl+S To save the file
Ctrl+W To close the file
F12 To save as the file
Ctrl+F2 To print the file
PGUP To page up
PGDN To page down
Go to up
Go to down
Go to left
Go to right
Tab Indent
Enter Go to a new line

Format Excel Shortcuts:

Format Excel Shortcuts Description
Ctrl+X To cut the value
Ctrl+Shift+~ To convert into general format
Ctrl+Shift+# To convert into date format
Ctrl+Shift+$ To convert into currency format
Ctrl+Shift+% To convert into percent format
Ctrl+Shift+^ To convert into exponential format
Ctrl+Shift+F To open font tab in thr format cells dialog box
Ctrl+Shift+P To open font tab in thr format cells dialog box
Ctrl++ To insert the row
Ctrl+– To delete the row
Ctrl+2 To make the font bold
Ctrl+3 To make the font itlaic
Ctrl+4 To underline the font
Ctrl+6 To show and hide objects the view
Alt+Enter To start a new line in the same cell
Ctrl+B To make the font bold
Ctrl+U To underline the font
Ctrl+V To paste the font
Ctrl+I To make the font italic
Ctrl+F2 To edit the cell comment
Ctrl+Shift+! To comma format
Ctrl+Shift+1 To format number in comma format
Ctrl+Shift+4 To format number in currency format
Ctrl+Shift+3 To format number in date format
Ctrl+Shift+5 To format number in percent format
Ctrl+Shift+6 To format number in scientific format
Ctrl+Shift+2 To format number in time format

Formula Excel Shortcuts:

Formula Excel Shortcuts Description
Shift+F3 To Paste the function into the formulae
Ctrl+Alt+F9 To calculate the worksheet in all open workbook
Alt+Shift+Shift To recheck dependent formulae
Ctrl+Shift+F3 To create the names in the rows and columns
Ctrl+Shift+A To insert the argument into the formulae
Ctrl+Shift+F2 To goto the last position
Ctrl+Shift+F8 To step out
Ctrl+Shift+F9 To clear all breakpoints
Ctrl+Shift+Enter To enter the formula as the Array formulae
Ctrl+Shift+U Toggle/Collapse formulae bar
Alt+= To do sum function
Ctrl+` To display the formulae
Shift+F3 To paste the function into the formulae
F3 To repeat the last section
F9 To paste the name into the formulae
F4 To evaluate the past of the formulae
Ctrl+‘ To copy the formulae from the above cell

General Excel Shortcuts:

General Excel Shortcuts Description
Alt+↓ To display auto complete list
Ctrl+8 To toggle outline symbols
Ctrl+K To add the hyperlink
Ctrl+Z To undo the last section
Shift+F4 To find next
Shift+F5 To find the value
Alt+F1 To insert chart
Shift+F7 To view the object
Shift+F8 To add section
Shift+F9 Quick Watch
Ctrl+F4 To close the window
Ctrl+F10 To show right click menu
Alt+F4 To close the VBA
Alt+F6 To switch between last 2 windows
Alt+F11 To close the VBE
Alt+Spacebar Goto system menu
Alt+Backspace To undo the last section
Ctrl+E To export module
Ctrl+G To display Go to dialog box
Ctrl+H To replace the value
Ctrl+J To list properties
Ctrl+L To show call stacks
Ctrl+Tab Goto cycle windows
Ctrl+F1 To show/hide the ribbons
Ctrl+Shift+I To edit perimeter info
Ctrl+Shift+J To edit list constants
Ctrl+Shift+L To add/remove the filter
Ctrl+Shift+J To edit list constants
Ctrl+Shift+→ To group rows or columns
Ctrl+Shift+← To ungroup rows or columns
Alt To Activate Menu bar
F11 To create a chart
Shift Hold down shift to display more options
F1 To open Excel Help
F5 To open “Go To” dialog box
F7 To open spell checker box
F10 To Activate Menu bar
Navigation Excel Shortcuts Description
Ctrl+F7 To move window
Ctrl+5 To apply/remove strike through format
Shift+F6 To move previous pane
Shift+← Extend selection left side
Shift+→ Extend selection right side
Shift+↑ Extend selection up side
Shift+↓ Extend selection down side
Shift+Tab Outdent
Alt+Tab Move to cycle applications
Ctrl+Home Top of the module
Ctrl+End End of the module
Ctrl+PGUP Go to the top procedure in another sheet
Ctrl+PGDN Go to the down procedure in another sheet
Ctrl+↓ Go to down till the blank cell
Ctrl+↑ Go to up till the blank cell
Ctrl+← Move one word to left
Ctrl+→ Move one word to right
Shift+Enter Enter to move up

Window Excel Shortcuts:

Window Excel Shortcuts Description
To start the menu
⊞+R Run dialog box
⊞+M To minimize all
⊞+F1 To help
⊞+E To open window explorer
⊞+F To find files and folder
⊞+D To minimize all windows and desktop
⊞+Del Cycle through taskbar buttons
⊞+L To logoff windows
⊞+P To start print manager
⊞+C To open control panel
⊞+V To start clipboard
⊞+R To open Keyboard properties dialog box
⊞+I To open mouse propeeties dialog box
⊞+A To start accessbility options
Ctrl+F+F To find computer
Ctrl+F+Tab To quick launch toolbar
Shift+⊞+M Undo minimize all

Workbook Excel Shortcuts:

Workbook Excel Shortcuts Description
Ctrl+F5 Restore Window Size
Ctrl+F6 Next workbook window
Ctrl+F9 To minimize workbook
Ctrl+F11 To open VBE
Ctrl+O To open workbook
Ctrl+N To create new workbook
Ctrl+Shift+F6 Previous Workbook Window
Ctrl+Shift+F1 To open new worksheet
Ctrl+Shift+Tab To activate Previous Workbook