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 ... |
Get Microsoft® Office Excel 2003 Inside Out now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.