Excel Pagination ?

[Guest]

I have a very long Excel document. When I print preview it I get pages full
of rows and pages with just a few rows because the page breaks are unevenly
spaced throughout the worksheet.
How do I fix this problem without have to fix each page break one at a time?

 

[Guest]

Try this:

View>Page Break Preview

For individual manually inserted page breaks:
Drag them off the page

To clear ALL manually inserted page breaks:
Right-click in any cell and select: Reset all page breaks

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro