Excel Formula Management
Rate this solution:(2.5/5 from 2 votes)
The Formula Management Add-in for Excel is designed to facilitate the managing of all formulas within Excel. It can be used to map a spreadsheet by formula type. The add-in also allows formatting the background color of all formulas that match a set criterion. It a can also format the font of all formulas that match any criteria. Once applied, it can be ascertained a glance which cells contain formulas and which do not. |
When a spreadsheet contains formulas, it may be necessary to ensure that no user can delete, over-write or modify them. Formula Management for Excel can do this in seconds by specifying which formula types to Lock, Hide or Lock and Hide. The sheet can also be protected in the same step. All cells can be easily Locked or Unlocked in one click.
The formula types which can be specified for Formatting (font and/or background), Hiding and Locking are:
The Formula Report Generator allows the creation of a report showing formulas within the Workbook that are either external references, internal references or both. Worksheet(s) can also be nominated to base the report on. The report that is generated contains, the formula as in the cell, the address of the cell and the sheet is resides on. Auto filter is also automatically applied for ease of reading.
The Formula Management Add-in for Excel comes with a free Excel file size reducer.
The Formula Management Add-in for Excel is also available in the following discounted bundled offers:
Price: USD 29.95
(Updated on 2012-09-21)
Related Excel Solutions for Formula ManagementConditional Row DeletionTime Saving Productivity Add-insTime Saving Table ManagementData Management Text ManipulationTime Saving Name ManagementTime Saving Model Building ToolsModel Building Formula AnalyzerNavigation and Auditing Worksheet AnalysisTime Saving Fix Broken LinksNavigation and Auditing Formula Cheat SheetTraining and Tutorials
|Share your thoughts and opinion with other users: Create Review|
Browse Main Excel Solution CategoriesBusiness Finance Financial Markets Operations Management Excel Productivity