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
  

See also

Spreadsheet Data