View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] alanglloyd@aol.com is offline
external usenet poster
 
Posts: 38
Default Printing and scaling: why does Excel behave in such a way? PLZ HELP!!!

On Apr 20, 10:42*pm, Domanda wrote:
today I set my print area, my page breaks, and since it was long, i
chose an A3 paper sheet, LANDSCAPE oriented.
The output was 2 *A3 pages, which you'd read "horizontally", exactly
as you'd expect after selecting Landscape.

My tables occupied only the TOP part of the sheet, in both sheets.
So I ingenuinely thought "I can have the two pages on the same sheet!"
SO I chose "print two page on the same sheet" on my printer
preferences

THe result was a VERTICALLY Oriented A3 paper, with the two previous
page reduced/scaled down, almost unreadable, with a lot of empty space
around them. You could argue that the two tables were
'landscape'...but the result was not what I had in mind.

I think this is the same questionhttp://www.excelbanter.com/showthread.php?t=130837

is there a solution?
Which is the reason behind this behaviour?

thanks a lot in advance


Did you check in View | Page Break View (for page breaks), in File |
Page Setup (for Margins & Size Magnification - even though you've
specified Fit To, on re-entry to Setup, Magnification will be what it
does), and in File | Print Preview (for correct paginating) ?

Alan Lloyd