On Thu, 21 Apr 2011 19:18:06 +0200, Domanda wrote:



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

Alan,
the page breaks are nicely put, Zoom is at 100%, and the preview show
me the two pages properly, but TWO pages, not one. As the option to
have 2 pages on 1 sheet is selected via printer option.

My feeling is that -ALTHOUGH I select the print are exactly like my
table- Excel consider 1 page as my talbe PLUS the with under it. Try
to visualize an entire page, even blank. Then if you want TWO of THESE
entire pages (not just your table) on the same page, Excel rotate the
orientation and scale the tables down.
This is the only way to understand it. It become obvious if you put
-as I did jjust to experiment- a footnote among the print options
(like date or number page).
anyone with the same issue?
i dont know what to do, it sounds incredible to me.
I also manually changed sheet margins, so now the date and page number
at bottom of the pages are right under the last row of my tables, but
still excel leaves a lot of empty space between the two tables and
rotate them on the vertical...scaling them down...