Using keyboard shortcuts
To open the Insert Function dialog box:
Select an empty cell and press Shift+F3.
To open a Function Arguments dialog box:
Select a cell containing a formula and press Shift+F3.
To insert a new Formula into a cell using the Function Arguments dialog box:
1. Select an empty cell, and then type the = sign.
2. Type the formula name and press Ctrl+A.
To insert a formula by typing it while being guided by the formula syntax tooltip:
1. Select an empty cell, and then type the = sign followed by the formula name and a ( sign.
2. Press Ctrl+Shift+A (in Excel version 2003 the syntax appears immediately after step 1 above).
Screenshot // Inserting/Editing Formulas
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.