Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Normally a spreadsheet hides the formulas you enter and displays the values. I'm looking for a way to display the formulas but hide the values, so I can print it out and show people how my spreadsheet actually does what it does. Any ideas?

share|improve this question
I answered my own question... see below! – kelly Nov 12 '09 at 5:16
Then you should mark as closed. – DaveParillo Nov 12 '09 at 5:20
@DaveParillo It says I can't accept my own answer for 2 days... – kelly Nov 12 '09 at 5:42

Found it!

  1. Click Tools and select Options.

  2. In the left pane of the Options window, expand Calc.

  3. Select View.

  4. In the Display section, check the Formulas checkbox.

  5. Click OK.

share|improve this answer

You must log in to answer this question.