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