Formulas -> Formula Auditing->Show Formulas

Show Formulas

Sometimes, it helps to loooook at the formulas. Here are the steps:

 

Before You Begin: Remove the arrows

 

Try it: Show Formulas

Select Cell E8.

Go to Formulas->Formula Auditing.

Click Show Formulas.

 

What Do You See? All of the cells that have formulas are displayed. Cell E8 has a number that we typed in earlier in this lesson: no formula.

 

You can click on Show Formulas, again, to turn off the formulas display.

Exam 77-888: Microsoft Excel Expert 2010

2. Applying Formulas and Functions

2.1. Audit formulas: Show Formulas