Home > Excel Business Solutions > Excel Productivity > Time Saving > Formula Management Share

Formula Management

Excel formula management for time saving

Excel Formula Management

Rate this solution:
(2.5/5 from 2 votes)
Formula Management screenshot
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:
  • Referencing other Workbooks
  • Referencing other sheets in Workbook
  • Referencing active sheet
  • All types
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:

Get It

Price: USD 29.95
(Updated on 2018-09-21)

Related Excel Solutions for Formula Management

Table ManagementData Management  Formula AnalyzerNavigation and Auditing  Fix Broken LinksNavigation and Auditing  Formula Cheat SheetTraining and Tutorials  Conditional Row DeletionTime Saving  Productivity Add-insTime Saving  Text ManipulationTime Saving  Name ManagementTime Saving  Worksheet AnalysisTime Saving  Model Building ToolsModel Building

Share your thoughts and opinion with other users: Create Review

Browse Main Excel Solution Categories

Business Finance Financial Markets Operations Management Excel Productivity

Additional Excel business solutions are categorized as and the . Further solutions proposed for specific user requirements can be either found in the Excel Help Forum.