I have two sheets in a .xlsx file.
The first sheet uses columns A to C and fits into a single landscape orientation A4 size paper.
The second sheet will fit into a single landscape orientation A4 size paper width with infinite pages tall. It uses columns A to L.
But when I select both sheets to print or when I select Print Entire Workbook, the preview always shows the second sheet to have some of the columns "chopped off".
If I print each sheet separately, it is fine. Of course the words on the printed first sheet look bigger than the words on the printed second sheet. I believe the second sheet is scaled down to about 47% in order to fit into the width of a landscape A4. The first one retains the 100% scale.
Another option is I choose to print both sheets at a scale of 47%. But of course, that means the first sheet does not maximize the width of the printed page and the words will look unnecessarily small on the first printed sheet.
My question is:
is there a way to print both sheets in a single print command while retaining the different scales for both sheets using Excel 2007 and 2010?
If the method involves preparing the Excel xlsx file in some way, I would like to know as well.
Currently, I am using PHPExcel to generate this xlsx file for an enterprise client hence the request.
The client is not tech savvy and I want to find out just how possible this can be achieved.
Answers need not involve knowledge of PHPExcel. I will simply take your Excel related answers and figure out how to accomplish it using PHPExcel.