We can use the Equation editor to insert, write or format Equations. In this tutorial, we will learn how to write, insert, solve or format Equations using the Equation Editor effectively.

Figure 1 – How to add equations

How to Insert an Equation using the Equation Editor

  • We will go to the Insert tab and navigate to the Symbols group

Figure 2 – How to enter a formula

  • We will click on the drop-down arrow to view the Equations and Symbols icons.

Figure 3 – How to insert an equation

  • Next, we will click again on the drop-down arrow to the side of the Equation arrow.
  • This will show a list of preinstalled equations.  We will click on any of these Equations to insert it into our Excel sheet.

Figure 4 – Enter formula

  • Let us click on the Expansion of a Sum Equation.
  • Now, we will select OK.

Figure 5 – Insert Equation

Write an equation using Equation Editor (How to input a formula)

  • If we want to create a formula of our own, we will go to the Insert tab and navigate to the Symbols group
  • Next, we will click on the Equation.
  • This will input a text box“Type Equation here” in our Excel sheet.

Figure 6 – How to add equations

  • It will also open two tabs, the Drawing tools, and Equation tools editor in the ribbon at the top of our worksheet.

Figure 7 – Write or Insert an equation

  • We can use the preinstalled Equations by clicking the drop-down arrow under the Equations icon.

Figure 8 – Enter formula

  • We can equally create our own Equations by using the Symbols tab alongside other kinds of functions we find in the Equations tools tab.
  • We can use a wide range of other operations in the Symbols group.

Figure 9 – Insert Equation Tab

  • The Structures group gives us different ways to insert particular things. For example, if we want to enter a fraction in our Excel sheet. We can select any of the fractions options.

Figure 10 – How to add equations using definite structures.

  • Next, we will enter our values into the pop-up boxes in our Excel sheet.

Figure 11 – How to input a formula

Formatting our Equations

  • We can always resize our Equations by right-clicking and Increasing font size.

Figure 12 – Format formula using Equations editor

  • In addition, we can embed formula into a cell. This means we can make our formula stay within a cell rather than move around as a floating object. To do this:
    • We will right-click on the Text box and select Format Shape

Figure 13 – How to format equation

  • Next, we will select Size and Properties

Figure 14 – Format Shape using Size and Properties.

  • And lastly, we will mark “Move and size with cells”.

Figure 15 – Format to Move and size with cells