Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

excel vba courses london - formula audit

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel vba courses london - Formula Audit

excel vba courses london - Formula Audit

ResolvedVersion Standard

Danielle has attended:
Excel Advanced course

Formula Audit

How to use Formula Auditor?

RE: Formula Audit

Hi Danielle,

There is a formula auditing toolbar, which shows where the values in your formula orginate from and which cells are affected by them. (Trace Dependants, Trace Precedence). There is also a Watch window where you can view the contents, formula and value of one cell by scrolling through others.

I hope that answers your question, if there was anything more specific please let me know.

Tracy

Excel tip:

Reset Excel toolbars to default settings

If you find any of your toolbars in Excel have changed (i.e. they are missing or have extra buttons) then you can reset them to their defaults.

1. Go to Tools - Customise.
2. Select the Toolbars tab.
3. Select (highlight) the name of the toolbar you wish to reset, then click the Reset button on the right.
4. Close the dialogue box.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.