There are several options for how to view your formulas and functions on an Excel worksheet:
- View (and print) your formulas by choosing Tools → Options and clicking the View tab. Select Formulas.
- For more advanced formula views, turn on Formula Auditing. Choose Tools ? Formula Auditing ? Formula Auditing Mode (shortcut: ctrl+'). Use the Formula Auditing toolbar to Trace Precedents and Trace Dependents to see what "goes into" each formula and where each cell "goes", math-wise.
0 comments
Hide comments