Formulas -> Formula Auditing->Show Formulas

Exam 77-427 Microsoft Excel 2013 EXPERT
1. Manage and Share Workbooks
1.3   Manage Workbook Changes: Troubleshoot With Tracing (Show Formulas)

no

Show Formulas

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

 

Before You Begin: Remove the arrows

 

4. 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.

graphic3
graphic2
graphic1