error checking

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Error Checking

Error Checking

resolvedResolved · Medium Priority · Version 2007

Helen has attended:
Excel Intermediate course

Error Checking

How do you track back and find an error in a worksheet

RE: Error Checking

Hi Helen, I guess you might have clicked the submit button twice, but if not here is the answer to your question.
If a formula displays an error value, such as #DIV/0!, the Trace Error command or button can be used to locate all cells that provide data to the formula, To use this operation follow these steps;
Select the cell that contains the error
Click on the Trace Error button on the Auditing Toolbar (Tools>Auditing>Trace Error)
Red arrows will point from the cells that cause the error to the cell that contains the error. Blue arrows point to the precedents of the cell that causes the error.
Note: to quickly select the cell at the other end of an arrow, double click on the arrow. I hope that helps, regards Pete


 

Excel tip:

Find cells that match a format

In Excel you may wish to find cells that contain a specific formatting such s colour.

Select Edit > Find, click on Options and then Format...choose the formatting that you want found and click on OK

Choose one of the Find buttons to find.

View all Excel hints and tips


Server loaded in 0.1 secs.