Tired of struggling with page break preview? Try this instead:
Choose File-->Page Setup
Then, choose Fit to: 1 page(s) wide by BLANK tall. When you leave the # number of pages tall BLANK, Excel figures out the best formatting to print your entire spreadsheet.
Use this tip, and you will never have to choose page break preview again.