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.
Here 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
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
To remove the arrows click the Remove Arrows icon on the Auditing Toolbar.
Till next time…