Formula Manager

Formula Manager: The Formula Manager is designed to make the managing of all formulas a breeze. It can be used to map your spreadsheet by formula type. You can format the background color of all formulas that match the criteria you set.

Description of Formula Manager:

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 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 types you can specify 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 you to very easily create a report showing formulas within your Workbook that are either external references, internal references or both. You can also nominate which Worksheet(s) to use to base your 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.

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 option is the Transposing of formulas (row to columns and columns to rows) again, without any references changing.

File Size Reducer: FREE


See Also: All products from OzGrid Business Applications

1. EldoS AutoSaveXL 1.5
   AutoSaveXL is Excel plugin that saves the files automatically.
2. Financial Business Plan
   Financial Business Plan for Microsoft Excel. This Excel Application allows you to create your financial business plan as well as continuously analyze your business financials and keep track of your performance.
3. JEM Plus (Excel Add-in)
   Be Smarter & Faster. Over 40 utilities & 207 worksheet functions
4. Cash Flow Valuation Model for Excel
   The Cash Flow Valuation Model for Excel is the perfect tool for comparative company or project valuations. Cash flow analysis is the basis for most sound investment and business decisions.
5. Excel OzGid Plus With Duplication Manager
   The OzGrid plus and Duplication Manager bundled.
6. Visual Basic Macro Examples for Microsoft Excel
   Get over 1200 Microsoft Excel Visual Basic macro examples and solutions in a downloadable help file. Access directly from Excel.
7. Time Sheet
   This extremely easy and simple to use Excel Time Sheet will keep track of your employees hours. It allows you to specify and set unpaid breaks in 5 minute intervals on a daily basis.
8. Excel Levels 1 and 2 Training
   Excel Levels 1 and 2 Courses
9. RepairCost Estimator for Excel 2.5
   Repair and restoration construction cost estimating system for Excel
10. OB Text Manager
    OB Text Manager is a Microsoft Excel add-in that gives you the power to fast manipulate large amounts of text. Easily find and remove duplicates, merge the contents of selected cells , remove special characters and change case in various ways.
11. Smiling Bubbles 1.2
    Have fun with funny smiling bubbles which pop up at your screen, in different colors, faces, and voices. Match then up by their appearances and win the game! There are two game modes: Strategy and Arcade.
12. YellowMaker - Basic Edition
    Includes one year YellowMaker Member Center access for Basic Edition. New versions and other updates are available. YellowMaker is a self-administered business directory designed for your web sites.
13. Atomaders 1.4.0
    This space-shooter is based upon the classical Invaders/Galaxian idea. You have to liberate your planet system from the alien invasion using your spacefighter.
14. Golden Keywords 4.1
    Quality keywords selection plays major role in attracting web site visitors. Golden Keywords will help you avoid errors in your keywords selection process. With Golden Keywords you'll make fast and accurately your own Golden Keywords collection.
15. Market Intelligence Master 5 user
    MIM V.2.0 Business to Business Edition CHECK OUT OUR ALL NEW FEATURES
16. pnVISION-Roll
    - Postnuke Theme: pnVISION-Roll (100 % width) - Banner ability in the header (underneath the logo) - Login form in the header - Search function in the header (searching all your standard modules) - Photoshop files of the logo and...
17. SpamWeed 2.3
    Professional anti-spam software for Outlook Express, Becky!, Eudora and all other POP3 email clients.
18. River Raider 1.2
    This game is remake of old and very popular game - River Raid.
19. Market Intelligence Master 10 user
    Marketing Intelligence Master Version 2.
20. PopUp Inspector - Intelligent popup ad blocker 1.1
    Popup Inspector's intelligent Popup Inspection Engine can block 100% of annoying pop-up and pop-under ads without interfering with your navigation.