Editing Functions in Formulas
After you create a formula with one or more functions, you may want to modify the arguments in one of the functions later. Excel provides several ways for you to modify a function. The method you choose depends on personal choice and the complexity of the function.
Use any of the following techniques to modify a function:
- If your formula contains only one function or if the function you want to modify is the last one in the formula, click the
Insert Function button on the formula bar (or in the Formulas tab of the Ribbon), or press
Shift+F3 to display the Insert Function dialog box for the function.
- If your formula contains more than one function, press F2 or double-click the formula cell. Position the cursor within the function that you want to modify and click the Insert Function button, or press Shift+F3.
- The most efficient way to modify simple functions (that is, those with few arguments) is to do so manually. Excel provides a ScreenTip (floating text) for the function to help you identify the names and order of the function's arguments.
