Excel Top Tip #7

Normally, you view the formula of a single, selected cell in the formula bar. The rest of the sheet shows results. If you really want to understand the worksheet, it’s helpful to see all the formulas at once. Choose Formulas, Formula Auditing, Show Formulas.

Show Formulas

Show all formulas to help you understand