Excel General Command Shortcuts - MS-Excel Tutorial
General Command
What It DoesKey(s)Get helpF1Activate menu barF10Find an entryShift+F5Repeat most recent find operationShift+F4Check spellingF7
Workbook File CommandsWhat It DoesKey(s)Create new fileCtrl+NOpen fileCtrl+OPrint fileCtrl+PSave fileCtrl+SSave copy of file under another nameF12
Navigate WorksheetsWhat It DoesKey(s)Move one cell up, down, left, or rightArrow KeysGo to active cellCtrl+BackspaceMove to next unlocked cell on a protected worksheetTabMove down one screenPage DownMove up one screenPage UpMove one screen to the rightAlt+Page DownMove one screen to the leftAlt+Page UpSwitch to next split paneF6Switch to previous split paneShift+F6Find text or formatCtrl+FFlip to next worksheet pageCtrl+Page DownFlip to previous worksheet pageCtrl+Page UpGo to a specific cell or named rangeF5 or Ctrl+GMove to edge of current data regionCtrl+Arrow KeyMove to beginning of rowHomeMove to beginning of worksheetCtrl+HomeMove to last cell on worksheetCtrl+End
Navigate in Selected Range
What It DoesKey(s)Move from top to bottom of rangeEnterMove from bottom to top of rangeShift+EnterMove from left to right of rangeTabMove from right to left of rangeShift+TabMove clockwise to next corner of rangeCtrl+PeriodSwitch to selected range to the rightCtrl+Alt+Right ArrowSwitch to selected range to the leftCtrl+Alt+Left Arrow
Navigate in End Mode
What It DoesKey(s)Toggle End mode on or offEndMove to next data block in row or columnEnd+Arrow KeyMove down and to the right to the last used worksheet cellEnd+HomeMove to rightmost used cell in current rowEnd+Enter
Navigate with Scroll Lock
What It DoesKey(s)Toggle Scroll Lock on or offScroll LockSelect cell in upper-left corner of windowHomeSelect cell in lower-right corner of windowEndScroll one row upUp ArrowScroll one row downDown ArrowScroll one column to leftLeft ArrowScroll one column to rightRight Arrow