Home32 Data and Function Shortcuts 32 Data and Function Shortcuts Below is the list of 32 Data and Function Shortcuts: What to doShortcutsAutoSum the numbersAlt =Create an embedded chartAlt F1Open Macro dialog boxAlt F8Open the Microsoft Visual Basic for ApplicationsAlt F11Define a name to use in referencesAlt M, M, DDisplay the menu for Error CheckingAlt Shift F10Display "Insert" dialog boxCtrl +Select the current data or entire worksheetCtrl ACopy topmost cell into the cells belowCtrl DRecognize patterns and Flash Fill columnsCtrl EDisplay "Go to" dialog boxCtrl GCalculate worksheets in all open workbooksCtrl Alt F9Check formulas and calculate all cellsCtrl Alt Shift F9Move to the last cell in useCtrl EndDisplay "Name Manager" dislog boxCtrl F3Inset a new Macro sheetCtrl F11Copy the value from the cell aboveCtrl Shift "Select the current data rangeCtrl Shift *Insert argument names and parenthesesCtrl Shift AExtend selection to the last used cellCtrl Shift EndCreate name using row and column labelsCtrl Shift F3Expand or collapse the formula barCtrl Shift UDisplay "Insert Function" dialog boxShift F3Calculate the active worksheetShift F9Remove cell contentsDeleteTurn "End" mode on or offEndComplete an entry and select the cell belowEnterCancel an entry in the cell or Formula BarEscCreate a chart in a separate sheetF11Move cursor to the end of contentsF2Display "Paste Name" dialog boxF3Calculate all open workbooks (manual model)F9 Share Tweet Pin it