Enter And Calculate Formula

= (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 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+SHIFT+ENTER (for array formulas) to replace the selected portion with the calculated value.
SHIFT+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 cells not marked as needing to be calculated.