Fit PDF of spreadsheet to landscape page

I wish to export my Spreadsheet as a single page PDF but with Landscape orientation. I can not find the requisit Page controls in any menu item.
My LO version is 24.8.3.
My Windows is 10 V22H2

Depending on your version of LO, you may find it under Format | Page Style on the Page tab.

1 Like

…and for all on a single page select the Sheet tab, under Scaling mode select Shrink print range(s) on number of pages, choose 1

David Robley.

Thank you for your prompt assistance.

After your suggestion I set up the printer Page configuration - Orientation, Margins etc;
Set up the cells to be “printed” and did a Print Preview. I then scaled the object and adjusted margins.

While still in Print Preview, I went to File/Export as pdf and who-la the self same object appeared in the Pdf viewer.

Thank you again. I could not select the cells nor configure from within the Exporter.

And Thank Libre Office - Great Products.

Bill (Willem) Lindemans
(Australia)