Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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

1 Answer 1

Found it!

http://www.tech-recipes.com/rx/2350/openoffice%5Forg%5Fcalc%5Fshow%5Fformulas/

  1. Click Tools and select Options.

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

  3. Select View.

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

  5. Click OK.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.