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.
In Excel 2007, on the Formulas ribbon, select the Error Checking option in the Formula Auditing section.
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.
Trace error button
Excel 2003 and older: File menu button Excel 2007 and newer: MS Office button (circle at top left of window)
The Offic Button in Excel.
In Excel 2007, use the "Format as Table" button in the Styles section of the Home tab.
You use the sum button in excel when you want to add numerous amounts of numbers.
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.
Close Button
Yes there is.
it shows the layout
Toggle button