Support for Equations in Excel 2010

You can use the new equation editing tools in Excel 2010 to insert common mathematical equations into your worksheets or build up your own equations by using a library of maths symbols. You can also insert new equations inside of text boxes and other shapes.

1. Click the Insert tab.

2. Click on the Symbols group.

3. Click the arrow next to Equation.

4. You may choose between Binomial Theorem, Area of Circle, Pythagorean Theorem, Quadratic formula, etc.

Mark common errors on the worksheet and correct them there

  1. Click the File tab, click Options, and then click the Formulas category.
  2. Under Error Checking, make sure that the Enable background error checking check box is selected.
  3. To change the color of the triangle that marks where an error occurs, in the Indicate errors using this color box, select the color that you want.
  4. Select a cell with a triangle in the top-left corner of a cell.
  5. Next to the cell, click the Error Checking button Description: that appears, and then click the option that you want. The available commands differ for each type of error, and the first entry describes the error.

If you click Ignore Error, the error is marked to be ignored for each consecutive check.

6. Repeat the two preceding steps.