Forum home » Delegate support and help forum » Microsoft Excel Training and help » Tracing formula errors

Tracing formula errors

ResolvedVersion 2003

Mon 8 Feb 2010, 16:14 Delegate Olga said...

Olga has attended:
Excel Intermediate course

Tracing formula errors

How do you trace formula errors

Mon 8 Feb 2010, 16:30 Trainer Anthony said...

RE: Tracing formula errors

Hi Olga, thanks for your query. Your Formula Auditing tools in the Tools dropdown menu are key to this. Remember to select a cell with a formula in it, then use Trace Precedents to determine what cells are being fed into the formula, and then Trace Dependents to find out where the value generated by that formula is being fed into. Remember to use these tools when trying to troubleshoot a REF! error message.

Hope this helps,

Anthony

Tue 16 Feb 2010: Automatically marked as resolved.

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Convert a column into row quickly in Excel 2010

Occasionally you might enter data into Excel vertically and then when you finish realize that actually it would look more clearer if it was represented in a horizontal format. If you follow these simple steps below, you can quickly change the data from going vertically to horizontally and vice versa.

First, select the column you want to convert into a row or a row into a column. Then right click and select Copy. Go to the sheet where you want to past this row as a column and select “Paste Special”. Remember to check the check-box “Transpose” and select “OK”.

View all Excel hints and tips

Tracing formula errors

Tracing formula errors

RE: Tracing formula errors

Excel articles

Excel tip:

Convert a column into row quickly in Excel 2010