Move to the beginning / to the end of a cell entryĬomplete a cell entry and move down in the selectionĬomplete a cell entry and move up in the selectionĭelete the character to the left of the insertion point, or delete the selectionĭelete the character to the right of the insertion point, or delete the selection Move to the last cell with content on a worksheet Move to the beginning of a row in a worksheet

Move one cell up, down, left, or right in a worksheet Insert the value of the above cell into cell currently selectedĮxtend the selection to the last cell with content in row or columnĮxtend the selection down one screen /up one screenĮxtend the selection to the beginning of the rowĮxtend the selection to the beginning of the worksheetĮxtend the selection to the last used cell on the worksheet (lower-right corner) Move between Excel work sheets in the same Excel documentĮxcel Shortcut Keys for Working with Cellsīring up the print dialog box to begin printingĬreate a formula to sum all of the above cells Open the Visual Basic Editor to create MacrosĮxcel Shortcut Keys for Working with Worksheets Save the active file with its current file name, location, and file format

Get help on the selected command or control in the RibbonĮxcel Shortcut Keys for Working with Dialogsĭisplay the Find and Replace dialog box (with Find Tab selected)ĭisplay the Find and Replace dialog box (with Replace Tab selected)ĭisplay the Control menu for Main Excel window and thenarrow left or arrow rightĭisplay the shortcut menu for the selected commandĪctivate the selected command or control in the Ribbon, Open the selected menu or gallery in the Ribbonįinish modifying a value in a control in the Ribbon, and move focus back to the document Press either of these keys again to move back to the document and cancel the access keys. Select the active tab of the Ribbon and activate the access keys. Move Workbook Windows which are not maximizedĮxcel Shortcut Keys for Working with Ribbon Move between Two or more open Excel files Move to a task pane from another pane in the program window (counterclockwise direction)Ĭopy a picture of the screen to the ClipboardĬopy a picture of the selected window to the Clipboard Move to a task pane from another pane in the program window (clockwise direction) Restore the size of the active window after you maximize it Here are the list of Excel Shortcut Keys to perform your tasks with shortcut keys instead of mouse.Įxcel Shortcut Keys for Basic Application Tasks Excel Shortcut keys help you to do your tasks faster and you will find more comfortable while working with shortcut keys, instead of using mouse for doing your tasks.

Insert column excel shortcut