Microsoft Excel Shortcut Keys List


On this page, we will provide you the list of Microsoft Excel shortcut key which helps you to improve the productivity and save time. These shortcut keys work perfectly for Microsoft Excel 2007 to upper version.

These keys are tested on MS Excel 2013 and work perfectly.

Keys Discriptions
F1 Help
F2 Edit
F3 Paste Name
F4 Repeat Last Action
F5 Go To
F6 Next Pane
F7 Spell Check
F8 Extend Mode
F9 Recalculate All Workbooks
F10 Activate Menu Bar
F11 New Chart
F12 Save As
Ctrl + F12 File Open
Alt + F1 Insert Chart
Alt + F2 Save As
Alt + F4 Exit
Alt + F11 Visula Basic Editor
Shift + Ctrl + F6 Previous Workbook Window
Ctrl + F7 Move Window
Ctrl + F8 Resize Window
Ctrl + F9 Minimize Workbook
Ctrl + F10 Maximize Workbook or Restore Window
Ctrl + F11 Inset 4.0 Macro Sheet
Ctrl + Shift + ~ General Format
Ctrl + Shift + ! Comma Format
Ctrl + Shift + @ Time Format
Ctrl + Shift + # Date Format
Ctrl + Shift + $ Currency Format
Ctrl + Shift + % Persent Format
Ctrl + : Insert Current Time
Ctrl + ; Insert Current Date
Ctrl + " Copy Value From Cell Above
Ctrl + ' Copy Formula From Cell Above
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
Shift + F1 What is 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 Save
Ctrl + O Open
Ctrl + P Print
Ctrl + R Full Right
Ctrl + S Save
Ctrl + U Underline
Ctrl + V Paste
Ctrl + W Close
Ctrl + X Cut
Ctrl + Y Repeat
Ctrl + Z Undo
Ctrl + N New Worksheet
Ctrl + Shift + ^ Exponential Format
Ctrl + Shift + & Place Outline Border Around Selected Cells
Ctrl + Shift + _ Remove Outline Border
Ctrl + + Insert
Ctrl + - Delete
Ctrl + F3 Define Name
Ctrl + F4 Close
Ctrl + F5 XL, Restore Window Size
Ctrl + F6 Next Workbook Window
Alt + = Auto Sum
Ctrl + ' Toglle Value/Formula Display
Ctrl + Shift + A Insert Argument Name into Formula
Alt + Down Arrow Dispaly Auto Complete List
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

Similar Posts

About the Author

Websparrow
I like sharing my experiments and ideas with everyone by writing articles on the latest technological trends.