• Blog
  • Excel Downloads
    • Audit Tickmark Toolbar
  • Courses
    • Power BI
  • Contact
  • Checkout

Excel Zoom

...because it's more than just a calculator


Excel Shortcut Keys

February 4, 2009 by Mark 5 Comments

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.

Filed Under: Tips Tagged With: Shortcuts, Tips

Looking For More Help?

Contact us with any specific questions or feedback. We love to hear from you!

Recommend a new product and EARN! Contact us here for info

Need to level up your career? See our amazing Excel Courses here

Looking for the Excel Audit Tickmark Toolbar? Click Here, NOW ONLY $97!

Subscribe to our mailing list
  • Facebook
  • Twitter

Search this site…

Power BI Webinar
Power BI Course
Free Excel Dashboard Webinar

Copyright © 2025 · Magazine Pro Theme on Genesis Framework

Login Form

Lost your password?