Excel: Formula Auditing

Excel worksheets can be full of formulas and functions and in many instances you did not create them and are trying to decipher how a formula was created. It might also be that you created it some time ago and you are reviewing what you did.

You could simply click on the cell and look at the formula or function and see what cells are being used. Alternatively you might have a value and you want to check on where it is being used.

The other thing you might just want to check if you set up a formula correctly or showing someone how you did it.

This is where formula auditing comes in, it is really easy to use and it visually shows you what cells are being used in the formula or you can click on a cell and see where that value is being used.

About garysch

A bit of a techno nut who likes sharing what I know about technology, especially with those who struggle with it. Also through my podcast www.jargonfreehelp.com
This entry was posted in Excel. Bookmark the permalink.

One Response to Excel: Formula Auditing

  1. Nice explanation. I must admit I’ve never needed to use formula auditing being quite proficient in Excel, but a friend asked me how to do it, so I googled it and got your post! Nicely done…

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s