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.
You need to set the orientation and print settings in each sheet separately. Manually, you'd use the options on the Page Layout ribbon for that.
Sheet1 can be portrait with print area set from A1 to G30, for example. Sheet2 can be landscape with print area set from A1 to Q26, for example and scaled to print on one page.
Select each sheet individually and see the correct print preview.
Select both Sheet1 and Sheet2, or use "Print Entire Workbook" and the print preview will show Sheet1 in portrait and Sheet2 in landscape.
Here are some screenshots of the print preview, page 1 and page 2.