Excel landscape pages print small ("print all worksheets")
When using "print all worksheets" to create a single pdf from a multi-worksheet excel file, landscape pages are problematic. If a worksheet spills over onto more than one page, then page 1 is fine within the pdf file, but page 2 invariably prints out small scale at top left hand corner of the next page. Then the pdf file reverts to normal page size for the next worksheet page in the sequence. I checked page size and dpi - all set to A4, 300dpi so that's not the problem. Couldn't find solution so cut and pasted large worksheet into four smaller worksheets, all taking 1 page. This time the first 3 pages were fine, but page 4 in the sequence again printed small at top left hand corner. I'm going mad here, can anyone help? Thanks a million.