Excel 2003 Printing - Page Breaks

[SteveStad]

I am trying use page breaks to display/print worksheet without reducing (compressing) the size to small.
My worksheet is 8 col by 78 rows -- print range is A1 to H78. I inserted a page break after row 37. I selected Landscape and 'Fit to; 1pg wide and 2 pg tall. It reduces to 46% of normal size when I print preview or print the worksheet. I changed all margins to .25 (top, bottom, left, right). I thought page breaks would print/display a larger size view. Also page breaks seem to disapear - off/on.

 

[powerdink]

Try setting you print layout to 1 page wide by... and leave the width blank.

Then print pages 1 through 2 and see if that works.

 

[SteveStad]

Powerdink - Thanks for reply. I tried adjusting as you described. When the 'adjust to __% of normal size" is greater than 50% or 60% of normal size it automatically adds a page 3 and page 4. If I just print page 1 and 2 it prints out large enough. But I can accomplish the same thing by setting the print range originally in the worksheet to the equivalent of what the computer defaults to page 1 and page 2.