Formerly Best Training
© 2024 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE
2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT. United Kingdom
Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel course tate modern - Charts
Resolved · Low Priority · Version Standard
Hi Katie
Thank you for your question.
In Office 2002/XP and 2003 there is a formula error marker (green triangle) that comes up in the corner of the cell with an error, or suspected error.
This can be quite useful for troubleshooting formula errors. Click on the cell displaying the green triangle and a smart tag with an exclamation mark symbol on it will appear. Holding your mouse over this will reveal a dropdown arrow which you can click on to choose from various options. In particular, Help on this error, Show Calcuation Steps and the Show Formula Auditing toolbar options are useful.
Amanda
|
Excel tip:Display Formulas Instead of Results in Excel 2010By pressing Ctrl ~ once, Excel will display formulas rather than the results of the formulas. Press it again, and the results will appear again. |
We'll call during UK business hours
Server loaded in 0.1 secs.