Report the formulas used in the worksheets in your workbook

Information › Report the formulas used in the worksheets in your workbook

This tool will report all formulas used in the worksheets on your workbook.

The report shows the following information:

Sheet; The name of the worksheet the formula is on

Cell; The cell address the formula is in. You can click on the address to jump to it, it is a hyperlink.

Value; The calculated result

Displayed value; The displayed result. This uses the cell's number format.

Formula; The formula

In the Excel menu choose: ASAP Utilities › Information › Report the formulas used in the worksheets in your workbook