Adding or changing Functions, References and Defined Names.

Navigation: FXLV4_Manager > Explorer Pro Edit Mode Buttons >

Add Reference

Insert Reference will bring up an input box to allow you to select a range reference using the mouse or type the reference directly.

The reference will be placed in the formula text either at the insertion point or by overwriting any selected text.

Function Wizard

You can use the function wizard (not available on Mac) to:

Modify an existing function

OR Add a new function at the insertion point.

If one or more characters are selected in the Formula Box the Formula Editor will try to find the nearest function and launch the formula wizard for that function. You can also use the Function Select buttons to select the function you want to modify before launching the formula wizard.
If there are no characters selected in the formula box the Formula Editor will insert a function using the formula wizard at the current insertion point. This can simplify creating formulas with functions embedded inside other functions.

Add Name

This button brings up a dialog box allowing you to choose which of the open workbooks you want to insert a defined name from.
When you choose a workbook you get a list of all the Defined Names in that workbook.
You can select a name to be inserted into the formula box at the insertion point or by overwriting any selected text.

Copy From

Use the Copy From button to choose a cell and copy its formula into the Formula Box at the insertion point. If you want to replace all or part of the existing formula in the Formula Box you can select the text you want to replace or clear the formula box before using Copy From.

Changing a reference from relative to absolute

Using F4 adjusts a single reference at or adjacent to the insertion point from relative to absolute etc. The sequence is:

Row and column Relative

Row and column Absolute

Relative column and Absolute Row

Absolute Column and Relative Row

Structured References are also adjusted from relative to absolute, using techniques borrowed from Jon Acampora http://www.excelcampus.com/

Enter Formula

This button attempts to enter the formula from the Formula Box into the destination range.
If the destination range covers more than one cell the formula will be entered into all the cells.
If the Array Formula checkbox is ticked the formula will be array entered.