250+ Excel Keyboards Shortcuts List for you
Jan 11, 2020 • edited Jan 12, 2020
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 | 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 | 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:
| 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 |
