Excel 快捷键大全(5)

excel shortcut..

Move from right to left within the selected range. If cells in a single column are selected, move up.

CTRL+PERIOD

Move clockwise to the next corner of the selected range.

CTRL+ALT+RIGHT ARROW

In nonadjacent selections, switch to the next selection to the right.

CTRL+ALT+LEFT ARROW

Switch to the next nonadjacent selection to the left.

Keys used in END mode (note: Ctrl + arrows is usually easier)

END appears in the status bar when End mode is selected.

END key

Turn End mode on or off.

END+arrow key

Move by one block of data within a row or column.

END+HOME

Move to the last cell on the worksheet, in the bottom-most used row of the rightmost used column.

END+ENTER

Move to the rightmost nonblank cell in the current row. This key sequence does not work if you have turne

Keys used with Scroll Lock on

SCROLL LOCK

Turn SCROLL LOCK on or off.

HOME

Move to the cell in the upper-left corner of the window.

END

Move to the cell in the lower-right corner of the window.

UP ARROW or DOWN ARROW

Scroll one row up or down.

LEFT ARROW or RIGHT ARROW

Scroll one column left or right.