# The List Of Excel Shortcut keys

**URL:** <https://onehack.st/t/the-list-of-excel-shortcut-keys/91050>\
**Category:** Tutorials & Methods\
**Tags:** tips-tricks\
**Created:** [June 9, 2020, 2:19pm UTC](https://onehack.st/t/the-list-of-excel-shortcut-keys/91050 "2020-06-09T14:19:30Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![shivratna](https://onehack.st/user_avatar/onehack.st/shivratna/32/20116_2.png) [@shivratna](https://onehack.st/u/shivratna)\
**Post date:** [June 9, 2020, 2:19pm UTC](https://onehack.st/t/the-list-of-excel-shortcut-keys/91050/1 "2020-06-09T14:19:31Z")

</div>

Excel Complete List of MS Excel Shortcut Keys  
Ctrl Commands  
Ctrl+A - Select All  
Ctrl+B - Bold  
Ctrl+C - Copy  
Ctrl+D - Fill Down  
Ctrl+F - Find  
Ctrl+G - Goto  
Ctrl+H - Replace  
Ctrl+I - Italic  
Ctrl+K - Insert Hyperlink  
Ctrl+N - New Workbook  
Ctrl+O - Open  
Ctrl+P - Print  
Ctrl+R - Fill Right  
Ctrl+S - Save  
Ctrl+U - Underline  
Ctrl+V - Paste  
Ctrl W - Close  
Ctrl+X - Cut  
Ctrl+Y - Repeat  
Ctrl+Z - Undo  
Function Keys  
F1 - Help  
F2 - Edit  
F3 - Paste Name  
F4 - Repeat last action  
F4 - While typing a formula, switch between absolute/relative refs  
F5 - Goto  
F6 - Next Pane  
F7 - Spell check  
F8 - Extend mode  
F9 - Recalculate all workbooks  
F10 - Activate Menubar  
F11 - New Chart  
F12 - Save As  
Other Combination Keys  
Ctrl+: - Insert Current Time  
Ctrl+; - Insert Current Date  
Ctrl+" - Copy Value from Cell Above  
Ctrl+’ - Copy Formula from Cell Above  
Shift Keys  
Shift - Hold down shift for additional functions in Excel’s menu  
Shift+F1 - What’s This?  
Shift+F2 - Edit cell comment  
Shift+F3 - Paste function into formula  
Shift+F4 - Find Next  
Shift+F5 - Find  
Shift+F6 - Previous Pane  
Shift+F8 - Add to selection  
Shift+F9 - Calculate active worksheet  
Shift+F10 - Display shortcut menu  
Shift+F11 - New worksheet  
Shift+F12 - Savetrl+F3 - Define name  
Ctrl+F4 - Close  
Ctrl+F5 - XL, Restore window size  
Ctrl+F6 - Next workbook window  
Shift+Ctrl+F6 - Previous workbook window  
Ctrl+F7 - Move window  
Ctrl+F8 - Resize window  
Ctrl+F9 - Minimize workbook  
Ctrl+F10 - Maximize or restore window  
Ctrl+F11 - Inset 4.0 Macro sheet  
Ctrl+F1 - File Open  
Alt+F1 - Insert Chart  
Alt+F2 - Save As  
Alt+F4 - Exit  
Alt+F8 - Macro dialog box  
Alt+F11 - Visual Basic Editor  
Ctrl+Shift+F3 - Create name by using names of row and column labels  
Ctrl+Shift+F6 - Previous Window  
Ctrl+Shift+F12 - Print  
Alt+Shift+F1 - New worksheet  
Alt+Shift+F2 - Save  
Alt+= - AutoSum  
Ctrl+` - Toggle Value/Formula display  
Ctrl+Shift+A - Insert argument names into formula  
Alt+Down arrow - Display AutoComplete list  
Alt+’ - Format Style dialog box  
Ctrl+Shift+~ - General format  
Ctrl+Shift+! - Comma format  
Ctrl+Shift+@ - Time format  
Ctrl+Shift+# - Date format  
Ctrl+Shift+$ - Currency format  
Ctrl+Shift+% - Percent format  
Ctrl+Shift+^ - Exponential format  
Ctrl+Shift+& - Place outline border around selected cells  
Ctrl+Shift+\_ - Remove outline border  
Ctrl+Shift+\* - Select current region  
Ctrl++ - Insert  
Ctrl± - Delete  
Ctrl+1 - Format cells dialog box  
Ctrl+2 - Bold  
Ctrl+3 - Italic  
Ctrl+4 - Underline  
Ctrl+5 - Strikethrough  
Ctrl+6 - Show/Hide objects  
Ctrl+7 - Show/Hide Standard toolbar  
Ctrl+8 - Toggle Outline symbols  
Ctrl+9 - Hide rows  
Ctrl+0 - Hide columns  
Ctrl+Shift+( - Unhide rows  
Ctrl+Shift+) - Unhide columns  
Alt or F10 - Activate the menu  
Ctrl+Tab - In toolbar: next toolbar  
Shift+Ctrl+Tab - In toolbar: previous toolbar  
Ctrl+Tab - In a workbook: activate next workbook  
Shift+Ctrl+Tab - In a workbook: activate previous workbook  
Tab - Next tool  
Shift+Tab - Previous tool  
Enter - Do the command  
Shift+Ctrl+F - Font Drop Down List  
Shift+Ctrl+F+F - Font tab of Format Cell Dialog box  
Shift+Ctrl+P - Point size Drop Down List

## Alt MV - Evaluate formula F9 chek output formula Alt TMS Macro security settings (enable) Alt TMR Start Macro recording Alt IND & ctrl+F3 - Name manager F3 - paste formula Alt DL - Data validation