Inserting/Editing Formulas

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
Inserting/Editing FormulasInserting/Editing Formulas

Leave a Reply

Your email address will not be published. Required fields are marked *

Terms and Conditions of use

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.