|
The
Formula Manager can be used
to map your spreadsheet by formula type. You can format the
background color of all formulas that match the criteria you
set.
It a can also
format the font of all formulas that match any criteria you
set. Once applied, you can tell at a glance which cells
contain formulas and which do not. This and much more!
It can
be used in four main areas:
- Format
- Map your spreadsheet by formula type.
- Format the background color of all formulas that match the
criteria you set.
- Format the font of all formulas that match the criteria
you set.
- Report
- The formula as in the cell.
- The address of the cell.
- The sheet is resides on.
- Auto filter is also automatically applied for ease of
reading and filtering.
- Report includes Clickable Hyperlinks direct to the
specified formula cell.
- Protection
- Lock and hide formulas
- Lock only formulas
- Hide only formulas
- Copy
- Copy without formula references changing
- Copy and transpose (row to column or column to row)
without formula references changing
|