Excel.Tips.Net ExcelTips (Menu Interface)

Getting Help when Entering Functions

Please Note: This article is written for users of the following Microsoft Excel versions: 97, 2000, 2002, and 2003. If you are using a later version (Excel 2007 or later), this tip may not work for you. For a version of this tip written specifically for later versions of Excel, click here: Getting Help when Entering Functions.

One of the tools that Excel provides for adding functions to a formula is Insert | Function, which starts a wizard-like interface that leads you through constructing the function properly. If you are like most frequent users of Excel, this level of help is a little much; all you need is a memory-jog as to what parameters should be used with the function.

One obscure shortcut provided in Excel actually provides just the amount of help you may want. For example, let's say you know you want to use the SUBSTITUTE function, but you cannot remember all the parameters that are used with it. Type an equal sign, followed by SUBSTITUTE and a left parenthesis, like this:


Now, press Shift+Ctrl+A. Excel magically adds all the parameters for the formula, like this:


What's more, the first parameter (text) is highlighted, and you can simply start typing what you want used for that parameter. Replace or delete the other parameters, as desired, and you have your correctly constructed function ready to go.

ExcelTips is your source for cost-effective Microsoft Excel training. This tip (3059) applies to Microsoft Excel 97, 2000, 2002, and 2003. You can find a version of this tip for the ribbon interface of Excel (Excel 2007 and later) here: Getting Help when Entering Functions.

Related Tips:

Comprehensive VBA Guide Visual Basic for Applications (VBA) is the language used for writing macros in all Office programs. This complete guide shows both professionals and novices how to master VBA in order to customize the entire Office suite for their needs. Check out Mastering VBA for Office 2010 today!


Leave your own comment:

  Notify me about new comments ONLY FOR THIS TIP
Notify me about new comments ANYWHERE ON THIS SITE
Hide my email address
*What is 5+3 (To prevent automated submissions and spam.)
           Commenting Terms

Comments for this tip:

Susan    17 Mar 2012, 12:40
Perfect! I didn't know that! :-)

Our Company

Sharon Parq Associates, Inc.

About Tips.Net

Contact Us


Advertise with Us

Our Privacy Policy

Our Sites


Beauty and Style




DriveTips (Google Drive)

ExcelTips (Excel 97–2003)

ExcelTips (Excel 2007–2016)



Home Improvement

Money and Finances


Pests and Bugs

Pets and Animals

WindowsTips (Microsoft Windows)

WordTips (Word 97–2003)

WordTips (Word 2007–2016)

Our Products

Helpful E-books

Newsletter Archives


Excel Products

Word Products

Our Authors

Author Index

Write for Tips.Net

Copyright © 2016 Sharon Parq Associates, Inc.