ASAP Utilities, description of our Excel tools

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

« Previous
Create a list of all sheet names

Next »
Create a list of all type of cell values

Printer friendly page

Connect with us and receive our tips that show you how to benefit from the tools in ASAP Utilities at: