HomeWindowsOpenOffice.org Calc: Show Formulas to Verify Your Equations

OpenOffice.org Calc: Show Formulas to Verify Your Equations

One mistake that is often made in spreadsheets containing lots of data and formulas, is the accidental placement of numbers in a cell instead of the formula. It is a painful task to examine each and every cell one at a time to verify that the proper cells are using the proper equation. In addition, verifying that the cells referenced in the equations are correct can be equally overwhelming. Fortunately, Calc allows you to show the formulas of the entire spreadsheet so that you can more easily check your work.


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.

To go back to viewing the calculated values, simply repeat the above steps and uncheck the Formulas checkbox.

Rob Rogers
Rob Rogers
Once a prolific author here on Tech-Recipes, Rob has moved on to greener pastures.
RELATED ARTICLES

5 COMMENTS

LEAVE A REPLY

Please enter your comment!
Please enter your name here

- Advertisment -

Most Popular

Recent Comments

Cleveland Furia on How to Clear Google Activity
Sid Wohlfarth on How to Clear Google Activity
Riley Magsayo on How to Clear Google Activity
สมัครรับเครดิตฟรี ทันที on How to improve Remote Desktop Protocol Performance
Neal Wangstad on How to Clear Google Activity
Slavcho Andov on How to install Ubuntu
Slavcho Andov on How to fix bad sectors
Sheraz Ali on How to Backup Android