# Use Equation Editor in Excel

To document mathematical formulas on a worksheet, you can insert or edit an equation as an object by using Microsoft Equation Editor.

You build the equation by selecting symbols from the **Equation** toolbar (toolbar: A bar with buttons and options that you use to carry out commands. To display a toolbar, press ALT and then SHIFT+F10.) and by typing variables and numbers. In the top row of the **Equation** toolbar, you can choose from more than 150 mathematical symbols. In the bottom row, you can choose from a variety of templates or frameworks that contain symbols, such as fractions, integrals, and summations. The Equation Editor provides symbols that are not available on the keyboard (for example, Greek letters and the square root symbol) in a logical grouping so that you can easily build equations.

You can also create an equation in Microsoft Office Word and then copy and insert that equation object into your worksheet. You may find that the Equation Editor in Word makes it easier to find the symbols and structures that you want. Word also provides a gallery of commonly used equations that you can easily copy and paste into your worksheet.

In the preceding picture, cells A2 and A3 contain Excel formulas that return values. Equation objects that express the same function in mathematical terms are embedded on top of the adjacent cells B2:C2 (a formula that calculates the future value of 10000 at 5 percent interest compounded annually over a three year period) and on top of cell B3 (a formula that calculates the square root of 729). These objects are not contained in the cells, and don't perform any action — you can think of them as images of text that describe the formulas in the cells in column A.

- Insert an equation with Equation Editor
- Edit an equation in Equation Editor
- Create an equation in Word

## Insert an equation with Equation Editor

- Click anywhere on a worksheet where you want to insert the equation.
- On the
**Insert**tab, in the**Text**group, click**Object**.

- In the
**Object**dialog box, click the**Create New**tab. - In the
**Object type**box, click**Microsoft Equation 3.0**.

If Equation Editor is not available, you may need to install it.

- Exit all programs.
- Click
**Add or Remove Programs**in Control Panel. - In the
**Currently installed programs**box, click**Microsoft Office <suite> 2007**or**Microsoft Office Excel 2007**, depending on whether you installed Excel as part of Office or as an individual program, and then click**Change**. - On the
**Change your installation of Microsoft Office <suite> 2007.**screen, click**Add or Remove Features**, and then click**Continue**. - On the
**Installation Options**tab, click the expand indicator (+) next to**Office Tools**. - Click the arrow next to
**Equation Editor**, and then click**Run from My Computer**. - Click
**Continue**. - After the Equation Editor installation is complete, restart Office Excel 2007.

- In the
**Object**dialog box, click**OK**. - Use the symbols, templates, or frameworks on the
**Equation**toolbar to edit the equation.

If you need help, do the following:

- Select and right-click the equation object.
- Point to
**Equation Object**and then click**Open**. - Click
**Equation Editor Help Topics**on the**Help**menu.

- To return to the worksheet, click any empty cell.

## Edit an equation in Equation Editor

- On a worksheet, double-click the equation object that you want to edit.
- Use the symbols, templates, or frameworks on the
**Equation**toolbar to edit the equation.

If you need help, do the following:

- Select and right-click the equation object.
- Point to
**Equation Object**and then click**Open**. - Click
**Equation Editor Help Topics**on the**Help**menu.

- To return to the worksheet, click any empty cell.

## Create an equation in Word

- Click anywhere in a Word document.
- On the
**Insert**tab, in**Symbols**group, click**Equation**.

This displays the **Equation Tools**, adding a **Design** tab.

- On the
**Design**tab, use the symbols and the structures to build your equation. - To copy the equation, select it and press CTRL+C.
- To paste the equation into your worksheet, activate the worksheet and then press CTRL+V.

** Tip ** You can preview a gallery of built-in equations by clicking the arrow at the bottom of the **Equation** command (**Insert** tab, **Symbols** group or **Design** tab, **Tools** group).