Xls to pdf

[Tony5FA7]

Hi

when I convert an xls or xlsm file to pdf if chops off everything below the A4 level and goes to the next sheet, im not concerned with printing the pdf just saving it, is there a way to keep the extended length.

thanks