Using The Excel Function Arguments Dialog Box To Edit Functions

Marvel fans assemble for the ultimate holiday giveaway! Enter now for your chance to win. Dummies AI Browse Book & Article Categories

Book & Article Categories

closeTechnologyAcademics & The ArtsHome, Auto, & HobbiesBody, Mind, & SpiritBusiness, Careers, & MoneyCollections

Collections

Explore all collectionscloseBYOB (Be Your Own Boss)Be a Rad DadCareer ShiftingContemplating the CosmosFor Those Seeking Peace of MindFor the Aspiring AficionadoFor the Budding Cannabis EnthusiastFor the College BoundFor the Exam-Season CrammerFor the Game Day PrepperCustom Solutions

• Book & Article Categories
• Collections
• Custom Solutions
• Dummies AI

• Main Menu

• Book & Article Categories

• Technology
• Academics & The Arts
• Home, Auto, & Hobbies
• Body, Mind, & Spirit
• Business, Careers, & Money
• Dummies AI

• Main Menu

• Book & Article Categories

• Technology
• Academics & The Arts
• Home, Auto, & Hobbies
• Body, Mind, & Spirit
• Business, Careers, & Money
• Dummies AI

• Main Menu

• Collections

  Explore all collections

• BYOB (Be Your Own Boss)
• Be a Rad Dad
• Career Shifting
• Contemplating the Cosmos
• For Those Seeking Peace of Mind
• For the Aspiring Aficionado
• For the Budding Cannabis Enthusiast
• For the College Bound
• For the Exam-Season Crammer
• For the Game Day Prepper
• Dummies AI

HomeTechnology ArticlesSoftware ArticlesMicrosoft Products ArticlesExcel ArticlesUsing the Excel Function Arguments Dialog Box to Edit FunctionsByKen Bluttman Updated2022-01-07 21:26:06From the bookMicrosoft 365 Excel Formulas & Functions For Dummies, 7th EditionShare

• 
• 
• 
• 
• 

Download E-BookMicrosoft 365 Excel Formulas & Functions For Dummies, 7th Edition Explore Book Microsoft 365 Excel For Dummies Explore BookBuy NowBuy on AmazonBuy on WileySubscribe on PerlegoDownload E-BookMicrosoft 365 Excel Formulas & Functions For Dummies, 7th EditionExplore Book Microsoft 365 Excel For DummiesExplore BookBuy NowBuy on AmazonBuy on WileySubscribe on PerlegoExcel 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: 

Microsoft 365 Excel Formulas & Functions For Dummies, 7th Edition

About the book author:

Ken Bluttman is a veteran software and web developer specializing in Excel/VBA and database-centric web applications. He has written articles and books on topics like Office/VBA development, XML, SQL Server, and InfoPath. Ken is the author of Excel Charts For Dummies and all previous editions of Excel Formulas & Functions For Dummies.

This article can be found in the category: 

ExcelGet a Subscription