On Excel, I can fit the entire sheet on one page when printing. Under scaling, it says “fit sheet on one page.”
How do I do this under Calc?
Thank you.
Hello,
set Format -> Page -> Tab: Sheet -> Category: Scale -> Option: Scaling Mode -> Drop Down: Fit print range(s) on number of pages -> Option: Number of Pages: -> Value: 1
Hope that helps.
Two caveats/corrections to the answer provided:
- Note that this is no longer under Format > Page, but under Format > Page Style…
- More importantly, you cannot alter this setting (so the option is greyed out and not available) if the document is not editable.
On the other hand, since version 6.4 there’s a Whole sheet export feature, so if your intention is to export to PDF, it might fit your needs.
Thanks Mike, I did use that so I could then scale it up to better fill the page, since Calc left huge margins and made the writing too small. (I scaled it up in Draw.)