Keyboard Shortcuts for Excel - Shortcuts for Excel Title Keyboard Shortcuts for Excel Author A list ...

  • Published on
    29-May-2018

  • View
    217

  • Download
    5

Transcript

Keys Shortcut DescriptionCtrl+cCtrl+xCtrl+vCopyCutPasteCtrl+zCtrl+yUndoRedoCtrl+bCtrl+iCtrl+1(one)Toggle BoldToggle ItalicOpen Format DialogESC Cancel - Used in many situations where youd expect can-cel to be appropriate, including closing menus, dialog boxes, and message windows.ENTER Accept/Done/Submit - Can usually be used in place of click-ing on Accept, OK, Search, Submit, etc.Ctrl+wAlt+F4Close windowClose applicationShift+ArrowShift+Ctrl+ArrowExtend selection by one character, cell, row, column, ...Extend selection by one word, to next change in empty vs. nonempty cells, rows, columnsCtrl+EndCtrl+Shift+EndCtrl+HomeCtrl+Shift+HomeMove to end of line of text (or data region)Select to end of line of text (or data region)Move to beginning of line of text (or last nonblank row/column)Select to beginning of line of text (or cell A1)Ctrl+sCtrl+Shift+sSaveSave As ...Ctrl+fCtrl+hFind (Search within a range or worksheet)Find & ReplaceShift+SpaceBarCtrl+SpaceBarSelect current rowSelect current columnKeys Shortcut DescriptionCtrl+cCtrl+xCtrl+vCopyCutPasteCtrl+zCtrl+yUndoRedoCtrl+bCtrl+iCtrl+1(one)Toggle BoldToggle ItalicOpen Format DialogESC Cancel - Used in many situations where youd expect can-cel to be appropriate, including closing menus, dialog boxes, and message windows.ENTER Accept/Done/Submit - Can usually be used in place of click-ing on Accept, OK, Search, Submit, etc.Ctrl+wAlt+F4Close windowClose applicationShift+ArrowShift+Ctrl+ArrowExtend selection by one character, cell, row, column, ...Extend selection by one word, to next change in empty vs. nonempty cells, rows, columnsCtrl+EndCtrl+Shift+EndCtrl+HomeCtrl+Shift+HomeMove to end of line of text (or data region)Select to end of line of text (or data region)Move to beginning of line of text (or last nonblank row/column)Select to beginning of line of text (or cell A1)Ctrl+sCtrl+Shift+sSaveSave As ...Ctrl+fCtrl+hFind (Search within a range or worksheet)Find & ReplaceShift+SpaceBarCtrl+SpaceBarSelect current rowSelect current columnKeys Shortcut DescriptionCtrl+a Select allF2Shift+F2Edit active cellEdit the active cells commentEnd ArrowShift+(End Arrow)Move to end of data regionSelect to end of data regionCtrl+; Enter current date (Ctrl+Shift+: enter the current time)Ctrl+PageUpCtrl+PageDownMove to next worksheetMove to previous worksheetAlso, move to next and previous tabs (such as in multi-tab dialog boxes)Ctrl+dCtrl+rFill (Copy) Down - If a single cell is selected, copies the cell immediately above it. If a range is selected, copies the up-permost cell into the lower cells. Ctrl+r does the same thing, but to the right.Ctrl+Shift+ ~Ctrl+Shift+ %Ctrl+Shift+ $Ctrl+Shift+ ^Ctrl+Shift+ #Ctrl+Shift+ @Ctrl+Shift+ &Ctrl+Shift+ _Apply the General format to the selected cellsApply the Percentage formatApply the Currency formatApply the Exponential number formatApply the Date formatApply the Time formatApply the Outline borderRemove the Outline borderCtrl+Shift+Enter Enter an array formulaShift+F3 In a formula, display the Insert Function dialog box (for help on syntax)Ctrl+Shift+F Choose a font name (Then type the first few letters of the font)Ctrl+Shift+P Choose a font size (Think of font size as n Points)Keys Shortcut DescriptionCtrl+a Select allF2Shift+F2Edit active cellEdit the active cells commentEnd ArrowShift+(End Arrow)Move to end of data regionSelect to end of data regionCtrl+; Enter current date (Ctrl+Shift+: enter the current time)Ctrl+PageUpCtrl+PageDownMove to next worksheetMove to previous worksheetAlso, move to next and previous tabs (such as in multi-tab dialog boxes)Ctrl+dCtrl+rFill (Copy) Down - If a single cell is selected, copies the cell immediately above it. If a range is selected, copies the up-permost cell into the lower cells. Ctrl+r does the same thing, but to the right.Ctrl+Shift+ ~Ctrl+Shift+ %Ctrl+Shift+ $Ctrl+Shift+ ^Ctrl+Shift+ #Ctrl+Shift+ @Ctrl+Shift+ &Ctrl+Shift+ _Apply the General format to the selected cellsApply the Percentage formatApply the Currency formatApply the Exponential number formatApply the Date formatApply the Time formatApply the Outline borderRemove the Outline borderCtrl+Shift+Enter Enter an array formulaShift+F3 In a formula, display the Insert Function dialog box (for help on syntax)Ctrl+Shift+F Choose a font name (Then type the first few letters of the font)Ctrl+Shift+P Choose a font size (Think of font size as n Points)2012 Vertex42 LLC. All rights reserved.2012 Vertex42 LLC. All rights reserved.Keyboard Shortcuts for ExcelKeyboard Shortcuts for Excel https://www.vertex42.com/ExcelTips/excel-keyboard-shortcuts.html https://www.vertex42.com/ExcelTips/excel-keyboard-shortcuts.htmlhttps://www.vertex42.com/ExcelTips/excel-keyboard-shortcuts.htmlhttps://www.vertex42.com/ExcelTips/excel-keyboard-shortcuts.html