Page… (or Page Style) -
Sheet tab, for Scaling mode: (below Scale) select
Fit print range(s) on numbers of pages,
Select the cells to print, and choose menu
See LibreOffice Help on Scale.
Tested with LibreOffice 126.96.36.199 (x86); OS: Windows 6.1.
Add Answer is reserved for solutions. If you think the answer is not satisfactory, add a comment below, or click edit (below your question) to add more information. Thanks.
Check the mark ( → ) to the left of the answer that solves your question.
If the answer helped you, you can mark the up arrow () that is on the left (to vote, you need to have karma of at least 5).