best training excel intermediate - 3D formulas - error tracing

Hi Bhavesh

Thank you for your question.

To trace errors in a formula which refers to cells on other sheets:

1. Click on the cell with the formula that is showing the error message.
2. Bring up the Formula Auditing toolbar on the screen (View - Toolbars - Formula Auditing)
3. Click the Trace Precedents button.
4. Any cells that are on other sheets that are providing data to the formula will be indicated by a dashed line with a small spreadsheet icon next to it.
5. Using the white arrow pointer, double-click anywhere along the dashed line. This will bring up the Go To dialogue box, from which you can select a cell to view and click OK. This will take you directly to the cell you have chosen.

Amanda