Printing Formulas and Functions - 30 Oct 2007

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.

Hide comments

Comments

  • Allowed HTML tags: <em> <strong> <blockquote> <br> <p>

Plain text

  • No HTML tags allowed.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Lines and paragraphs break automatically.
Publish