Excel Formulas & Functions For Dummies, 6th Edition
Book image
Explore Book Buy On Amazon
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.

About This Article

This article is from the book:

About the book author:

Ken Bluttman is a veteran software and web developer specializing in Excel/VBA and database-centric web applications. His latest projects include large-scale cloud-based applications and mobile app development.

This article can be found in the category: