View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
ARogers ARogers is offline
external usenet poster
 
Posts: 1
Default Print Preview and hard copy cut off in mid page

My problem is that when printing a multi-page worksheet (all text) the print
is cut-off about mid-page. I have set the margin edge-to-edge of the page
and have made sure no row exceeds 409.5 height (though that shouldnt make a
difference in printing). The first five pages lose print in the lower half
of the page (there is about 3-4" of white space on page and missing text),
but the last page fills the page from top margin to bottom margin, so I know
its possible. I can find no different settings between any of the pages and
the page breaks are automatically set by Excel, not manually by me. I have
deleted all page breaks several times to be sure. Is there, perhaps, some
new switch set in 2007 that wasnt in 2003, that keeps it from allowing print
to fill the page from top margin to bottom margin?