View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jacob Skaria Jacob Skaria is offline
external usenet poster
 
Posts: 8,520
Default How can I expand print area to whole page?

From FilePrint PreviewPageSetupchange 'Adjust to % of normal size' from
100% to whatever suitable.

If this post helps click Yes
---------------
Jacob Skaria


"Manny" wrote:

I have an excel 2007 sheet in landscape format, all margins set to zero, no
unnecessary space is part of the print area.

The print area itself fits all in one page with leftover space on both sides
of the page. How can I expand the print area so that when it prints it takes
up the whole page without manually increasing the font, row heights, and
column widths?

I remember being able to do this last year but dont recall how I
accomplished this.