Without more details about what you are printing, I would suggest that you
simply delete all manual page breaks. Excel will automatically fill each
page with data when it prints.

"Eric" wrote:

I need some help. I generate an Excel report 2x a week for my boss. This
report usually has between 25-30 pages to it using Landscape. I try to reduce
the number of pages by manually adjusting each page while in Page Break
Preview, IE, move the Blue lines. Is there a way to highlight the entire
spreadsheet and "auto fit" each page so that when it prints, each page will
be full?

Thanks