Excel Printing issue

[maniac36]

I have an excel workbook (Excel for Mac 2011) that has 370 lines. The width of the columns are narrow enough to get two pages of the workbook on one sheet in landscape. The problem is when I go to print I can't seem to get the two pages to print on one sheet, it prints one page on the sheet with a large blank section to the right. In print setup there is an option to print multiple pages on one sheet, but that still doesn't work. Any help would be appreciated. I've done multiple searches on Google with no success. Is this even possible withing Excel?

[Alf]

Not sure if this will work for the Excel Mac version but when using a print macro a code snippet like this set printing area to 1 page

Please Login or Register  to view this content.

i.e. Zoom property must be set to false before setting "PagesWide" and "PagesTall"

Alf