Excel Data Entry Shortcuts - MS-Excel Tutorial
Data Entry
What It DoesKey(s)End cell entry and move down one cellEnterEnd cell entry and move up one cellShift+EnterEnd cell entry and move one cell to rightTabEnd cell entry and move one cell to leftShift+TabCancel an entry you typedEscMove one character or line left, right, up, or down when entering or editing cell entryArrow KeyMove to beginning of entryHomeFill a cell entry into cells belowCtrl+DFill a cell entry into cells to rightCtrl+RFill range with current entryCtrl+EnterPaste a function into a formulaShift+F3Insert AutoSum formulaAlt+= (equal sign)Start new line in cell entryAlt+Enter (when typing or editing entry)Insert page breakAlt+Enter (when cell, row, or column is selected)Insert dateCtrl+; (semicolon)Insert timeCtrl+: (colon)Insert new worksheetShift+F11Select entry from a drop-down list of entries already typed in a row or columnAlt+Down ArrowInsert hyperlink (for Web-based worksheets)Ctrl+K
Formula/Function EntryWhat It DoesKey(s)Start formula entry= (equal sign)Enter a formula as an array formulaCtrl+Shift+EnterDisplay Insert Function dialog box when typing or editing a formulaShift+F3Display Function Arguments dialog box when insertion point is to right of function name in formulaCtrl+AInsert argument names and parentheses when insertion point is to right of function name in formulaCtrl+Shift+APaste range name into formulaF3Insert AutoSum formula with SUM functionAlt+= (equal sign)Copy value from cell above active cell into active cellCtrl+Shift+" (quotation mark)Copy formula from cell above active cell into active cellCtrl+' (apostrophe)Toggle display of cell values and formulasCtrl+` (single left quotation mark)Recalculate all formulas or selected portion of current formulaF9Calculate only the active worksheetShift+F9Recalculate all formulas whether or not they have changed since the last calculationCtrl+Alt+F9Check all dependent formulas and recalculate all formulas, including those not marked for recalculationCtrl+Alt+Shift+F9
Selection KeystrokesWhat It DoesKey(s)Select cellArrow KeysName selected range of cellsCtrl+F3Name range using an entry from a cell in the rangeCtrl+Shift+F3Select entire columnCtrl+SpacebarSelect entire rowShift+SpacebarSelect entire worksheetCtrl+ADeselect all but the active cellShift+BackspaceSelect all objects on worksheet when an object is selectedCtrl+Shift+SpacebarToggle between hiding or displaying objects or displaying placeholders for objectsCtrl+6Select current and next worksheetCtrl+Shift+Page DownSelect current and previous worksheetCtrl+Shift+Page UpDeselect multiple worksheetsCtrl+Page Down