Excel 快捷键大全(7)

excel shortcut..

F4 or CTRL+Y

Repeat the last action.

CTRL+SHIFT+F3

Create names from row and column labels.

CTRL+D

Fill down.

CTRL+R

Fill to the right.

CTRL+F3

Define a name.

CTRL+K

Insert a hyperlink.

ENTER (in a cell with a hyperlink)

Activate a hyperlink.

CTRL+; (semicolon)

Enter the date.

CTRL+SHIFT+: (colon)

Enter the time.

ALT+DOWN ARROW

Display a drop-down list of the values in the current column of a list.

CTRL+Z

Undo the last action.

Special Characters (Use the NumLock pad)

ALT+0162

Enters the cent character ¢.

ALT+0163

Enters the pound sterling character £.

ALT+0165

Enters the yen symbol ¥.

ALT+0128

Enters the euro symbol €.

Shortcuts Used in Formulas and Calculations

=

Start a formula.

F2

Move the insertion point into the Formula Bar when editing in a cell is turned off.

BACKSPACE

In the Formula Bar, delete one character to the left.

ENTER

Complete a cell entry from the cell or Formula Bar.

CTRL+SHIFT+ENTER

Enter a formula as an array formula.

ESC

Cancel an entry in the cell or Formula Bar.

SHIFT+F3

In a formula, display the Insert Function dialog box.

CTRL+A

When the insertion point is to the right of a function name in a formula, display the Function Arguments dialog box.CTRL+SHIFT+A