The Formula Report Generator option allows you to very easily create a report showing formulas within your Workbook that are either External references, internal references or both.
You can even nominate which Worksheet(s) within the Workbook to base your report on. Or, have a report showing all formulas within the Workbook on all Worksheets. The report that is generated shows:
The formula in full.
The cell address of the formula. With Clickable Hyperlinks direct to the specified formula cell.
Name of the Worksheet the formula resides on.
Auto filter is also automatically applied for ease of reading and filtering.
The Formula Manager is designed to make the managing of all formulas in Excel a breeze. It can be used in four main areas:
Format
Map your spreadsheet by formula type.
Format the background color of all formulas that match the criteria you set.
Format the font of all formulas that match the criteria you set.
Report
Protection
Lock and hide formulas
Lock only formulas
Hide only formulas
Copy
Copy without formula references changing
Copy and transpose (row to column or column to row) without formula references changing |
