your image

Excel General Command Shortcuts - MS-Excel Tutorial

sourcedaddy
Related Topic
:- MS-Excel

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

Comments