Skip to main content
Mail a PDF copy of this page to:
(Your email address will not be added to a mailing list)
Show menu

Show formulas

Next selectShow formulas


Displays the formulas in the spreadsheet instead of the calculated results.

When the option Show formulas is checked then the spreadsheet will display the formulas that you have entered, otherwise the results of the formulas are displayed.

Show formulas (option not selected) Show formulas (option selected)
Show formulas (formulas hidden) Show formulas (formulas shown)
The option Show formulas is not checked: the program displays the results. The option Show formulas is checked: the program displays the formulas.

If you have to enter a lot of data (on a slow computer), or when you want to see the possible relationship between cells, then it is convenient to select this option.

See also