Report Excel Formulas

Create a Report Of All Excel Formulas Within a Workbook

BUY | Excel Formula Manager Start

The Formula Report Generator option allows you to very easily create a report showing formulas within your Workbook that are either External references, internal references or both.

1. Referencing other Workbooks. External references
2. Referencing the same Workbook. Internal references
3. Both

You can even nominate which Worksheet(s) within the Workbook to base your report on. Or, have a report showing all formulas within the Workbook on all Worksheets. The report that is generated shows.

1. The formula in full.
2. The cell address of the formula. With Clickable Hyperlinks direct to the specified formula cell.
3. Name of the Worksheet the formula resides on.
4. Auto filter is also automatically applied for ease of reading and filtering.

Example of Formula Report

You will be able to download your Excel Add-in immediately after ordering.

The Formula Manager is designed to make the managing of all formulas in Excel a breeze. 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 (this page)

Protection

• Lock and hide formulas
• Lock only formulas
• Hide only formulas
• Lock/Hide and protect all Worksheets in one go.

Copy

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

Excel Formula Manager Start

Formula Manager Excel 97 through to 2003 Compatible Payment Problems/Options SAVE by buying as part of a Add-ins collection

See Also: Excel Duplication Manager Add-in | Excel Number Manager Add-in | Excel Text Manager Add-in | Excel Named Range Add-in Manager | Excel OzGrid Plus Add-in | Excel Time Sheet | Excel Time Wage and Pay book