Home > Tips > Excel Shortcut Keys

Excel Shortcut Keys

February 4th, 2009 Leave a comment Go to comments


Below, you’ll find a fairly comprehensive list of default shortcut keys found on a standard English keyboard in Excel.

F1 Help Ctrl+F9 Minimize Workbook Ctrl+Up Arrow Move to Next Cell
With Data Above
F2 Edit Ctrl+F10 Restore Workbook Ctrl+Down Arrow Move to Next Cell With Data Below
F4 Repeat Action Ctrl+F11 New Macro Sheet Ctrl+Space Bar Select Column
F5 Open Goto Dialog Box Ctrl+F12 Open Ctrl+Tab Next Window
F6 Next Pane Ctrl+A Select All  Ctrl+BackSpace Goto Active Cell
F7 Spell Check Ctrl+B Bold Selection Alt+F1 Insert Chart in Current Sheet
F8 Extend Selection Mode Ctrl+C Copy Selection Alt+F2 Save As
F9 Calculate All Ctrl+D Fill Down Alt+F4 Quit Excel
F10 Activate Menu Ctrl+F Open Find Menu Alt+F6 Switch To VBA
F11 New Chart Ctrl+G Open Goto Dialog Box Alt+F8 Open Macro List
F12 Save As Ctrl+H Open Find/Replace
Menu
Alt+F11 Open VB Editor
= Formula Ctrl+I Italicize Selection Alt+D Open Data Menu
Insert Insert Mode Ctrl+K Insert 
Hyperlink
Alt+E Open Edit Menu
Delete Delete Active Cell’s Contents Ctrl+N New Workbook Alt+F Open File Menu
Home Go to the Beginning
of the Row
Ctrl+O Open Workbook Alt+H Open Help Menu
End Go to the End of theRow Ctrl+P Print Alt+I Open Insert Menu
Page Up Page Up Ctrl+R Fill Right Alt+O Open Format Menu
Page Down Page Down Ctrl+S Save Alt+T Open Tools Menu
Left Arrow Move Left Ctrl+U Underline Selection Alt+W Open Window Menu
Right Arrow Move Right Ctrl+V Paste Ctrl+Shift+F3 Create Names From Selection
Up Arrow Move Up Ctrl+W Close Workbook Ctrl+Shift+F6 Previous Workbook
Down Arrow Move Down Ctrl+X Cut Ctrl+Shift+F12 Print
Space Bar Space Ctrl+Y Redo Ctrl+Shift+A Formula Arguments
Tab Move Right Ctrl+Z Undo Ctrl+Shift+F Fomat Cells Font Tab
Shift+F1 What’s This Help Ctrl+` Toggle Formula View Ctrl+Shift+O Select Comments
Shift+F2 Edit Comment Ctrl+1 Open Format Cell Menu Ctrl+Shift+P Fomat Cells Font Tab
Shift+F3 Insert Function Ctrl+2 Bold Selection Ctrl+Shift+` Format Cells -
General Format
Shift+F4 Find Again (With Find Open) Ctrl+3 Italicize Selection Ctrl+Shift+1 Format Cells – Number Format
Shift+F5 Find Ctrl+4 Underline Selection Ctrl+Shift+2 Format Cells – Time
Format
Shift+F6 Previous Pane Ctrl+5 Strikethrough Selection Ctrl+Shift+3 Format Cells – Date Format
Shift+F8 Add To Selection Ctrl+8 Outline Ctrl+Shift+4 Format Cells -
Currency Format
Shift+F9 Calculate Worksheet Ctrl+9 Hide Selected Rows Ctrl+Shift+5 Format Cells – Percent Format
Shift+F10 Right Click Menu Ctrl+0 Hide Selected Columns Ctrl+Shift+6 Format Cells -
Exponent Format
Shift+F11 New Worksheet Ctrl+- Delete Selection Ctrl+Shift+7 Format Cells – Apply Border
Shift+F12 Save Ctrl+[ Go to Dependents Ctrl+Shift+8 Select Region
Shift+Left Arrow Select Left Ctrl+] All Dependents Ctrl+Shift+9 Unhide Rows
Shift+Right Arrow Select Right Ctrl+; Insert Date Ctrl+Shift+0 Unhide Columns
Shift+Up Arrow Select Up Ctrl+/ Select Array Ctrl+Shift+- Format Cells – Remove Border
Shift+Down Arrow Select Down Ctrl+ Select Differences Ctrl+Shift+= Open Insert Dialog
Box
Shift+Space Bar Select Row Ctrl+Insert Copy Ctrl+Shift+[ Direct Precedents
Shift+Tab Move Left Ctrl+Delete Delete To End Of Line Ctrl+Shift+] All Precedents
Ctrl+F3 Open Name Manager Ctrl+Home Start Of Worksheet Ctrl+Shift+; Insert Time
Ctrl+F4 Close Window Ctrl+End End Of Worksheet Ctrl+Shift+’ Copy Cell Value Above
Ctrl+F5 Restore Window Size Ctrl+Page Up Previous Worksheet Ctrl+Shift+/ Select Array
Ctrl+F6 Next Workbook Ctrl+Page Down Next Worksheet Ctrl+Shift+ Select Unequal Cells
Ctrl+F7 Move Window Ctrl+Left Arrow Move to Next Cell With Data to Left Ctrl+Shift+Space Bar Select All
Ctrl+F8 Resize Window Ctrl+Right Arrow Move to Next Cell
With Data to Right
Ctrl+Shift+Tab Previous Window
Categories: Tips Tags: ,
  1. No comments yet.
  1. No trackbacks yet.