XLL+ Class Library (7.0)

Using the Excel Formula Wizard

The Excel Formula Wizard is a very useful tool for entering formulae with many arguments, or when the user is unfamiliar with the formula.

The Excel user can start the Formula Wizard by clicking on the Formula Wizard tool, shown above, or by typing the name of the function into a cell and then pressing Ctrl+A.

The first page of the wizard shows all the available worksheet functions, listed by category.

The second page of the wizard (sometimes also called the Formula Palette) contains fields for each of the function's arguments. Note that the description for the currently selected argument is displayed below the function's description.

Formula Wizard support in XLL+

Next: Avoiding the Excel Formula Wizard >>