[]
        
(Showing Draft Content)

Formulas Menu

The Formulas Menu allows you to add formulas and custom names.

image

Menu Options

Description

Function Library

This group contains all the formulas that one uses in Spread.

Defined Names

This group can be used to name a cell. These named cells can be called from any part of the worksheet.

Formula Auditing

This group helps in auditing the flow of formulas. It can trace the precedents and dependents, and show formulas to debug the errors in formula.

Calculation

This group lets you choose between automatic and manual calculation. You can also calculate the active sheet or entire workbook.

Calculation Engine

This group allows using Dynamic Array and reserving white space characters inside the formula in worksheets.