O'Reilly logo

Microsoft® Office Excel 2003 Inside Out by Mark Dodge, Craig Stinson

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Enter and Calculate Formulas

Press

To

= (equal sign)

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

When the insertion point is to the right of a function name in a formula, insert the argument names and parentheses.

F3

Paste a defined name into a formula.

Alt+= (equal sign)

Insert an AutoSum formula ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required