BIWS-Excel-Shortcuts - Excel 2003 and 2007 2010 Quick Reference The Most Important Keyboard Shortcuts for Investment Banking Private Equity http\/.com

BIWS-Excel-Shortcuts - Excel 2003 and 2007 2010 Quick...

This preview shows page 1 - 2 out of 3 pages.

Excel 2003 and 2007 / 2010 Quick Reference – The Most Important Keyboard Shortcuts for Investment Banking & Private Equity The Fundamentals Ctrl + O Open File Ctrl + N New File Ctrl + P Print Ctrl + S Save File Ctrl + F4 Close File Alt + F4 Close Excel Esc Exit Dialog Ctrl + C Copy Ctrl + X Cut Ctrl + V Paste Ctrl + Z Undo Ctrl + Y Redo Ctrl + A Select All Ctrl + F Find Ctrl + H Replace Alt + Tab Switch Windows Navigation & Data Selection Arrow Keys Move Left, Right, Up, Down Ctrl + Arrows Jump to Boundary Shift + Arrows Select Multiple Cells Shift + Ctrl + Arrows Select to Boundary Shift + F8 Select Multiple Areas Manipulating Cells F2 Edit Cell Del Delete Cell Contents Ctrl + Arrows Skip Word(s) Ctrl + Shift + Arrows Highlight Word(s) Ctrl + F3 Name Cell F5 Jump to Cell Rows & Columns Ctrl + Spacebar Select Column Shift + Spacebar Select Row Alt + I + R Insert Row Alt + I + C Insert Column Alt + E + D Delete Rows/Columns F4 Repeat Last Action Right Mouse Button + E Insert Cut Cells Alt + D + G + G Group Rows / Columns Alt + D + G + U Ungroup Rows / Columns Alt + D + G + S Show Rows / Columns Alt + D + G + H Hide Rows / Columns Workbooks & Worksheets Ctrl + N New Workbook Ctrl + Tab Switch Workbook Shift + F11 New Worksheet Alt + E + L Del Worksheet Ctrl + PgUp Move to Left Worksheet Ctrl + PgDn Move to Right Worksheet Alt + E + M Move / Copy Worksheet Shift + Ctrl +
Image of page 1
Image of page 2

You've reached the end of your free preview.

Want to read all 3 pages?

  • Spring '11
  • Mathamagandhi
  • Ctrl, Alt, Alt key

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture