Scroll one row up or down: UP ARROW or DOWN ARROW Move to the cell in the lower-right corner of the window: END Move to the cell in the upper-left corner of the window: HOME Move to the last cell to the right in the current row that is not blank unavailable if you have selected the Transition navigation keys check box on the Transition tab (Tools menu, Options command): END, ENTER Move to the last cell on the worksheet, which is the cell at the intersection of the rightmost used column and the bottom-most used row (in the lower-right corner), or the cell opposite the home cell, which is typically A1: END, HOME Move by one block of data within a row or column: END, arrow key Move between unlocked cells on a protected worksheet: TAB

Repeat the last Find action (same as Find Next): SHIFT+F4 Scroll to display the active cell: CONTROL+BACKSPACE Move to the previous pane in a workbook that has been split: SHIFT+F6

Move to the next pane in a workbook that has been split: F6 Move to the previous workbook or window: CONTROL+SHIFT+F6 or CONTROL+SHIFT+TAB Move to the next workbook or window: CONTROL+F6 or CONTROL+TAB Move to the previous sheet in the workbook: CONTROL+PAGE UP Move to the next sheet in the workbook: CONTROL+PAGE DOWN Move one screen to the right: ALT+PAGE DOWN Move to the last cell on the worksheet, which is the cell at the intersection of the rightmost used column and the bottom-most used row (in the lower-right corner), or the cell opposite the home cell, which is typically A1: CONTROL+END Move to the beginning of the worksheet: CONTROL+HOME Move to the edge of the current data region: CONTROL+ARROW key Move one cell up, down, left, or right: ARROW keys 1 Keys for moving and scrolling in a worksheet or workbookДЎ.1 Keys for moving and scrolling in a worksheet or workbookДЎ.2 Keys for moving in a worksheet with End mode onДЎ.3 Keys for moving in a worksheet with SCROLL LOCK onДў Keys for previewing and printing a documentДЈ Keys for working with worksheets, charts, and macrosД¤.1 Keys for entering data on a worksheetД¤.2 Keys for working in cells or the formula barД¦.2 Keys for inserting, deleting, and copying a selectionД§.1 Keys for selecting cells, columns, or rowsД§.2 Keys for extending the selection with End mode onД§.3 Keys for selecting cells that have special characteristicsДЁ Keys for selecting charts and chart itemsДЎ1 Keys to use with PivotTable and PivotChart reportsДЎ1.1 Keys for the PivotTable and PivotChart WizardДЎ1.2 Keys for page fields in a PivotTable or PivotChart reportДЎ1.3 Keys for laying out a PivotTable or PivotChart reportДЎ1.4 Keys for grouping and ungrouping PivotTable itemsДЎ4 Keys for windows, dialog boxes, and edit boxesДЎ5 Keys for working with the Open and Save As dialog boxesДЎ8 Keys for working with drawing objects, AutoShapes, WordArt, and other objectsДЎ8.1 Insert an AutoShape by using the keyboardДЎ8.2 Insert a text box by using the keyboardДЎ8.3 Insert a WordArt object by using the keyboardДЎ8.4 Select a drawing object by using the keyboardДЎ8.5 Change the size of a drawing object by using the keyboardДЎ8.6 Copy the attributes of a drawing object by using the keyboard

Excel shift cells up hotkey