0

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.

Improve this question

1 Answer 1

Reset to default
2

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.

enter image description here

enter image description here

Improve this answer
9
  • I tried selecting Sheet 1 as 100% and Sheet 2 as fit to page width. It did not work when I print entire workbook. I am using excel 2010.
    – Kim Stacks
    Aug 7, 2013 at 3:06
  • Hmm, it works fine for me. Can you post a file with dummy data that shows the problem? I added screenshots of what I see on my system.
    – teylyn
    Aug 7, 2013 at 5:49
  • evernote.com/shard/s32/sh/35d29817-ef3f-4c6f-8b59-4cb6ec407c7d/…
    – Kim Stacks
    Aug 8, 2013 at 1:17
  • Can you elaborate on what you intend to do and what does not work? I see three sheets, all set up for landscape. The Summary sheet prints at 100% and the next two sheets print at custom resolution set to 1 page wide by 100 [sic!] tall.
    – teylyn
    Aug 8, 2013 at 2:16
  • 1
    You never mentioned Mac until just now. If you are a Mac user, you may be aware that some things work differently on a Mac than on a Windows machine. I think it is instrumental to cite your operating system when you use a niche product instead of the common standard. Sorry, I cannot help with the Mac aspect. The problem does not exist in Excel for Windows. Maybe you want to ask the question in a Mac forum instead.
    – teylyn
    Aug 9, 2013 at 10:24

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .