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. Excel Level 2 and 3 Training
   CURRENT SPECIAL Was $75.00 Now $39.95 Buying the lessons in this bundle saves you over 50% off the normal price! WE TEACH FROM EXPERIENCE NOT A MANUAL.
2. ExcelCube Lite
   ExcelCube merges, or consolidates, entire worksheets across standard Excel workbook files without using linking formulas, add-ins, or macros. The Lite version only uses one worksheet per workbook file.
3. To Do List Assistant for Microsoft Excel
   Manage your to do lists within Microsoft Excel!
4. Number,Text & Formula Manager
   Number,Text & Formula Manager is 3 seperate Excel Add-ins bundled together to save you 50% off the individual prices. Read about these 3 add-ins in details and see screen shots on this site.
5. OM-FACILITY LOCATION
   Excel Spreadsheet Templates for locating distribution center.
6. Report Runner for Microsoft Excel
   Print (or export) your Excel reports automatically in the order you need them.
7. Report To Data Assistant for Microsoft Excel
   Easily convert your text reports to databases with the Report To Data Assistant. Select the rows you want to include or excluded with the Assistant's features. Remove blank rows, concationate cells, and combine rows quickly and easily.
8. Formula and Text Manager for Excel
   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.
9. Filter Assistant for Microsoft Excel
   The Filter Assistant for Microsoft Excel makes filtering data easy! And, it eliminates many of the annoying features of Excel's data filter feature.
10. Significant Digit Assistant for Microsoft Excel
    One of the key functions that Microsoft left out of Microsoft Excel is one that rounds values to the number of significant digits that you wish to use. The Significant Digit Assistant adds this function to Excel!
11. Silly Balls 1.1
    This game will give you the opportunity to practice the skill of kicking a ball. Silly Balls is played on a field with four sliders arranged on the top, bottom, left, and right sides of the screen.
12. Pokie Magic: Bunny Bucks
    Pokie Magic - Bunny Bucks is an Aussie style 20 payline 5 reel poker machine (also called a slot machine or a Pokie). It has an exciting Bunny Cash feature. Win up to 100 Free spins! Double up any win up to five times.
13. Brain Damage Screensaver
    Brain Damage - fascinating truly three dimensional Direct X enhanced screensaver. Features a very cool 3d background image that was included with a screensaver compiler program and a 3d-desktops.com original three dimensional multiple sphere model.
14. Blues Grooves for Beginners and Beyond
    The downloadable eBook Blues Grooves for Beginners and Beyond shows you how to play blues shuffles, boogies, riffs and progressions. Even if you're just beginning to learn guitar, this guide will take you step by step to playing Blues Grooves.
15. Design Master Lite
    Design Master Lite introduces students and entry-level engineers to probabilities, risk assessment, and optimization, as applied to math-based engineering and science analysis. Comes with a set of equations from the Design Analysis Handbook.
16. The Best of Monet (Vol. 2) Screen Saver
    The Best of Monet (Vol. 2) Screen Saver views 83 paintings from one of the world's greatest painters, Claude Monet.
17. Market Intelligence Master 5 user
    MIM V.2.0 Business to Business Edition CHECK OUT OUR ALL NEW FEATURES
18. AD Midnight Fire
    Midnight Fire - animated desktop wallpapers is the qualitatively new replacement of the well-known wallpapers, but in a difference with the simple beautiful images we offer you the real living world, full of sounds and of movement, where time goes...
19. Design Master
    Design Master (DM) is used by engineers and analysts for design validation, worst case analysis, risk assessment, and optimization.
20. AD Mystery Forest 1.0
    Mystery Forest - animated desktop wallpapers is the qualitatively new replacement of the well-known wallpapers, but in a difference with the simple beautiful images we offer you the real living world, full of sounds and of movement, where time goes...