Developed as a Microsoft Excel add-in, Default Formulas gives the developer the control of protected mode without the limitations.

Establish default formulas for a range.

• Works great with Tables (ListObjects).
• Automatically uses structured references if available.

Operator can override default formulas.

• Default formulas and overriden formulas are designated to the operator by color.
• Makes changes to formulas obvious.
• Operator can return cells to their default formulas by simply pressing [Delete].

Use Defaulted and NotDefaulted functions to return ranges of cells for use in calculations.

• NotDefaulted function makes it simple for default formulas to refer to themselves without encountering circular reference errors.

Create default formulas with circular references.

• As long as any one of cells in the circular relationship are not defaulted, no errors will result.
• Very compact method for allowing operator to choose from multiple input methods.
• Examples:
• Establish default formulas for Start, Duration, and Finish. Operator can override their choice of any two and the remaining default formula computes the missing value.
• Establish default formulas for Qty, Unit Price, and Total Price. Operator can override their choice of any two and the remaining default formula computes the missing value.
• Establish default formulas for Fahrenheit and Celsius. Operator can override their choice and the remaining default formula computes the corresponding value.

Hotkey reveals DefaultFormulas user interface

Default Formulas are stored in hidden named ranges, which can be revealed and edited manually if desired.