Using the Excel Function Arguments Dialog Box to Edit Functions

By Ken Bluttman

Excel makes entering functions with the Insert Function dialog box easy. But what do you do when you need to change a function that has already been entered in a cell? What about adding arguments or taking some away? There is an easy way to do this! Follow these steps:

  1. Click the cell with the existing function.

  2. Click the Insert Function button.

    The Function Argument dialog box appears. This dialog box is already set to work with your function. In fact, the arguments that have already been entered in the function are displayed in the dialog box as well!

  3. Add, edit, or delete arguments, as follows:

    • To add an argument (if the function allows), use the RefEdit control to pick up the extra values from the worksheet. Alternatively, if you click the bottom argument reference, a new box opens below it, and you can enter a value or range in that box.

    • To edit an argument, simply click it and change it.

    • To delete an argument, click it and press the Backspace key.

  4. Click OK when you’re finished.

    The function is updated with your changes.