You may generate a data list of all the cells containing a formula in the either the active worksheet or the whole workbook from the ACBA Functions Menu Bar - Spreadsheet Data Lists and the Shortcut Tool Bar (for the active worksheet only).

The list report includes the type of list, the scope of the analysis and the data and time that it was generated.

Note that this list reports all formulae irrespective of whether they resolve to a number. Many of these resolve to a text string.

The list is presented in a standard format (common to the data lists). The four fields in the data list are

• Worksheet
  
• Cell
  
• Formula
  
• Result
  

Remarks

For more details about ACBA Analytical and Audit Tools our website contains general descriptions and additional information about it.

See also

Spreadsheet Data