Excel 快捷键大全(8)

excel shortcut..

When the insertion point is to the right of a function name in a formula, insert the argument na

F3

Paste a defined name into a formula.

ALT+= (equal sign)

Insert an AutoSum formula with the SUM function.

CTRL+SHIFT+" (quotation mark)

Copy the value from the cell above the active cell into the cell or the Formula Bar.

CTRL+' (apostrophe)

Copies a formula from the cell above the active cell into the cell or the Formula Bar.

CTRL+` (single left quotation mark)

Alternate between displaying cell values and displaying formulas.

F9

Calculate all worksheets in all open workbooks.

When a portion of a formula is selected, calculate the selected portion. You can then press ENTER or CTRL+SHIFTSHIFT+F9

Calculate the active worksheet.

CTRL+ALT+F9

Calculate all worksheets in all open workbooks, regardless of whether they have changed since the last calculation.CTRL+ALT+SHIFT+F9

Rechecks dependent formulas and then calculates all cells in all open workbooks, including ce

Editing Shortcuts

F4

While editing a formula, scrolls through mixed absolutes &G&71… $G71… G$71…. G71…

F7

Display the Spelling dialog box.

SHIFT+F2

Edit a cell comment (or Create or Read one)

CTRL+Z

Undo the last action.

CTRL+Y

Redo the last action.

ESC

Cancel a cell entry.

CTRL+SHIFT+Z

When the AutoCorrect Smart Tags is displayed, undo or redo the last automatic correction.