| Home | What's New | Awards | Links | Contacts |
|
Today Spotlight |
||
| No Software | ||
| Our Picks | ||
|
No Software |
||
| Relative Keywords |
| All Top 10 |
2. Excel Text Manager
3. Excel Formula Manager
4. Excel Number Manager
5. Formula Reference Changer Sheet Index Creator
6. OzGrid Excel Plus Add-in
7. Formula Ref Changer and Sheet Index Creator
|
Home > Database Spreadsheets Tools> Excel Add-Ins> Excel Formula Manager |
||||||||
Excel Formula Manager
|
||||||||
| OS: | Win9x/WinNT/Win2000/WinME |
| Price: | $29.95 |
| Date Added: | 2004-4-4 |
| Developed by: | OzGrid Business Applications |
The Formula Manager is designed to make the managing of all formulas in Excel a breeze. It can be used to:
1.Map your spreadsheet by formula type.
2.Format the background color of all formulas that match the criteria you set.
3.Format the font of all formulas that match the criteria you set.
Once applied, you can tell at a glance which cells contain formulas and which do not.
The formula types you can specify for Formatting (font and/or background), Hiding and Locking are:
1.Referencing other Workbooks
2.Referencing other sheets in Workbook
3.Referencing active sheet
4.Do not use cell references, eg =1+5, =200/50 etc
5.All types
When you have a spreadsheet that contains formulas, you want to be sure that no user can delete, over-write or modify them. The Formula Manager can do this for you in seconds! Just specify which formula types to Lock, Hide and/or Lock and Hide. You can even protect the sheet in the same step! You can also easily Lock or Unlock all cells in one click.
The Formula Report Generator 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) to base your report on. The report that is generated contains.
1.The formula as in the cell.
2.The address of the cell.
3.The sheet is resides on.
4.Auto filter is also automatically applied for ease of reading and filtering.
5.Report includes clickable Hyperlinks direct to the specified formula cell.
Also included is a Formula Copy. This allows you to easily copy any formula range and paste it to a destination without any references changing. The other option is the transposing of formulas (row to columns and columns to rows) again, without any references changing.
Unconditional 30-day money-back guarantee, so do not hesitate,
, only $29.95
