Excel Extend Selection Shortcuts - MS-Excel Tutorial
Extend Selection
What It DoesKey(s)Toggle Extend mode on or offF8Extend selection in Extend modeArrow KeySelect another rangeShift+F8Extend selection with Extend mode offShift+Arrow KeyExtend selection to last used cellCtrl+Shift+Arrow KeyExtend selection to beginning of rowShift+HomeExtend selection to beginning of worksheetCtrl+Shift+HomeExtend selection to last used cellCtrl+Shift+EndExtend selection down one screenShift+Page DownExtend selection up one screenShift+Page UpExtend selection to last used cell in same column or rowEnd+Shift+Arrow KeyExtend selection to last used cellEnd+Shift+HomeExtend selection to last cell in current rowEnd+Shift+EnterExtend selection to cell in upper-left corner of windowScroll Lock+Shift+HomeExtend selection to cell in lower-right corner of windowScroll Lock+Shift+End
Editing ShortcutsWhat It DoesKey(s)Copy selectionCtrl+CDisplay Office ClipboardCtrl+C, Ctrl+CReplace textCtrl+HPaste selectionCtrl+VCut selectionCtrl+XRepeat last actionCtrl+Y or F4Undo last actionCtrl+ZDelete entries in selected cellsDeleteDelete character to the right of the insertion point when in Edit modeDeleteDelete from the insertion point to the end of the lineCtrl+DeleteDelete character to the left of the insertion point when in Edit modeBackspaceDelete cellsCtrl+- (hyphen)Insert blank cellsCtrl+Shift++ (plus sign)Edit a cell entryF2Edit a cell commentShift+F2Rename current worksheetALT+O H RMove or copy current worksheetALT+E MDelete current worksheetALT+E L
Formatting ShortcutsWhat It DoesKey(s)Copy format of selectionCtrl+Shift+CPaste formatCtrl+Shift+VDisplay Style dialog boxAlt+' (apostrophe)Display Format Cells dialog boxCtrl+1Apply General Number formatCtrl+Shift+~Apply Currency formatCtrl+Shift+$Apply Percentage formatCtrl+Shift+%Apply Exponential Number formatCtrl+Shift+^Apply Date formatCtrl+Shift+#Apply Time formatCtrl+Shift+@Apply the Number format with two decimal places, thousands separator, and minus sign (-) for negative valuesCtrl+Shift+!Add or remove boldfacingCtrl+BAdd or remove italicsCtrl+IAdd or remove underliningCtrl+UAdd or remove strikethroughCtrl+5Hide selected rowsCtrl+9Unhide any hidden rows in selectionCtrl+Shift+( (opening parenthesis)Hide selected columnsCtrl+0 (zero)Unhide any hidden columns in selectionCtrl+Shift+) (closing parenthesis)Apply outline border around selected cellsCtrl+Shift+&Remove outline border from around selected cellsCtrl+Shift+_