The Formula Manager is designed to make the managing of all formulas a breeze. It 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.

The Formula Manager is designed to make the managing of all formulas in Excel a breeze. It can be used in four main areas

1.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.

2.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.

3.Protection

Lock and hide formulas

Lock only formulas

Hide only formulas

Lock/Hide and protect all Worksheets in one go.

4.Copy

Copy without formula references changing

Copy and transpose (row to column or column to row) without formula references changing