Automatic formula auditing - Is there an option/addin?

[Son_of_Soren]

When you click on the formula in a cell it shows you what other cells are linked to it. Often when checking my work I have to do this all over my spreadsheet in order to make sure everything is right......

Is there any setting/option or excel addin that automatically highlights the cells that are used in your formula or automatically traces precedents without having to click on anything other than selecting the cell?

[FDibbins]

Hi, welcome to the forum

Take a look at the Formula tab/Auditing tools

[Son_of_Soren]

I'm not really seeing anything under Formulas -> Formula Auditing that does anything automatically.

To clarify, when you hit "F2" on a cell it highlights the cells used in the formula. I'm looking for anything that will highlight the cell the same way without taking me into the formula.

[Debraj Roy]

There was a free ADD-IN.. Personally I recommend it and liked it very much..

FormulaDesk. http://www.formuladesk.com/

[Son_of_Soren]

Amazing!!! Exactly what I was hoping to find.

THANKS!

[Gareth_Hayter]

Thanks Debraj and Son_of_Soren. I'm the creator of FormulaDesk - it's great to hear feedback like yours....I'm doing something right!

Please let me know of any ideas/suggestions you have for how I can make FormulaDesk even better. You can always send me a private message, or go here: http://formuladesk.uservoice.com/

Kind regards,
Gareth.

[Son_of_Soren]

OMFG, just got permission from my IT department to install and it's freaking amazing... how is this not a standard feature! I'll be forwarding this to several people. I hope you have a way to monetize this Gareth, you've got a winner!

[Gareth_Hayter]

That's fantastic! I hope it provides a lot of benefits to you. I plan on releasing a Pro version in the future. Thanks very much for you support! Please let me know if you find any issues, and have any suggestions.

[Gareth_Hayter]

Just a quick note to let you know that you can now subscribe to a mailing list that will send you an email whenever a new version of FormulaDesk is available for download (with bug fixes, new features etc.)

Just sign up at the bottom of the homepage: http://www.formuladesk.com

This will be a better way to keep informed about any new features, like the ones I've added in the past few days.