Advanced Spreadsheets – Show Formulas

Show all formulas in a worksheet, rather than the resulting values.

To show formulas in the worksheet instead of the resulting values, click on ‘Tools’ from the main menu bar. From the resulting drop-down, click on ‘Options’. This opens the ‘Options’ wizard. In the ‘Options’ wizard, under ‘LibreOffice Calc’, click on ‘View’.

Then under ‘Display’, we have a checkbox called ‘Formulas’. If this checkbox is checked, then the formulas will be shown in the worksheet instead of the results, but if the checkbox is unchecked, then the results of the formulas will be shown. This is how we can display formulas in a worksheet in place of resulting values.