answersLogoWhite

0

Trace Error shows you the cells that are referenced by a formula that has an error. With a cell with an error highlighted, clicking on the Trace Error button will show arrows indicating links between cells which can help you trace the error. You can then check what cells are referenced and see can you find which one may be causing your error.

User Avatar

Wiki User

7y ago

What else can I help you with?

Related Questions

What option button options lists error-checking option of an invalid formula to a cell?

In Excel 2007, on the Formulas ribbon, select the Error Checking option in the Formula Auditing section.


Where is the formula error button in Excel 2007?

There is no formula error button in Excel. However, there is an Error Checking button on the Formulas ribbon in the Formula Auditing section in Excel 2007.


What options button lists error checking options following the assignment of an invalid formula to a cell?

Trace error button


What button opens a menu of basic commands such as save and print in Excel?

Excel 2003 and older: File menu button Excel 2007 and newer: MS Office button (circle at top left of window)


A central location for managing and sharing in Excel?

The Offic Button in Excel.


Which button formats data as a table in Excel?

In Excel 2007, use the "Format as Table" button in the Styles section of the Home tab.


What is the name of the button you click to sum cells in Excel?

You use the sum button in excel when you want to add numerous amounts of numbers.


What do you click on if you receive an error message while running a procedure in Excel?

That may depend on what happens. You may just have to click on the dialog box that appears or stop the procedure, by clicking on the stop button. You can then try to find the cause of the error and fix it.


Used to quit excel?

Close Button


Is there a Clear All button in Excel?

Yes there is.


What does the layout button in excel do?

it shows the layout


What button is used in excel to turn a feature both on and off?

Toggle button