Printing formulas in Excel : A look

If your users have invested time in writing numerous formulas, they may want to print them for safekeeping. Although Excel doesn't include a simple "Print Formulas" button, functionality is built in. Here's how to find it:
1. Go to the Tools menu.
2. Click Options.
3. Within the section called Window Options on the View tab, select Formulas.
4. Click OK.
There is also a keyboard shortcut for this function. Press [Ctrl]~. In both cases, the result is that the formulas, rather than their results, will appear in the worksheet.


No responses found. Be the first to comment...

  • Do not include your name, "with regards" etc in the comment. Write detailed comment, relevant to the topic.
  • No HTML formatting and links to other web sites are allowed.
  • This is a strictly moderated site. Absolutely no spam allowed.
  • Name: