Scroll one column left or right: LEFT ARROW or RIGHT ARROW 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
0 kommentar(er)
