excel_2010_shortcuts - Excel 2010 Reference Sheet WallStreetPrep.com 617-314-7685 Public boot camps Self-study programs Corporate university training

excel_2010_shortcuts - Excel 2010 Reference Sheet...

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

Public boot camps Self-study programs Corporate & university training Interview prep WallStreetPrep.com 617-314-7685 Excel 2010 Reference Sheet Excel 2010Note: Some third party utilities, macros and add-ins can overwrite native shortcut keys, in which case they will not work. Formatting shortcutsTab navigationBoldCTRL + BMove/ Copy a tabALT + H + O + MItalicCTRL + IChange tab nameALT + H + O + RUnderlineCTRL + UMoving to left/right tabsCTRL + Pg Up/DownFormat BoxCTRL + 1New tabSHIFT + F11Clear cellALT + H + E + AOutline borderSHIFT + CTRL + &Row / column shortcutsRemove borderSHIFT + CTRL + _Select columnCTRL + SpaceInsert a commentSHIFT + F2Select rowShift + SpaceDelete row(s) / column(s)CTRL + 'minus sign'CopyCTRL + CAdd row(s) / column(s)CTRL + SHIFT + 'plus sign'PasteCTRL + VGroup / ungroup rows and columnsSHIFT + ALT + left / right arrow keyPaste SpecialALT H + V + S (ALT + E + S still works)Fit column widthALT + H + O + ICutCTRL + XRepeatCTRL + YData editing shortcutsUndoCTRL + ZSelect AllCTRL + ADelete selected cellsCTRL + Minus signFill DownCTRL + DFill rightCTRL + RWorkbook navigation shortcutsFindCTRL + FToggle Excel workbooksCTRL + TABReplaceCTRL + HSplit ScreenALT + W + S (F6 to jump from pane to pane)Freeze paneALT + W + FEdit cellsF2New workbookCTRL + NStart a formula= (equal sign)PrintCTRL + PInsert AutoSum formulaALT + “+“Open workbookCTRL + O (CTRL + F12)Save workbookCTRL + SCell navigation shortcuts
Background image
Image of page 2

You've reached the end of your free preview.

Want to read both pages?

  • Spring '09
  • karenvancoumer
  • arrow keys, Ctrl, Computer keys, Control-Alt-Delete, Ctrl Alt Shift

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture