Page formatting while converting xls files to pdf

I have a very lengthy xls file. I am trying to convert it to pdf using libreoffice. But LO is adding page breaks on its own and making the content of the pdf look broken. Is there a way for me to specify where to add page breaks during the conversion? Also, my xls is of constant width. What can I do to fit into A4 size without losing columns.

Just format print ranges:
Ctrl+Shif+O (or File-Page Preview ) and then set scaling mode

Tab Sheet

Thanks John. Is there a way to insert page breaks at user’s preferred rows while using --convert-to ?