Toggle Help Topics Menu >

Formulas Report

The formulas report will create a listing of all the unique formulas in the workbook. The report includes the sheet name, the cell address, whether the formula is an array formula, and the formula itself in FormulaR1C1 format. The individual Formulas Report lists only the unique R1C1 formulas in a worksheet, so the cell address is the first address encountered containing the formula.

For more advanced control of the formula output, see the Master Audit Report.