Paul Wherly

Auditing your spread sheet to find errors in Microsoft Excel 2007 and 2010

Auditing your spreadsheet for errors Excel 2007 and 2010

Sometimes when you are working on a spread sheet Excel throws up a funny looking error code in the cell. If you see any of these you know that somewhere along the line your formula is a bit wonky.

#DIV/0! – You have tried to divide one value by a cell that contains a 0 value
#NAME! – Usually you have tried to divide or multiply something by a cell with a text entry
#VALUE! – Your formula may contain different types of data

There are other error codes; however these are the most frequently encountered ones.
Error Codes in ExcelHere you can see a couple of errors described above

Excel can help you to trace where those errors come from to help you correct them. Usually it is a simple cell reference that is incorrect.

To Audit your Errors

Click on the cell that has the error

Click on the Formula Tab

Find the Auditing Group

Auditing Toolbar Excel 2007 and Excel 2010

 

 

 

 

Click the relevant arrow to trace either Precedents or Dependents

As you can see in the picture above there are now some arrows showing the cells that the formula references

Audit spread sheet showing arrows

 

 

 

To remove the arrows click the Remove Arrows icon on the Auditing Toolbar.

Till next time…

 

 

 

Leave a Reply

Your email address will not be published. Required fields are marked *

Contact us

Would you like to talk through your IT Training needs?
Just send through your details and we'll get back to you.

More