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 where an error is in a worksheet.

RE: Error Checking

Hi Helen, Thank you for your post, I hope you enjoyed your course, in 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:

Jumping Across the Excel Screen

PgDn and PgUp keys scrolls up and down a screen page in most applications.

Alt+PgDn and Alt+PgUp is the equivalent across the spreadsheet.

View all Excel hints and tips


Server loaded in 0.09 secs.