Excel 快捷键大全(4)

excel shortcut..

ALT+O H R

Rename the current sheet (Format menu, Sheet submenu, Rename command).

ALT+E M

Move or copy the current sheet (Edit menu, Move or Copy Sheet command).

ALT+E L

Delete the current sheet (Edit menu, Delete Sheet command).

Navigating in a Worksheet

Arrow keys

Move one cell up, down, left, or right.

CTRL+arrow key

Move to the edge of the current data region.

HOME

Move to the beginning of the row.

CTRL+HOME

Move to the beginning of the worksheet.

CTRL+END

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

PAGE DOWN

Move down one screen.

PAGE UP

Move up one screen.

ALT+PAGE DOWN

Move one screen to the right.

ALT+PAGE UP

Move one screen to the left.

F6

Switch to the next pane in a worksheet that has been split (Window menu, Split command).

SHIFT+F6

Switch to the previous pane in a worksheet that has been split.

CTRL+BACKSPACE

Scroll to display the active cell.

F5

Display the Go To dialog box.

F5 Enter

Takes you to the last place you left from

SHIFT+F5

Display the Find dialog box.

SHIFT+F4

Repeat the last Find action (same as Find Next).

TAB

Move between unlocked cells on a protected worksheet.

Move within selected region(s)

ENTER

Move from top to bottom within the selected range.

SHIFT+ENTER

Move from bottom to top within the selected range.

TAB

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

SHIFT+TAB