When using a spread sheet program it’s easy for errors to creep in if you are not vigilant.

At this time of year when spread sheets are being used to generate End of Year results and updating for use in the new Financial Year, it’s important to check your formulae are still doing what you want and expect them to be doing. 

There is an easy way to check your formulas rather than having to select each cell, giving you an easy way to scan your formulae for inconsistencies

If you are using Excel, you may not be aware that you can toggle between 'Normal View' and a 'Formula View.

• Switch views by using the CTRL +` (the one under your escape key) to reveal the formulas in your sheet. CTRL + ` to switch back to Normal View.
• Or, in the Formulas tab you can find the Show Formulas button.  

Error Checking Tips

Scan your worksheet columns for visual inconsistencies and accidental overtypes.

If you select a cell, the cells utilised in the formula are highlighted.