I want a copy of the spreadsheet showing the formulas to help me trace mistakes in my budget spreadsheet but if I try to print the sheet showing the formulas it prints the numbers.
Try to check “Formulas” in Format-Page menu, tab “Sheet”
You may need to set the appropriate column widths before this.
Hi
Two different needs, two procedures:
- to display the formulas:
View
▸Show Formula
orTools
▸Options
▸Calc
▸View
▸Formulas
- to print the formulas:
Format
▸Page
▸Sheet
tab▸Print
▸tickFormulas
See also this extension (Warning: the extension seems not to display the text of the functions).
Regards